Step 4: Create Bracket Tables
In this example we are assuming the following:
- For employees with 0 to 6 months of service, the employer matches employee contribution up to 1% of gross pay
- For employees with more than 6 months of service, the employer matches employee contribution up to 5% of gross pay
First we will set up a Length of Service table
- Go to Human Resources / Maintain / Benefits / Benefit Bracket Tables
- Setup a bracket table with the Bracket ID "LOS"
- From the dropdown choose the Bracket Type of "Length of Service"
- Set one bracket: Enter a max amount ".5". This will represent % of years. The system automatically assumes another bracket column of > .5 to Max.
- Save the table
Next we will create another bracket table to define the employee contribution percentages.
- Go to Human Resources / Maintain / Benefits / Benefit Bracket Tables
- Setup a bracket table with the Bracket ID "EC%"
- From the dropdown choose the Bracket Type of "Employee Benefit Percent "
- Enter values in the brackets to correspond with available employee percentages. In the example on the left, we use whole numbers from 1-10 representing 1% to 10%.
- Save the table