Setting Up Calculation Tables

Access the Calculation Table form.

Note: You do not need to include a line in the calculation table for zero amounts. For example, if vacation time is not earned in the first year of employment, you do not need to include that year on the first line of the calculation table. The first line could start with 2.00 as the lower limit.

Table Code

Enter the code for the calculation table. You may want to assign the calculation table the same code as the DBA to which it corresponds unless you plan to use the calculation table for multiple DBAs.

Table Type

Enter a code that defines the purpose of the table. 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

Enter a code that specifies to the JD Edwards EnterpriseOne Payroll system a table to be accessed in the Payroll Generic Tables table (F069026). The values that you enter in this field must be numeric.

Table Method

Enter a code that specifies the method in which the DBA is calculated.

Accrue Days

Select this option if you want the system to accrue hours based on a number of days. If you select this option, the system calculates the number of hours to accrue by multiplying the value in the Amt./Rate field by the standard-hours-per-day that is set up for the employee. In addition, the system also treats the values in these fields as days, rather than hours:

Additional Rate
Amt./Rate 2
Limit Amount
Excess Rate

If you do not select this option, the values in the rate fields represent hours, not days.

This field appears only when the value in the Table Method field begins with O, P, L or S.

Weeks of Service

Select this option if you want to base employee service requirements on the number of weeks, rather than the number of months of service. If you select this option, the values in the Upper Limit and Lower Limit fields represent weeks, not months.

This field appears only when the value in the Table Method field begins with O, P, L or S.

Amt./Rate (amount/rate)

Enter the amount or rate to be used in the calculation of a DBA. The system uses this field when the method of calculation specifies a 1, 2, 3, 4, 5, or 6, and therefore a specific basis table is retrieved for the ultimate calculation of the transaction.

Upper Limit

Enter the upper or maximum amount to be compared.

Lower Limit

Enter the lower or minimum amount to be compared.

Additional Rate

Enter the rate for the system to use in the calculation of the transaction, using the table setup. The amount specified here overrides any other rate that might be retrieved through the standard hierarchy for accrual, benefit, or deduction calculation.

Amt./Rate 2 (amount/rate 2)

Enter the amount or rate that the system uses in the calculation of an accrual, benefit or deduction. The system uses this field when the method of calculation specifies a 1, 2, 3, 4, 5, or 6, and therefore a specific basis table is being retrieved for the ultimate calculation of the transaction.

Limit Amt. (limit amount)

Enter the maximum amount that can be withheld or accrued in a year for a deduction, benefit, or accrual. This amount is expressed in dollars for a deduction or benefit and in hours for an accrual.

For the JD Edwards EnterpriseOne Payroll system, this field can represent either an initial annual limitation or a final limitation in a year.

If the Annual (Level 1) field is not blank, this amount represents the first level of the yearly limitation. The value in Annual (Level 2) represents the final limitation.

If an annual limit is specified on a DBA calculation table, the annual limit from the table takes precedence over annual limits defined at the master DBA or employee levels.

Rollover Table

Enter the identification number of the rollover table that the system uses to limit the amount that can be rolled over for an accrual. The limit is based on an employee's months of service. For example, the table can specify that an employee with 0 to 12 months of service can roll over up to 40 hours, and an employee with 13 months of service or more can roll over up to 80 hours. You must enter a code in this field if you enter a code in the SM field.

S M (Secondary Method)

Enter a code from UDC 06/DS that indicates what method to use for the calculation of DBAs.

Excess Rate

Enter a rate that the system applies to the amounts that exceed the table defined amount.