12.12. Import Lookup Tables

To import a table:

Click the display list in the Find: Lookup Tables window.
Select Import from the pop-up menu.

You see the Import Table wizard that guides you through the steps for importing a lookup table.

Import Table Wizard #

Ellipses button

The first page of the wizard is where you specify the CSV file to import the lookup table. Click the Ellipses button to find the file to import. After you select a file, you see the name of the file in the

File Name field, and the first few lines of the table appear in the Sample Data list at the bottom of the window.

Specify Table Properties #

The second 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 in SICS Life or Estimated Subject Premium Income Distrubution in P&C.

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, Fixed Monetary 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. This property applies only to Lookup Tables in SICS Life.

Currency: If you selected Fixed Amount as the amount type, use this drop-down list to select a currency. This property applies only to Lookup Tables in SICS Life.

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.

Review Table Column Types #

The third page of the wizard lets you review the column types for each column heading, before attempting to import the table. When you click next, the input file will be validated against these column types.

Review Table Column Definitions #

The fourth page of the wizard allows you to review the imported column definitions and also to specify the age column if there is one.

Click Next to see the final page of the Import Lookup Table wizard. Click Finish, and the table will be imported into the database.