This chapter contains these topics:
You set up calculation tables to define the parameters the system uses to calculate DBAs. After you set up your calculation tables, you can review the Calculation Tables report to verify that the information that you entered on the calculation tables is accurate. After you set up your calculation tables, you attach the table to the DBA by specifying the table code and appropriate table method when you set up a DBA.
Setting up DBA calculation information includes the following tasks:
Setting Up Calculation Tables
Attaching Calculation Tables to DBAs
Reviewing the Calculation Tables Report
Reviewing the DBA Table Method Codes Report
From Canadian Payroll Master (G77), enter 29
From Payroll Setup (G774), choose Pay/Deductions/Benefits
From Pay/Deductions/Benefits Setup (G7742), choose Calculation Tables
You set up calculation tables to define the parameters for calculating DBAs that are based on variable values. You define valid ranges and amounts that are a function of certain method codes.
Calculation tables contain user defined information to more completely define the standard DBA methods of calculation. Calculation tables provide the following features:
User defined tables
Calculations based on values that vary from employee to employee
When you define a calculation table, you must first determine what the calculation is based on, for example:
Age
Annual salary
Months of service
Hours worked in a pay period
After you have defined the calculation table, you must determine the appropriate method of calculation. The calculation tables only work with certain method of calculation codes. The method of calculation indicates what the ranges in the table represent, such as age ranges or salary ranges. The method of calculation codes include the following:
Code | Description |
---|---|
0 | Withholding periods |
1 | Salary range |
2 | Date range |
3 | Age range (calculated by date of birth or DOB) |
4 | Hours worked |
5 | Pieces produced |
6 | Variable periods |
8 | Gross pay range |
9 | Age (calculated as of the date you enter in the Employee Age field on Pay Rate Information) |
Z | Spouse's age by actual DOB |
For example, to base a DBA on employee age, you can use codes 3 or 9 for the method of calculation.
Browse through the list of table methods and choose one appropriate to the method of calculation. Read the description to find one that matches how you want the system to perform the calculation.
You can enter multiple ITD limits for a single accrual. Accruals with ITD limits also take into account all current pay period activity related to the accrual. If current pay period taken amounts bring an employee below the ITD limit, the accrual calculates in that same payroll cycle. The accrual will stop calculating if the employee is at or above the ITD limit. If vacation time is taken during the payroll to reduce the employee's current vacation amount below the ITD limit, the accrual calculates again up to the ITD limit.
Note:
The ITD limits you enter in the calculation table override the ITD limit in the F19 (Previous) screen of the accrual.Complete the following fields:
Table Type
Table Code
Table Method
Explanation
To define the parameters of the table, complete the following fields:
Lower Limit
Upper Limit
Amount or Rate
Complete the following optional fields:
Excess Rate
Secondary Calculation Method (SM)
Secondary Calculation Table
Repeat steps 2 and 3 as often as necessary to define all the parameters needed for the table.
Field | Explanation |
---|---|
Table Type | A code that defines the purpose of the table. Valid values are:
D – The system uses the table to calculate DBAs. R – The system uses the table to determine limits for rolling over sick and vacation accruals. |
Table Code | A numeric code that identifies this table in the Table file (F069026). |
Table Method | A code that specifies the method the system uses to calculate the DBA.
Form-specific information This code indicates the type of information in the Amount field, for example, hours or dollars. |
Lower | The lower or minimum amount to be compared. |
Upper Limits | The upper or maximum amount to be compared. |
Amt./Rate | The amount or rate the system uses to calculate a DBA. When you enter 1, 2, 3, 4, 5, or 6 as the method of calculation, you must enter a value in this field to use in the calculation in conjunction with the basis table. |
Rate | A rate that the system applies to the amounts that exceed the table defined amount. |
S M | A user defined code (07/DS) that indicates which method the system uses to calculate DBAs.
Form-specific information The secondary method the system can use in calculating the DBA. When the system uses the secondary method, the first table serves as an eligibility table. Eligibility on the primary table is based on salary range, date range, and age range, in that order. |
Sec Table | A code which specifies the method under which the DBA is to be calculated.
This calculation table serves as the secondary calculation table for the system. You must enter a code in this field if you enter a code in the secondary method field. |
See Also:
From Canadian Payroll Master (G77), enter 29
From Payroll Setup (G774), choose Pay/Deductions/Benefits
From Pay/Deductions/Benefits Setup (G7742), choose DBA Setup
After you set up your calculation tables, attach the table to the DBA by entering the table code on DBA Setup.
To attach calculation tables to DBAs
On DBA Setup
Complete the following fields:
Method of Calculation
Table Code
Complete the remaining steps for setting up a DBA.
See Also:
From Canadian Payroll Master (G77), enter 29
From Payroll Setup (G774), choose Pay/Deductions/Benefits
From Pay/Deductions/Benefits Setup (G7742), choose Calculation Tables
The Calculation Tables Report provides a listing of the calculation tables by table code. Review this report to verify that the information you entered on each calculation table is accurate.
From Canadian Payroll Master (G77), enter 29
From Payroll Setup (G774), choose Pay/Deductions/Benefits
From Pay/Deductions/Benefits Setup (G7742), choose Table Method Explanations
The DBA Table Method Codes report provides a listing of each table method code followed by the description of the table method. This menu selection uses World Writer to print the report.
Figure 44-4 DBA Table Method Codes report