Frequency tables

Benefits uses frequency tables to establish employee benefit deductions. They are also used in flex plans to determine the deduction amount for standard time records.

You define annual contributions for benefit plans, and the table provides the divisor to determine the amount of each deduction so you are not required to define separate contribution amounts for each of the possible pay frequencies.

When you define a benefit plan, you assign a frequency table. You can assign the same frequency table to every plan or they can be unique.

Note: 

You must 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.

Frequency table components

Frequency tables are made up of contribution divisors for each 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.

A frequency table consists of a Divisor for each pay frequency. These are examples of frequency tables.

Every Cycle Occurrences (example 1) Once Every Month Occurrences (example 2)
Pay Frequency Divisor Pay Frequency Divisor
Weekly 52 Weekly 12
Bi-Weekly 26 Bi-Weekly 12
Semi-Monthly 24 Semi-Monthly 12
Monthly 12 Monthly 12

Divisor fields

Benefits 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 (see table), the Benefits 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 (see table), the deduction is only taken once a month, and the amount of the deduction would be $25 (300/12). The annual contribution is divided by 12 regardless of pay frequency, since the deduction is only taken once a month, or 12 times each year.