DBA Table Methods

Five general, arbitrary categories of DBA table methods are available. The methods are distinguishable by the basis of the DBA method. 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

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