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.