Frequency table

This is a table the Benefits Administration application uses to establish employee benefit deductions. The Benefits Administration application also uses frequency tables in Flex Plans, to determine the amount for standard time records.

You can define annual contributions for benefit plans, and the table determines the amount of each deduction and when the deduction must be included in the payroll cycle for all employees, regardless of their pay frequency. This way, you do not have to define separate contribution amounts for each of the possible pay frequencies.

Frequency table components

Frequency tables are made up of contribution divisors and deduction cycles by employee pay frequency. A frequency table is required for all plans that create a deduction or standard time record for an employee. The frequency table must be the same for all benefit plans under a flex plan.

Example

A frequency table consists of one Divisor and nine Deduction Cycle fields for each pay frequency. This is an example of a frequency table.

Table 1 - every cycle occurrences

Deduction cycles
Pay frequency Divisor 1 2 3 4 5 6 7 8 9
Weekly 52 X X X X X
Bi-Weekly 26 X X X
Semi-Monthly 24 X X
Monthly 12 X

Table 2 - once a month occurrences

Deduction cycles
Pay frequency Divisor 1 2 3 4 5 6 7 8 9
Weekly 12 X
Bi-Weekly 12 X
Semi-Monthly 12 X
Monthly 12 X

Uses of the divisor and deduction cycle fields

The Benefits Administration application uses the Divisor field to determine the amount for deductions and standard time records. For example, an employee has a benefit with a $300 annual contribution. The employee's pay frequency is weekly. Using example 1, the Benefits Administration application determines the deduction amount by dividing the contribution by the Divisor of the employee's pay frequency. The employee's deduction for the benefit is $5.77 ($300/52).

Using example 2, the deduction will only be taken once a month, the amount of the deduction will be $25 (300/12). The annual contribution is divided by 12 regardless of pay frequency, since the deduction will only be taken once a month, or 12 times each year.

The Deduction Cycles fields determine when the Infor Payroll application deducts the employee contribution from the employee's payment, or when the Infor Payroll application adds the standard time record. For a monthly frequency in the table shown above, the Infor Payroll application takes deductions only during the first payroll cycle.

See the Infor Payroll User Guide.

About using the table

When you define a benefit plan, you assign a frequency table to the plan. You can assign the same frequency table to every plan. If the divisor or the deduction cycles are different by plan, then you can assign a different frequency table to each plan.

Note:  You need to update the employee deductions and standard time records before the next payroll cycle if you assign a different frequency table to a benefit plan or change a frequency table assigned to a benefit or a flex plan.

See Plan maintenance: benefit plans.