Table Methods

Table methods contain the programming rules that tell the system how to calculate table method DBAs using the information that you define in the calculation table. Before you set up calculation tables, you should determine which table method to use to accurately calculate the amount or rate of the DBA. Five general, arbitrary categories of DBA table methods are available. Methods are distinguishable by which DBA methods they are based. This table lists the categories and available calculations:

Category

Available Calculations

Salary Amounts:

Pay Period

Monthly

Annual

Life Insurance

2nd Life Insurance

Spouse Life Insurance

For the salary figure, you can perform one of these calculations:

  • Table amount × Employee rate

  • Salary × Employee rate × Table amount

  • Table amount = actual DBA amount

  • Hours worked × Table amount

  • Gross earnings × Table amount

  • Salary × Employee rate. Result rounded down × Table amount

  • Salary × Employee rate. Result rounded up × Table amount

  • Salary × Table amount × Excess rate

Employee Age:

Based on the employee age, you can perform one of these calculations:

  • Salary × Employee rate × Table amount

  • Salary × Employee rate. Result rounded down × Table amount

  • Salary × Employee rate. Result rounded up × Table amount

  • Salary × Employee rate. Result rounded down ÷ 1000

  • Salary × Employee rate. Result rounded up ÷ 1000

  • Salary × Table amount × Excess rate

Dates:

Leave of Absence

Original Hire

Participation Start

For each date, you can perform one of these calculations:

  • Table amount × Employee rate

  • Table amount × Employee rate (calculates hours only)

  • Table amount × Hours worked (can optionally calculate Rate × Hours)

  • Table amount × Hours worked (calculates hours only)

  • Table amount × Hours worked

  • Table amount = actual DBA amount

  • Table amount × Gross earnings

  • Annual salary × Table amount × Excess rate

  • Pay-period salary × Table amount × Excess rate

  • Monthly salary × Table amount × Excess rate

  • Life insurance salary × Table amount × Excess rate

  • 2nd life insurance salary × Table amount × Excess rate

Amounts:

Hours

Gross Amount

Flat Dollar

You can perform various calculations against an employee pay rate, hours, and gross wages. These calculations include:

  • Average hourly rate

  • Range from the detail area of the table

Miscellaneous:

Pay-Period Number

Variable Months

Retirement Employer Match

Excess Life Insurance

You can use various tables, depending on:

  • Pay-period number for the month

  • Number of months of history to use as a basis

  • Employee retirement contributions

  • Group term life insurance premiums

If a table method uses only the table amount to calculate the amount or rate of DBA, then you must use a table code to override the DBA. In this case, the system does not recognize an override by amount or rate.