Define Lookup Tables

12.13. Define Lookup Tables

Defining Lookup Tables can only be done in SICS Life.

To define a table:

  1. Click the display list in the Find: Lookup Tables window.
  2. Select Define from the pop-up menu.
  3. You see the Define Table wizard that guides you through the steps for defining a lookup table.

1_DEFINE_LOOKUP_TABLE.png

The first page of the wizard is where you specify the initial properties of the table.

Table Type: Use the drop-down list to select the table type for this table. Select from values such as Proportional Premium Rate Table and Deductions Table.

Table Name: Enter the Business name for the table that will allow you to easily identify the table when in use.

Table Description: This is a free text field where you can type in a full description of the table.

Amount Type: Use the drop-down list to select Fixed Amount, Percent or Permille.

Interpolation Rule: Use the drop-down list to select No Interpolation, Linear Interpolation, Years Value Only or Years Value Plus One.

This will be used when discrete values are defined in the table, but intermediate values appear during calculation. For example: The table has a duration column defined in whole years, but the duration at calculation time is 1 year and 3 months.

Currency: If you selected Fixed Amount as the amount type, use this drop-down list to select a currency.

Rate/Amount Heading: Enter the heading for the financial measure column. This will default from the column definition in the CSV file.

Status: Indicate the status of the table. Choose from Active or Inactive. Active means that the table may be attached to business. Inactive means that it may not.

2_ENTER_COLUMN_VALUE.png

The second page of the wizard is where you define the columns and column values. Select a Column Name from the drop-down list and click the Add button. The Enter Column Values window appears.

3_ENTER_COLUMN.png

Add a column value by entering the value terms, and clicking Add. If you want to delete a column value, select it, select Delete from the pop-up menu. Click Save to confirm the values. To delete a column, select it, select Delete from the pop-up menu. To edit the column values, select the column and click the Add button.

Click Next to see the next page of the wizard where you review the column definitions and specify the age column if there is one.

Click Next to see the final page of the Define Lookup Table wizard. Click Finish, and the table definition will be added to the database, and table entries will be created for all possible combinations of the column values. The rate/amount column in the defined table entries will contain zero. You must now edit the table to specify the values to be used by the table.