Skip to content

PenFormat: Non Standard

Variable Name

This column will show the non-standard Variable Name loaded from the data file. Where possible, the user should use a descriptive name for the variable to enable easier identification at a later stage. All non-standard Variables should be prefixed with a q.

Column Specifications

  • Non Standard Current From
  • Non Standard Current To
  • Non Standard From
  • Non Standard To
  • Non Standard Date Format

For each of the non-standard data fields, this will show the start and end columns of where the data item is located in the data file.

For date fields, specify the date format e.g. DD/MM/CCYY. The year portion must have 4 digits.

Previous Data Column Specifications

  • Non Standard Previous From
  • Non Standard Previous To

If Analysis of Surplus calculations are required it is necessary, for each of the numeric non-standard data fields, to specify the start and end columns of where the data item applicable at the previous valuation date is located in the data file.

If the value of a numeric field has not changed over the inter-valuation period, the same columns (exactly) can be specified for both the current and previous data items.

Description

It is possible to give each non-standard data field an optional description for easier identification.

Adding or deleting Columns

Right-clicking on a column heading presents a menu with the following options which allow you to expand or reduce the number of columns of data to be entered:

  • Add a new column(s) to the right of the grid;
  • Insert a new column at the position of the cursor; and
  • Delete the current column at the position of the cursor.

Grid editing options

Right-clicking on the Top Left Corner of the grid displays a menu which allows you to set the following Grid Editing Options:

  • Editing of a cell can be invoked by either clicking on the cell or by pressing F2 when the cell is active (Clicking will only change the current active cell); and
  • determine the cursor movement once editing is complete to be either to the next cell down, the next cell to the right or to stay in the current cell.

The Import button

Pressing the Import button pops up a window which allows you to import a Superval/21 data format.

The Display button

Pressing the Display button pop-ups a window which allows you to display a member record with a ruler to determine column specifications.

On the Display window, you can specify the name of the data file (.dat file) and record number from that file.

Save As

Click the Save As button to save with a new parameter description.

Save

Clicking on the Save button allows you to save the entries.

Quit

Clicking on the Quit button allows you to exit without saving any of your changes.

In some of the screens you will be asked to confirm if you want to exit Ignoring all changes. If you click Yes, the file will be closed without saving any changes. If you click No you will be returned to your original screen.