Skip to content

DefFormat: 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.

Current From

Current To

From

To

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 From

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.

Grid Help

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 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 Help

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.

Migrate

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

Display

Using the Display button while looking at Rate Tables will display the changes made to the currently specified rate table.
Pressing the Display button elsewhere 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.

SaveAs

Click the Save As button to save with a new file name.

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.

From the Browser, the Quit button will take you to a graphical display of the results.