Benefit rate tables

Use rate tables to test for specific conditions or perform complex calculations to set the rate for a benefits plan. For example, you can set up a rate table that calculates different premiums based on whether the employee coverage includes a spouse or dependent children.

Note: You cannot have more than one benefit plan reference the same rate table. For example, if you will want five benefit plans to reference a rate table for an HMO plan, set up five separate rate tables with the same values, naming them HMO1, HMO2, HMO3, HMO4, and HMO5. You can use the Copy Table button on the Benefit Rate Table Setup page to copy a rate table with the same rates, but then enter a different code and description.

Caution! If your company uses Sage ESS, never change or remove a rate table that is currently in use in a life event or attached to a life event that has not yet been transferred to Sage HRMS.

  1. Select Setup > Codes > Employees > Benefits > Rate Table Setup.
  2. On the Benefit Rate Table Setup page for Employer, select the employer with whom you want to work.
  3. Click Add.

  4. On the Benefit Rate Table Setup Detail page, enter the Code and Description. When you set up a benefit plan, you reference the rate table by this code.

  5. On the Column 1 tab:

    1. For Column Heading, enter a column heading for the first condition you want to check, such as Insured Child.

    2. For Column Match Types, select one of the following types:

      • Exact Match. If the condition Sage HRMS is checking for exactly matches a condition in the rate table, Sage HRMS uses the associated rate.
      • Up To and Including. If the condition Sage HRMS is checking for falls within a range in the rate table, Sage HRMS will use the associated rate. Use this type for a coverage, premium, or contribution amount since they usually fall within a range.

      • Cumulative. Normally used for savings plans, such as a different employer match for different percentages the employee contributes to the savings plan.

        An employer matches dollar for dollar employee contributions up to the first 4% of their salary, only matches $.50 on the dollar on the next 2%, and then $.25 on the dollar for the next 2%.

    3. For Column Expression, enter a function or expression. You can either type the expression or click the Expression Builder button, build the expression, and click OK.

      To count the number of insured children an employee has, type:

      COUNTDEP("HMO1","CHILD")

      Sage HRMS will count the number of dependents who are enrolled in the HMO1 benefit plan and who are defined as a child.

      If you use Sage Employee Self Service and are setting up a rate table expression to be used in a benefit plan for life events or open enrollment, the expressions can only reference records from the following tables:

      Table Name

      Table

      Alias

      Benefit Plan Set Up

      HBePlan

      BT

      Employee Benefit Plan

      HBene

      BE

      Employee Personnel

      HRPersnl

      PE

      Dependent Benefits

      HDepben

      DB

      Employee Dependents

      HDepend

      DE
  6. For each condition you want to check, repeat step 5 on the next column tab.

  7. Click the Rate Table tab.

    Notice that the table includes the columns you specified. Now you can set the order and rates for these conditions.

When you set rates for the conditions you are checking for, you specify the order in which Sage HRMS checks the conditions and the rates it should use for those conditions.

  1. On the Rate Table tab of the Benefit Rate Table Setup Detail page, set up the first rate:

    1. Click Add.

      Sage HRMS automatically inserts the number 1 in the Order column of the first row.

    2. Press Tab (to move to the first column) and enter the value for the first condition.
    3. Press Tab (to move to the next column) and enter the value for the second condition.
    4. If there are additional conditions, press Tab (to move to the next column) and enter the value for that condition. Repeat this step for all conditions.

    5. Press Tab (to move to the Rate column) and enter the rate (without the dollar sign) associated with this combination of conditions.

      Note: Do not exceed 251 characters in the Rate column.

    6. Press Enter to save this first rate (and move back to the Order column).
  2. Repeat the process in step 1 to add additional rates (clicking Add for each new rate) until you've completed all of the rates, which are shown in the table on this tab.
  3. When complete, click OK to save the rate table and return to the Benefit Rate Table Setup page. Notice the new rate table was added to the list of rate tables.

Now that you have set up the rate table, you can add the benefit plan that uses that rate table.

  1. Select Setup > Codes > Employees > Benefits > Rate Table Setup.
  2. On the Benefit Rate Table Summary page for Employer, select the employer with whom you want to work.
  3. Select the existing rate table you want to copy, and then click More.
  4. On the Benefit Rate Table Setup Detail page, click Copy Table to copy the original rate table to a new rate table).
  5. In the Copy Benefits Rate Table window, enter a unique Code and a Description for the new table.
  6. Click OK.
  7. If needed, make changes to the tabs on the Benefit Rate Table Setup Detail page.
  8. Click OK to save the rate table and return to the Benefit Rate Table Setup page. Notice the plan was added to the list of rate tables.