x

Step 5: Create Benefit Rate Table

Now we need to link the values between the two bracket tables by establishing a rate table

  1. Go to Human Resources / Maintain / Benefits / Benefit Rate Tables
  2. Setup a rate table with the Rate Table ID "401KM" give it a description of "401K Matching"
  3. Choose a Table Type of "Variable"
  4. For Row Definition we will choose Bracket Table as the Data Source and choose the bracket ID of "EC%" (employee contribution percentages)
  5. For Column Definition we will choose Bracket Table as the Data Source and choose the bracket ID of "LOS" (Length of Service)
  6. For "Value in Cells" choose "Percent"
  7. Save the table