TIMERECORD

Employee Time Records

The Employee Time Cards file contains information that is used to compute an employee's pay. It is the primary input file to PR140 (Earnings and Deductions Calculation). There are many programs that create time records. PR199 (Payroll Close) deletes the Employee Time Cards file records that were used during the payroll cycle.

REFERENCED BY
HR04.9 PR05.1 PR09.1 PR24.1 ZP139 PR141
PR160 PR180 PR229 HR170 HR70.1 PR142
PR274


UPDATED BY
BN134 BN150 BN305 BN66.1 HR11.1 HR11.2
HR11.4 HR28.1 HR511 LT101 LT111 PR521
ZH510 EXI2.1 EXI4.1 LP130 LP353 LP54.1
PA02.1 PA100 PA102 PA115 PA13.1 PA13.2
PA502 PA513 PA52.1 PA52.3 PA52.4 PA52.5
PR110 PR113 PR115 PR12.6 PR120 PR128
PR13.1 PR13.5 PR13.6 PR13.8 PR13.9 PR131
PR132 PR134 PR135 PR136 PR137 PR138
PR139 PR140 PR189 PR195 PR197 PR29.1
PR30.2 PR32.1 PR32.2 PR33.1 PR33.2 PR33.3
PR35.1 PR35.2 PR35.3 PR35.4 PR35.5 PR35.6
PR35.8 PR35.9 PR36.1 PR36.4 PR37.1 PR38.1
PR39.1 PR45.1 PR512 PR529 PR530 PR539
PR560 PR582 PR80.1 PR80.4 PR82.1 PR85.1
PR89.1 PRAT.1 UK102 TA147 HR00.1 HR01.1
HR02.1 HR06.1 HR506 PA95.1 PR01.2 PR20.4

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TRD-COMPANY
Element: Company Hr
Numeric 4
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-TIME-SEQ
Element: Time Seq
Numeric 12
Contains the sequence number of the time record.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-STATUS
Element: Status
Numeric 1
Contains the status of the time record.
0 = Unreleased (Batch)
1 = Future
2 = Current
3 = Error
4 = Processed
5 = Manual
BN150 BN66.1
EXI2.1 EXI4.1
LP130 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR139 PR140
PR189 PR195
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR38.1
PR39.1 PR45.1
PR521 PR529
PR530 PR539
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1 TA147
UK102
TRD-BATCH-NBR
Element: Batch Nbr
Numeric 6
Contains the batch number to which the entered time records belong.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-PROCESS-LEVEL
Element: Process Lev Hr
Alpha 5
Contains the employee's home process level.
...
BN150 BN305
EXI2.1 EXI4.1
HR11.1 HR11.2
HR11.4 HR28.1
HR511 LP130
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR131 PR132
PR134 PR135
PR136 PR137
PR189 PR29.1
PR30.2 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
TRD-DEPARTMENT
Element: Department
Alpha 5
Contains the employee's home department.
...
BN150 BN305
EXI2.1 EXI4.1
HR11.1 HR11.2
HR11.4 HR28.1
HR511 LP130
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR131 PR132
PR134 PR135
PR136 PR137
PR189 PR29.1
PR30.2 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
TRD-PAY-SUM-GRP
Element: Pay Sum Grp
Alpha 3
Contains the pay summary group associated with the pay code.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-JOB-CODE
Element: Job Code
Alpha 9
Contains a user-defined code that identifies a type of job.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-PAY-CODE
Element: Pay Code
Alpha 4
Contains the pay code. A pay code is a user-defined code that identifies a kind of pay.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-HOURS
Element: Hours
Signed 7.2
Contains the hours associated with the time record.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR195 PR197
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
PR85.1 TA147
UK102
TRD-RATE
Element: Rate
Signed 13.4
Contains the rate of pay associated with the time record.
BN150 BN66.1
EXI2.1 EXI4.1
LP130 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR140 PR189
PR195 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 PR85.1
PR89.1 PRAT.1
TA147 UK102
TRD-WAGE-AMOUNT
Element: Wage Amount
Signed 13.2
Contains the total wage amount for the time record as calculated according to the calculation type defined for the pay code, the employee's rate of pay, salary class, and the number of hours entered.
BN150 BN66.1
EXI2.1 EXI4.1
LP130 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR138 PR140
PR189 PR195
PR197 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1 TA147
UK102
TRD-SHIFT
Element: Shift
Numeric 1
Contains the shift number associated with the pay.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-CHECK-GRP
Element: Check Grp
Alpha 1
Contains a value that identifies a check group. All time records with a common entry in this field are grouped on one payment record for the employee. A number in this field indicates the deduction cycle the system uses for calculating deductions on the payment.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-PROCESS-GRP
Element: Process Grp
Alpha 1
Identifies a process group. All time records with a common value in this field are grouped for taxing purposes within a check group for an employee. A number in this field indicates the deduction cycle the application uses for calculating deductions on the payment.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-TR-DATE
Element: Tr Date
Numeric 8 (yyyymmdd)
Contains the time record date. The application uses the time record date to determine which time records to process in PR38.1 (Time Record Selection) or PR137 (Batch Time Record Update).
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-DIST-PROC-LEV
Element: Process Lev Hr
Alpha 5
Contains the process level to which the system distributes wage expenses.
BN150 BN66.1
EXI2.1 EXI4.1
LP130 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR140 PR189
PR195 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1 TA147
UK102
TRD-DIST-DEPART
Element: Department
Alpha 5
Contains the department to which the system distributes wage expenses.
BN150 BN66.1
EXI2.1 EXI4.1
LP130 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR140 PR189
PR195 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1 TA147
UK102
TRD-DST-ACCT-UNIT
Element: Acct Unit
Alpha 15
Contains the general ledger accounting unit to which the application posts the wage expense amount
BN150 BN66.1
EXI2.1 EXI4.1
LP130 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR140 PR189
PR195 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1 TA147
UK102
TRD-DST-ACCOUNT
Element: Account
Numeric 6
Contains the general ledger account to which the application posts the wage expense amount.
BN150 BN66.1
EXI2.1 EXI4.1
LP130 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR140 PR189
PR195 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1 TA147
UK102
TRD-DST-SUB-ACCT
Element: Sub Acct
Numeric 4
Contains the general ledger subaccount to which the application posts the wage expense amount.
BN150 BN66.1
EXI2.1 EXI4.1
LP130 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR140 PR189
PR195 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1 TA147
UK102
TRD-DIST-COMPANY
Element: Company
Numeric 4
Contains the company number to which a transaction is posted. A valid intercompany relationship must be defined in the General Ledger application.
BN150 BN66.1
EXI2.1 EXI4.1
LP130 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR140 PR189
PR195 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1 TA147
UK102
TRD-PCT-DIST-FLAG
Element: Pct Dist Flag
Alpha 1
Contains the value that indicates if employee override distributions exist in the Emp Acct Distribution Override file. When the value is Y (Yes), PR150 (Distribution Edit) and PR199 (Payroll Close) use the override accounts to create Employee Payment Distribution file and GL Interface File records.
Y = Distribution override exists
N = No override exists
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-ERROR-FLAG
Element: Error Flag
Alpha 1
A value of Y (Yes) in this field indicates an error in processing the time record. PR130 (Time Record Interface) uses this field to indicate if a field from the interface time record does not pass the edits. If a field from the interface time record does not pass the edits, the system creates the time record with this field set to Y (Yes). Time record entry programs then use this field to determine if editing is still necessary.
Y = Created with errors
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-CHECK-ID
Element: Check Id
Numeric 12
Contains the payment identification number generated by the time record.
BN150 BN66.1
EXI2.1 EXI4.1
LP130 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR140 PR189
PR195 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1 TA147
UK102
TRD-CHECK-TYPE
Element: Check Type
Alpha 1
Contains the payment type.
S = System
M = Manual
J = Adjustment
G = Gross Up
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-SCHEDULE
Element: Schedule
Alpha 9
Contains the value that identifies a step and grade schedule.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-PAY-STEP
Element: Pay Step
Numeric 2
Contains the step number from the step and grade schedule.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-PAY-GRADE
Element: Pay Grade
Alpha 3
Contains the grade from the step and grade schedule.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-ANNUAL-SALARY
Element: Annual Salary
Signed 13.4
Contains the calculated annual salary used for salaried employees when the time record contains step and grade information or is using an alternate pay rate.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-ATTEND-CODE
Element: Attend Code
Alpha 2
Contains the attendance code used for creating Employee Attendance History records in PR199 (Payroll Close) The Time and Attendance system uses this field.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-OCCURRENCE
Element: Occurrence
Alpha 1
Contains the value that indicates if the referenced time is a new occurrence or a continuation of an existing occurrence. The Time and Attendance application uses this field.
Y = Yes
N = No
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-PCD-SEQ-NBR
Element: Pcd Seq Nbr
Numeric 8
Contains the sequence number associated with the time record relative to the pay code.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-TAX-STATE
Element: Tax State
Alpha 2
Contains the 2-digit state code that represents the employee's resident state.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-WORK-STATE
Element: Work State
Alpha 2
Identifies the state in which the workers' compensation plan is effective. This field stores the work state for withholding purposes.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-UNION-CODE
Element: Union Code
Alpha 10
Contains the union code associated with the time record.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-PER-BEG-DATE
Element: Per Beg Date
Numeric 8 (yyyymmdd)
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-PER-END-DATE
Element: Per End Date
Numeric 8 (yyyymmdd)
Contains the pay period end date which is determined by the employee's pay plan and the time record date.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-OT-PREM-AMT
Element: Ot Prem Amt
Signed 13.2
Contains the overtime amount associated with the time record.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
PR85.1 TA147
UK102
TRD-SHIFT-DIFF
Element: Shift Diff
Signed 13.2
Contains the differential from the pay code for the shift entered on the time record.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
PR85.1 TA147
UK102
TRD-WC-CLASS
Element: Wc Class
Alpha 4
Contains the workers' compensation classification associated with the job code entered on the time record.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-OT-RECORD
Element: Ot Record
Alpha 1
Contains the value that indicates if the time record was created for retroactive, overtime, flex time, or tips pay.
Y = Yes
R = Retro
F = Flex
T = Tips
U = Updated
X = Exception Processed
O = Offset Time Record
P = Payout
C = Created by Employee Contract
I = Created by BN150
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-WRK-BEG-DATE
Element: Wrk Beg Date
Numeric 8 (yyyymmdd)
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-WRK-END-DATE
Element: Wrk End Date
Numeric 8 (yyyymmdd)
Contains the work period end date which is determined by the employee's pay plan and the time record date.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-SUPP-TAX-CODE
Element: Supp Tax Code
Alpha 2
Contains the supplementary tax code associated with the time record.
BN150 EXI2.1
EXI4.1 LP130
PR115 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
TRD-LOCAT-CODE
Element: Locat Code
Alpha 10
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-WC-STATE
Element: Wc State
Alpha 2
Contains the workers' compensation state associated with the time record.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-PAY-PERIODS
Element: Pay Periods
Numeric 2
Contains the number of times a bonus is paid during the year. The system uses this value to annualize the payment. This is used with bonus type pay codes and is referred to as the Aggregation with Pay Periods method.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-POSITION
Element: Position
Alpha 12
Contains the user-defined code that represents a position in the company.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-ACTIVITY
Element: Activity
Alpha 15
Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-ACCT-CATEGORY
Element: Acct Category
Alpha 5
Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-ATN-OBJ-ID
Element: Obj Id
Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR38.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
TRD-GLT-OBJ-ID
Element: Obj Id
Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR38.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
TRD-TIME-ACC-FLAG
Element: Time Acc Flag
Alpha 1
Contains an L (Last) if an employee is terminating employment with the company and you are issuing the final payment through PR80.1 (Manual Payment).
A = Created by LP Neg Bal Options
BN150 BN66.1
EXI2.1 EXI4.1
LP130 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR140 PR189
PR195 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1 TA147
UK102
TRD-SHFT-DIFF-RATE
Element: Shft Diff Rate
Signed 13.4
The rate used to calculate the shift differential.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-SH-OBJ-ID
Element: Sh Obj Id
Numeric 12
The object id of the shift table used in calculating the SHIFT-DIFF and SHIFT-DIFF-RATE.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR195 PR197
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
PR85.1 TA147
UK102
TRD-OT-RATE
Element: Ot Rate
Signed 13.4
Contains the overtime rate.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-AC-UPDATED
Element: Ac191 Updated
Alpha 1

Y = Yes
" " = No
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-TAX-COUNTY
Element: Tax County
Alpha 10
Contains the county taxing authority code.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-TAX-CITY
Element: Tax City
Alpha 10
Contains the city taxing authority code.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-TAX-SCHOOL
Element: Tax School
Alpha 10
Contains the tax school.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-TAX-TRANSPORT
Element: Tax Transport
Alpha 10
Contains the transport tax code.
TRD-SEGMENT-FLAG
Element: Segment Flag
Alpha 1
Defines if segment block data exists for the time record.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR195 PR197
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
PR85.1 TA147
UK102
TRD-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-TAX-FREQ-OVER
Element: Tax Freq Over
Numeric 3
Number of Pay Periods Per Year that is used to determine how to calculate amount of taxes withheld.
001 = Weekly
002 = Biweekly
003 = Semi-monthly
004 = Monthly
005 = Daily
006 = Quarterly
007 = Semi-annually
008 = Annually
009 = 9 Month Academic Monthly
010 = 10 Month Academic Monthly
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-COUNTRY-CODE
Element: Country Code
Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-PAYMENT-TYPE
Element: Payment Type
Alpha 2
Contains the payment type.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-REMUN-CODE
Element: Remun Code
Alpha 4
Contains the remuneration code. Valid value is C001 = Bonus.
E002 = US Pay Advances
E003 = US Athletic Facilities
E004 = US Non-Qual Plan Awrds and Prz
E005 = US Back Pay
E006 = US Bonuses
E007 = US Business Expense
E009 = US Gifts
E010 = US Commissions
E013 = US Discounts
E014 = US Dismissal/Severance
E015 = US Educational Assistance
E016 = US Employment Agency
E017 = US Qual Equip/Tool/Uniform
E018 = US Business Use of Company Car
E019 = US Personal Use of Company Car
E020 = US No Additional Cost Services
E021 = US Golden Parachute
E022 = US Group Legal Services
E023 = US Guaranteed Wage
E024 = US Jury Duty Pay
E025 = US Below Market Loans to Empl
E026 = US Meals and Lodging
E027 = US Supplemental Military Pay
E028 = US Qualified Moving Expenses
E029 = US Non-Cash Fringe
E030 = US Outplacement Services
E031 = US Overtime
E032 = US Qualified Parking
E033 = US Pre-employment Reimbursmnt
E034 = US Probationary Pay
E035 = US Regular Wages
E036 = US Scholarships
E037 = US Sick/Disability Pay
E038 = US Standby/Idle Time
E039 = US Stock Purch & Incentive Pln
E040 = US Supper Money
E041 = US Supplemental Unemployment
E042 = US Taxes Paid by Employer
E043 = US Tips
E044 = US Travel; Exp Reimbursement
E045 = US Tuition Reimbursement
E046 = US Union Pay
E047 = US Vacation Pay
E048 = US Group Term Life G.T. 50000
E049 = US Ministers Housing Allowance
E999 = US Custom Earnings
E051 = US Income Under Section 409A
E052 = US Transportation CHV
E055 = US Commuter Benefits
E067 = US Tips Non-Taxable
E068 = US Diff Pay - Active Mil Duty
E070 = US EE Adult Child Hlth Ins
E071 = US ER Adult Child Hlth Ins
BN150 EXI2.1
EXI4.1 LP130
PR115 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
TRD-REPORT-ENTITY
Element: Report Entity
Alpha 5
Contains the report entity. Report Entity is the Process Level or Company that this Process Level reports to for tax reporting. If the Process Level itself is independent then the independent Process Level is the Report Entity. If the Process Level is non independent and is associated to a independent head Process Level then the independent head Process Level is the Report Entity. If the Process Level is non independent and is not associated to a independent head Process Level then the Company is the Report Entity.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-BUS-NBR-GRP
Element: Bus Nbr Grp
Alpha 4
Contains the business number group.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-QC-ENT-NBR-GRP
Element: Qc Ent Nbr Grp
Alpha 4
Contains the Quebec enterprise number group.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-CA-WC-CLASS
Element: Ca Wc Class
Alpha 10
Contains the Canadian WC Class from employees job. Use to identify the PRTIME wages by WC Class.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-PENS-SEQ-NBR
Element: Pens Seq Nbr
Numeric 4
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-PAY-UNITS
Element: Pay Units
Signed 7.2
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-UNIT-MEASURE
Element: Unit Measure
Alpha 12
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-USER-ID
Element: User
Alpha 10 (Lower Case)
...
BN150 BN305
BN66.1 EXI2.1
EXI4.1 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LP130 LP353
LP54.1 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR115
PR12.6 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR131 PR132
PR134 PR135
PR136 PR137
PR138 PR139
PR140 PR189
PR195 PR29.1
PR30.2 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
TRD-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
...
BN150 BN305
BN66.1 EXI2.1
EXI4.1 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LP130 LP353
LP54.1 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR115
PR12.6 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR131 PR132
PR134 PR135
PR136 PR137
PR138 PR139
PR140 PR189
PR195 PR29.1
PR30.2 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
TRD-NON-EARNINGS
Element: Non Earnings
Numeric 1

0 = No - wages
1 = Yes - other remuneration
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-ORIG-OBJ-ID
Element: Orig Obj Id
Numeric 12
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-RECORD-TYPE
Element: Record Type
Alpha 1
Identifies adjustment status for Databasics and Grants. Blank = Normal (not adjusted) 1 = Adjustment Offset 2 = Adjustment Entry 3 = Adjustment on Adjustment Additional values identify time records created from GM170: 4 = Cost Transfer Reversing Entry 5 = Cost Transfer Adjusting Entry
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-LEAVE-STATUS
Element: Leave Status
Numeric 1
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-REASON-CODE
Element: Ta Reason Cd
Alpha 4
BN150 EXI2.1
EXI4.1 LP130
LP54.1 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
TRD-TES-OBJ-ID
Element: Tes Obj Id
Numeric 12
BN150 EXI2.1
EXI4.1 LP130
LP353 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
TRD-RETRO-PENSION
Element: Retro Pension
Alpha 1

" " = No
N = No
Y = Yes; open payment
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-SERVICE-CODE
Element: Ta Service Cd
Alpha 10
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
...
BN150 BN305
BN66.1 EXI2.1
EXI4.1 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LP130 LP353
LP54.1 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR115
PR12.6 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR131 PR132
PR134 PR135
PR136 PR137
PR138 PR139
PR140 PR189
PR195 PR29.1
PR30.2 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
TRD-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-CREATE-USER-ID
Element: User Id
Alpha 10 (Lower Case)
Contains the user ID of the person who last changed this record.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-LNK-TIME-SEQ
Element: Time Seq
Numeric 12
Used to associate user created time records with LP created time records.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-CONT-SEQ-NBR
Element: Cw Cont Seq No
Numeric 12
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-CONTRACT-YEAR
Element: Contract Year
Numeric 4
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-CWC-EFFECT-DT
Element: Effective Dt
Numeric 8 (yyyymmdd)
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-CONTRACT-NBR
Element: Seq Number
Numeric 6
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-SEGMENT-NBR
Element: Seq Number
Numeric 6
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-CYC-START-DATE
Element: Pay Start Date
Numeric 8 (yyyymmdd)
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-CYC-END-DATE
Element: Pay End Date
Numeric 8 (yyyymmdd)
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-CM-REG-FLAG
Element: Flag Num
Numeric 1

0 = Non-contract
1 = Regular pay
2 = Reserve pay
3 = Docking pay
4 = Adjustment
5 = Summer Deferral
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-CM130-FLAG
Element: Flag Num
Numeric 1

0 = No
1 = Yes
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-MEMO
Element: Text Comment
Alpha 64 (Lower Case)
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-ABN-OBJ-ID
Element: Abn Obj Id
Numeric 12
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-EXP-RPT-NBR
Element: Invoice
Alpha 22
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-REC-TYPE
Element: Seq Nbr
Numeric 4
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TRD-NOTIONAL
Element: Notional
Signed 13.4
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR138
PR189 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
TRD-ADDTL-RATE
Element: Addtl Rate
Numeric 1
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102


TIMERECORD FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TRDSET1 COMPANY
EMPLOYEE
TIME-SEQ
...
BN134 BN150
BN305 BN66.1
HR00.1 HR01.1
HR02.1 HR04.9
HR06.1 HR11.1
HR11.2 HR11.4
HR28.1 HR506
HR511 LT101
LT111 PR521
ZH510 EXI2.1
EXI4.1 LP130
LP353 LP54.1
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
TRDSET10 COMPANY
PROCESS-LEVEL
EMPLOYEE
WRK-END-DATE
PAY-CODE
JOB-CODE
TR-DATE
TIME-SEQ
KeyChange, Subset
WhereSTATUS =Zeroes
LP130 PR135
TRDSET11 COMPANY
PROCESS-LEVEL
EMPLOYEE
TR-DATE
TIME-SEQ
KeyChange, Subset
WhereSTATUS =1
LP130 PR135
PR137
TRDSET12 COMPANY
PROCESS-LEVEL
EMPLOYEE
TIME-SEQ
KeyChange
...
BN150 BN66.1
PR521 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR139
PR140 PR141
PR189 PR195
PR197 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
TRDSET13 COMPANY
EMPLOYEE
PENS-SEQ-NBR
TIME-SEQ
KeyChange, Subset
WherePENS-SEQ-NBR !=Zeroes
...
BN150 PR521
EXI2.1 EXI4.1
LP130 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR160 PR180
PR189 PR195
PR197 PR229
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
TRDSET14 COMPANY
GLT-OBJ-ID
TIME-SEQ
Subset
WhereGLT-OBJ-ID !=Zeroes
TRDSET15 COMPANY
EMPLOYEE
ATTEND-CODE
TR-DATE
TIME-SEQ
KeyChange, Subset
Where(LEAVE-STATUS =2)
Or(LEAVE-STATUS =3)
Or(LEAVE-STATUS =4)
TRDSET2 COMPANY
BATCH-NBR
TIME-SEQ
Subset
WhereERROR-FLAG !=Spaces
...
BN150 PR521
EXI2.1 EXI4.1
LP130 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
TRDSET3 COMPANY
EMPLOYEE
TR-DATE
TIME-SEQ
KeyChange, Subset
WhereSTATUS =1
PR135 PR38.1
TRDSET4 COMPANY
PROCESS-LEVEL
EMPLOYEE
CHECK-GRP
REPORT-ENTITY
BUS-NBR-GRP
SUPP-TAX-CODE
PROCESS-GRP
TIME-SEQ
KeyChange, Subset
WhereSTATUS =2
OrSTATUS =3
OrSTATUS =4
OrSTATUS =5
BN134 BN66.1
LP130 PR128
PR131 PR132
PR135 PR138
PR140 PR189
PR195 PR36.1
PR36.4 PR45.1
PR80.1 PR80.4
PR89.1 PRAT.1
UK102
TRDSET5 COMPANY
BATCH-NBR
EMPLOYEE
WRK-END-DATE
PAY-CODE
JOB-CODE
TR-DATE
TIME-SEQ
KeyChange, Subset
WhereSTATUS =Zeroes
...
BN150 PR521
EXI2.1 EXI4.1
LP130 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.7
PR35.8 PR35.9
PR36.1 PR36.4
TRDSET6 COMPANY
PROCESS-LEVEL
EMPLOYEE
CHECK-GRP
REPORT-ENTITY
BUS-NBR-GRP
SUPP-TAX-CODE
PROCESS-GRP
TIME-SEQ
KeyChange, Subset
WhereSTATUS =3
BN66.1 PR132
PR140 PR189
PR195 PR36.1
PR36.4 PR80.1
PR80.4 PR89.1
PRAT.1
TRDSET7 COMPANY
PCD-SEQ-NBR
EMPLOYEE
TIME-SEQ
KeyChange
...
BN150 PR521
EXI2.1 EXI4.1
LP130 PR115
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
TRDSET8 COMPANY
EMPLOYEE
CHECK-ID
PAY-SUM-GRP
TIME-SEQ
KeyChange, Subset
WhereCHECK-ID !=Zeroes
...
BN150 BN66.1
HR170 HR70.1
PR521 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR139
PR140 PR141
PR142 PR160
PR180 PR189
PR195 PR197
PR274 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
TRDSET9 COMPANY
ATN-OBJ-ID
TIME-SEQ
KeyChange, Subset
WhereATN-OBJ-ID !=Zeroes


TIMERECORD FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acct Category ACACCTCAT Required
When TRD-ACCT-CATEGORY !=Spaces
TRD-ACCT-CATEGORY->AAX-ACCT-CATEGORY
Activity ACACTIVITY Required
When TRD-ACTIVITY !=Spaces
TRD-ACTIVITY->ACV-ACTIVITY
Acuom ACUOM Required
When TRD-UNIT-MEASURE !=Spaces
TRD-UNIT-MEASURE->UOM-UNIT-MEASURE
Attend Code ATTENDCODE Required
When TRD-ATTEND-CODE !=Spaces
TRD-COMPANY->ATC-COMPANY
TRD-ATTEND-CODE->ATC-ATTEND-CODE
Batch Number PRBATCH Required
When TRD-BATCH-NBR !=Zeroes
TRD-COMPANY->PRB-COMPANY
TRD-BATCH-NBR->PRB-BATCH-NBR
Company PRSYSTEM Required
TRD-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Department DEPTCODE Required
When TRD-DEPARTMENT !=Spaces
TRD-COMPANY->DPT-COMPANY
TRD-PROCESS-LEVEL->DPT-PROCESS-LEVEL
TRD-DEPARTMENT->DPT-DEPARTMENT
Dist Account GLMASTER Required
When TRD-DST-ACCOUNT !=Zeroes
TRD-COMPANY->GLM-COMPANY
TRD-DST-ACCT-UNIT->GLM-ACCT-UNIT
TRD-DST-ACCOUNT->GLM-ACCOUNT
TRD-DST-SUB-ACCT->GLM-SUB-ACCOUNT
Employee EMPLOYEE Required
TRD-COMPANY->EMP-COMPANY
TRD-EMPLOYEE->EMP-EMPLOYEE
Job Code JOBCODE Required
When TRD-JOB-CODE !=Spaces
TRD-COMPANY->JBC-COMPANY
TRD-JOB-CODE->JBC-JOB-CODE
Pay Code PRPAYCODE Required
TRD-COMPANY->PCD-COMPANY
TRD-PCD-SEQ-NBR->PCD-SEQ-NBR
Pay Sum Group PAYSUMGRP Required
TRD-COMPANY->PSG-COMPANY
TRD-PAY-SUM-GRP->PSG-PAY-SUM-GRP
Paymastr PAYMASTR Not Required
Valid When TRD-CHECK-ID !=Zeroes
TRD-COMPANY->PYM-COMPANY
TRD-EMPLOYEE->PYM-EMPLOYEE
TRD-CHECK-ID->PYM-CHECK-ID
Pens Payment PRPENPAY Not Required
TRD-COMPANY->PNP-COMPANY
TRD-EMPLOYEE->PNP-EMPLOYEE
TRD-PENS-SEQ-NBR->PNP-PENS-SEQ-NBR
Process Level PRSYSTEM Required
TRD-COMPANY->PRS-COMPANY
TRD-PROCESS-LEVEL->PRS-PROCESS-LEVEL
Prqcentgrp PRQCENTGRP Not Required
TRD-COMPANY->PQC-COMPANY
TRD-PROCESS-LEVEL->PQC-PROCESS-LEVEL
TRD-QC-ENT-NBR-GRP->PQC-QC-ENT-NBR-GRP
Reason Code TAREASCODE Required
When (TRD-REASON-CODE !=Spaces )
TRD-COMPANY->TRE-COMPANY
TRD-REASON-CODE->TRE-REASON-CODE
Res County PRTAXAUTH Not Required
TRD-TAX-COUNTY->PRX-TAX-ID-CODE
Res School PRTAXAUTH Not Required
TRD-TAX-SCHOOL->PRX-TAX-ID-CODE
Res Transport PRTAXAUTH Not Required
TRD-TAX-TRANSPORT->PRX-TAX-ID-CODE
Resident City PRTAXAUTH Not Required
TRD-TAX-CITY->PRX-TAX-ID-CODE
Resident State PRSTATE Required
TRD-TAX-STATE->PSA-STATE
Service Code TASERVCODE Required
When (TRD-SERVICE-CODE !=Spaces )
TRD-COMPANY->TSC-COMPANY
TRD-SERVICE-CODE->TSC-SERVICE-CODE
Taempserv TAEMPSERV Not Required
Valid When TRD-TES-OBJ-ID !=Zeroes
TRD-COMPANY->TES-COMPANY
TRD-EMPLOYEE->TES-EMPLOYEE
TRD-TES-OBJ-ID->TES-TES-OBJ-ID
Tax Group C6TAXGRP Required
TRD-COMPANY->C6G-COMPANY
TRD-PROCESS-LEVEL->C6G-PROCESS-LEVEL
TRD-BUS-NBR-GRP->C6G-BUS-NBR-GRP
Trsgblck TRSGBLCK Not Required
TRD-COMPANY->TRS-COMPANY
TRD-EMPLOYEE->TRS-EMPLOYEE
TRD-TIME-SEQ->TRS-TIME-SEQ
Wc Province PRPROVINCE Required
When (TRD-WC-STATE !=Spaces )
And(TRD-CA-WC-CLASS !=Spaces )
TRD-WC-STATE->PPV-PROVINCE
Wc State PRSTATE Required
When (TRD-WC-STATE !=Spaces )
And(TRD-WC-CLASS !=Spaces )
TRD-WC-STATE->PSA-STATE
Work Province PRPROVINCE Required
When (TRD-WORK-STATE !=Spaces )
And(TRD-CA-WC-CLASS !=Spaces )
TRD-WORK-STATE->PPV-PROVINCE
Work State PRSTATE Required
When (TRD-WORK-STATE !=Spaces )
And(TRD-WC-CLASS !=Spaces )
TRD-WORK-STATE->PSA-STATE


TIMERECORD FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Penfsrc PRPENFSRC
TRD-COMPANY->PNF-COMPANY
TRD-EMPLOYEE->PNF-EMPLOYEE
TRD-PENS-SEQ-NBR->PNF-PENS-SEQ-NBR
  PNF-FUNDING-SOURCE
  PNF-RETRO-PAYMENT
Position PAPOSITION
Valid When TRD-POSITION !=Spaces
TRD-COMPANY->POS-COMPANY
TRD-POSITION->POS-POSITION
  POS-EFFECT-DATE


File created: Thu Jun 09 02:30:53 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.