Skip to content

Roll Forward: Changes

Data File(s)

Double click to select the filename (or filenames, if appropriate) of the member data files to be processed.

Data files may contain inactive members (exits and members who have joined after the valuation date) as well as active members.

The file(s) must be in the format specified in the data format.

If specification of only one file is allowed, a list of the allowable files specified on the Scheme Details will be presented with a Right Click. Note that any filenames used on that list will be relative value, that is, the filename specified is controlled by the label to the right of the field. If the filename is changed on the Scheme Details then the filename in the saved parameters will also change.

Data Format

The data format of the data file(s).

The data format are saved parameters specifying the column specification of each of the data items contained in the data file. Data format descriptions are prefixed by an indication of the type of format e.g. <Act> for Actives, <Def> for Deferreds, <Pen> for Pensioners.

If you intend to use the GMP Calculators to calculate GMPs after creating your data, ensure that columns are created in your data file for these fields. (In addition, enter dummy data into the data file for the first member that is at least as large as the largest expected GMP for all members. This will ensure that the Format created leaves sufficient space for the GMPs calculated.)

Data>Build

If you have created data using Data>Build then the format name will be the same as the original source (CSV) file or Excel file/tab name.

BasisModule>Migrate

If you have migrated your data files from earlier versions the name will be unchanged.

Exit Identifier 1

Select a data field to be used to identify members who have exited

Exit Identifier 2

Select a second data field to identify members who have exited. Selecting a second Identifier will display an additional column in the Exited Members grid

Calculate Estimated Benefit as Liability for Exited Members

Indicate if a liability for Exited Members is to be calculated based on an Estimated benefit.

Identifier 1

Enter the first Identifier of the Member who has exited the Scheme.

Identifier 2

Enter the second identifier value for the member who has exited the Scheme.

Date Of Exit

Define the Exited Member’s Date of Exit

Mode Of Exit (Estimated Liability)

Select a Mode of Exit

mode Actives Deferreds Pensioners
Withdrawal X
Ill-Health X
Retirement X X
Death X X X

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.

Delete Variation

Delete a set of adjustments

Add Variation

Add a new set of adjustments

Run

Click the Run button to run the calculations.

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.