Skip to content

Rate Tables

Rate Tables

The top node has the name of the Decrement File that is being displayed. This is the Decrement File for the Scheme that is contained in the Scheme Details.

Each type of Rate Tables has a parent node with a description of the Rate Tables. Rate Tables are displayed in the following order:

  • Decrement Rates
  • Salary Scales
  • Durational Weights
  • Proportion Married
  • New Entrant Tables
  • Annuity Tables
  • Miscellaneous tables.

Within each type Rate Tables are ordered by the Rate Table number.

Once an individual rate table has been selected, a graph of the rate table is shown on the upper right section of the screen. Double clicking on the graph will expand this. Once expanded, you can right-click to obtain additional functionality i.e. printing.

See the Infocus document called Using Rate Tables for more information on this area of SuperVal.

Table Number

The Table Number field is a display only field showing the Rate Table Code used to identify the Rate Table.

SuperVal Rate Tables can be prefixed by either upper case or lower case letter(s). (Previously all Rate Tables had upper case letter(s).) This acts to double the number of Rate Tables available but care must be taken to ensure the intended table is selected.

Rate Table Description

The description of the Rate Table for identification purposes.

Rates

  • Age
  • Rate
  • Duration

At the bottom of the screen, the values in the Rate Table are displayed in the ‘spreadsheet’.

The range of Rates that can be specified are:

  • ages 0 to 119 for Age related Rate Tables (including Miscellaneous X-tables)
  • durations 0 to 59 for Duration related Rate Tables (including Miscellaneous T-tables)
  • dimensions (related to Age (Y-axis) and Duration (X-axis) for decrement rates) of 120 values for 2-Dimensional Rate Tables (including Miscellaneous M tables).

The format of the Rates being entered will depend on the type of Rate Table being entered.

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 Select button

When the Rate Tables form has been called by double-clicking on a Rate Table field, a Select button will become available.

On pressing the Select button, the Rate Table form will be closed down and the currently highlighted Rate Table will become the value of the Rate Table field.

A Rate Table can also be selected by double-clicking on its node.

The Edit button

When a Rate Table is highlighted (and you have been given the appropriate access level), an Edit Button will become enabled.

On pressing the Edit button, the Rate Table (and its Rate Table number and description) can be modified.

Note that after the Edit button is pressed and until the editing is completed or aborted, the Rate Table file is locked to stop other users from making simultaneous changes to this Rate Table file (which may cause corruption of the file). Thus it is recommended that the shortest time possible be spent in this mode.

The Add button

When a parent node of a group of Rate Tables is highlighted (and you have been given the appropriate access level), an Add button will become enabled.

On pressing the Add button, the Rate Table number, description and rates can be specified.

Note that after the Add button is pressed and until the addition is completed or aborted, the Rate Table file is locked to stop other users from making simultaneous changes to this Rate Table file (which may cause corruption of the file). Thus it is recommended that the shortest time possible be spent in this mode.

The Delete button

When a Rate Table is highlighted (and you have been given the appropriate access level), a Delete Button will become enabled.

On pressing the Delete button, the Rate Table will, after confirmation, be deleted.

Note that after the Delete button is pressed and until the deletion is completed or aborted, the Rate Table file is locked to stop other users from making simultaneous changes to this Rate Table file (which may cause corruption of the file). Thus it is recommended that the shortest time possible be spent in this mode.

The Print button

Pressing the Print button enables the printing of Rate Tables. The Rate Tables printed will depend on the node that is highlighted when the Print button is pressed as follows:

  • If the top node (with the Rate Table filename) is highlighted, a printout of all Rate Tables on that Rate Table file will be prepared.
  • If Rate Table type description is highlighted, a printout of all Rate Tables of that type on that Rate Table file will be prepared.
  • If an individual Rate Table is highlighted, a printout of that particular Rate Table will be prepared.

Export

Click the Export button to export the rate table is either a CSV file or a XLS file. The exported file will be found in the Library folder of SuperVal.

For more information on Exporting Rate Tables, see the Infocus document called Using Rate Tables.

The View button

Pressing the View button enables the display of a 2-Dimensional Rate Tables in a larger frame.

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.