1. Payroll Implementation Guide
  2. Reviewing Detail History for DBAs

Reviewing Detail History for DBAs

Access the DBA Detail form.

Hours Worked

Displays the number of hours that are associated with each transaction.

Pieces

Displays the number of pieces for piecework or any other unit of measure that you want to track for this employee. Examples include recording miles that are driven for drivers of company vehicles, cubic yards of concrete, feet drilled, or miles flown.

Work Date

Displays the date that is used as the actual work date or pay-period ending date.

Pay Type

Displays the code that defines the type of pay, deduction, benefit, or accrual.

Pay types are numbered from 1 to 999. Deductions and benefits are numbered from 1000 to 9999.

Rate

Displays the employee's hourly rate. If applicable, the system adds values for pay type multiplier and shift differential.

If you change the value of the data display decimals for this field, you must also change the Hourly Rate (PHRT) and Base Rate (BHRT) fields in Time Entry to have exactly the same data display decimals.

Sub Ledger

Displays the value, such as equipment number or work order number, that you can attach to the end of an account number to further define an account and more easily track it.

Sub Type (subledger type)

Displays the code identifying the type of subledger in the previous field. If you enter a subledger, you must also enter a subledger type.

Check Control

Displays the number that is used to group all payroll transactions for each payment or individual interim payment. This number is carried into the accounting journal entries and facilitates the update of the actual check number after payment printing is complete. This number is also used for automatically voiding payments. The payment work table contains both the actual check number and the check control number. All associated payment transactions are automatically reversed using the check control number.

This is not the actual check number.

Account Number

Displays the value that identifies an account in the general ledger. Use one of these formats to enter account numbers:

  • Standard account number (business unit.object.subsidiary or flex format).

  • Third general ledger number (maximum of 25 digits).

  • Account ID (identification) number.

    The number is eight digits.

  • Speed code, which is a two-character code that you concatenate to the AAI item SP.

    You can enter the code instead of an account number.

The first character of the account number indicates its format. You define the account format in the General Accounting constants.

Item No. (item number)

Displays the item number (inventory) that the system uses when you are entering time for piecework earnings generation.

Shift

Displays the user-defined code (UDC) (00/SH) that identifies daily work shifts.

In payroll systems, you can use a shift code to add a percentage or amount to the hourly rate on a timecard.

For the Payroll and Time Entry systems, if an employee always works a shift for which a shift rate differential is applicable, enter that shift code on the employee's master record. When you enter the shift on the employee's master record, you do not need to enter the code on the timecard when you enter time. If an employee occasionally works a different shift, you enter the shift code on each applicable timecard to override the default value.

Union Code

Displays the UDC (06/UN) that represents the union or plan in which the employee or group of employees work or participate.

Units

Displays the UDC (system 00/type UM) that designates any unit of measure that is appropriate for an employee's time and pay.