Labor Acct Config

Labor Acct Config ancillary data defines components that make up general ledger (GL) account numbers at an agency.

Labor Acct Config ancillary data specifies the component names, number of digits, and data sources. Component values are obtained from client-specific database tables defined in client-specific DBDs and maintained using the Ancillary Builder screen.

For example, account numbers could include the following three components:

  • A 3-digit cost center or division number
  • A 5-digit account number
  • A 2-digit project number

Component values are used in Labor Accts ancillary data to define GL account numbers where labor costs can be allocated.

For the following ancillary data types, you can allocate all labor costs to one general ledger account:
  • Employee Types
  • OPS Job Classes
  • OPS Master Divisions
You can view and enter account numbers associated with these ancillary data types in the main ancillary data screens.
For the following ancillary data types, you can enter multiple labor cost allocations for multiple date ranges:
  • Absence Types
  • Extra Pay Types
  • Payroll Codes
  • Pass Category List
  • Run Types List
  • Runs Display
  • Work Subtypes

Contact your Trapeze representative before working with labour accounts information.

Table 1. Labor Acct Config Ancillary Data
Field Description
Calculation Formula SQL statement for obtaining GL account number component values and information from client-specific database tables.

Information includes primary and secondary inheritance values that specify where to inherit values for GL account numbers with wildcard characters.
Col Integer that uniquely identifies the GL account number component.
Column Name GL account number component name. This component name is used as a column header in Labor Accts ancillary data.
Column Size Number of digits in the GL account number component.
Field Name Name of field in the client-specific database table that contains possible values for the GL account number component.
Table Name Client-specific database table with possible values for the GL account number component.