Calculation Tables

When you enter a numeric value in the Method of Calculation field on the DBA Setup form, the system recognizes the DBA as a table method DBA, and requires you to attach a calculation table to it. Before you can attach a calculation table to a table method DBA, you must first define the calculation table. Calculation tables contain the parameters such as age or length-of-service ranges that the system needs to calculate the amount or rate of the DBA. You indicate which table method the system should use when you create calculation tables. It is important to select a table method that is compatible with the method of calculation you intend to use on the DBA Setup form. Two types of calculation tables exist. When you define a new calculation table, you indicate in the Table Type field if the table will be used to calculate DBA amounts or if the table will be used to determine limits for rolling over sick and vacation accruals. Most table method DBAs are used to calculate DBA amounts or rates, and most use a table type of D.

Rollover tables are calculation tables that the system uses to determine when, and how much accrued time to make available to an employee. When you set up a rollover table, you specify the table type of R.

Some DBA calculations are complex, and require more than one table to correctly calculate the amount. For example, an organization might have a vacation policy that determines the number of hours that an employee accrues each pay period based on the employee's length of service. However, the rollover limits or criteria might differ for each length of service grouping. Therefore, you can create several rollover tables to limit vacation rollover amounts and rollover vacation time. For example, you might create these rollover tables:

• Table 00001: Rollover table for employees who accrue 4 hours of vacation per pay period.

• Table 00002: Rollover table for employees who accrue 6 hours of vacation per pay period.

• Table 00003: Rollover table for employees who accrue 8 hours of vacation per pay period.

See Setting Up Rollover Information for DBAs

You then set up the calculation table for the vacation accrual using this data:

Months of Service (Lower Limit)	Months of Service (Upper Limit)	Hours Accrued Each Pay Period	Rollover Table
0	24	4 hours	00001
24.01	60	6 hours	00002
60.01	9999999.99	8 hours	00003

Using the data in this table, if an employee who has served between 0 and 24 months reaches their rollover date during a payroll cycle, the system uses rollover table 00001 to determine how much vacation time the employee can roll over.