Upload Rates from Select Table

Select tables are used when two indexes are needed for the rating strategy.

Steps to Create a Select Rate Group

  1. Navigate to Admin Explorer.

  2. Select and right-click on the Rate Groups folder.

  3. Select New Rate Group.

  4. Enter the Rate Description. This is a descriptive name that is used to identify the rates. It should be the name provided with the rate table. This name will be stored as the RateDescription in AsRateGroup and AsRate.

  5. Enter the Integer Criteria. This is the main index in the database table. Duration is always the Integer Criteria for Select tables.

  6. Enter the Rate Activation Date. This date is used in conjunction with a policy’s effective date to identify when a set of rates is active for a policy. The policy must be effective on or after the date listed here. Rate Activation Date is stored as EffectiveDate in the AsRateGroup table.

  7. Enter the Transaction From Date. Transactions that occur on or after this date will use the associated rates. Transaction From Date is stored as the ActiveFromDate in AsRateGroup.

  8. Enter the Transaction To Date. When loading new rates, this field should be left blank. The Transaction To Date is stored as the ActiveToDate in AsRateGroup.

  9. Enter the descriptions for Criteria 1 through Criteria 10 and select Next. The descriptions should be entered as they appear in the Excel spreadsheet. Criteria names must remain constant for all rate groups in the system. These criteria names will correlate to columns in your rate table. Criteria names are case sensitive so make sure the names match exactly.

Step 1 of select rate upload wizard

Step One of Rate Group Wizard

  1. Determine how the rates should be added.

    1. Select Yes and then Next to upload an Excel spreadsheet of Select rate information. Continue with the steps below for uploading an Excel spreadsheet.

    2. Select No and then select Finish to add rates manually using the Rate Group Editor.

  2. Browse to the location of the worksheet that contains the rates to upload.

  3. Specify Select as the table type (rate type) to be uploaded.

Important   Make sure the IntegerCriteria is listed as Duration.

  1. Enter the literal worksheet name (exactly as appears on the spreadsheet) in the Worksheet field.

  2. Enter the spreadsheet column identifier that contains the Initial Integer Criteria for the intended indexing strategy.

  3. Enter the starting and ending row numbers that contain the rates to be uploaded.

  4. Enter the Secondary Index criteria. In the screen shot above the Secondary Index is IssueAge.

  5. Enter the row on the spreadsheet where this secondary integer begins in the field labeled Secondary Index Row.

  6. Enter the starting and ending column letters that contain the rates to be uploaded in the fields labeled Start Column and End Column.

  7. Select the Select Period. There are several options. The option chosen will define the label of the last field on the screen.

  8. Enter the Duration. The Duration is typically 100 years.

Step 3 of select upload wizard

Step Three of Rate Wizard

  1. Select Add Row.

  2. Enter the code value for the first criteria. In the example above, this spreadsheet contains rates for a male smoker. The code value for male is 01.

  3. Enter the code value for the next criteria. In the example above, this spreadsheet contains rates for a male smoker. The code value for smoker is 01.

  4. Enter SI in the field for the secondary index. In the example above, the secondary index is Issue Age so SI is entered in that field.

  5. Select Finish. The rates will upload and display in the Configuration Area when complete.