Lawson Insight Technical Documentation |
|
TIMERECORD
TIMERECORD FILE
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
HR00.1 HR01.1 HR02.1 HR04.9 HR06.1 HR506
PR05.1 PR09.1 PR135 PR20.4 PR24.1 UK50.4
UK50.3 TA170 PR160 PR180 PR229 TA146
HR170 HR70.1 PR141 PR142 PR274 UK13.1
UK141 UK145 UK201 UK202
UPDATED BY
BN134 BN150 BN305 BN66.1 ET530 ETI2.1
HR11.1 HR11.2 HR511 LP130 LP54.1 PA02.1
PA100 PA102 PA115 PA13.1 PA13.2 PA502
PA513 PA52.1 PA52.3 PA52.4 PA52.5 PR110
PR113 PR115 PR120 PR128 PR13.1 PR13.5
PR13.6 PR13.8 PR130 PR131 PR132 PR134
PR136 PR137 PR139 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 PR37.1 PR38.1
PR39.1 PR45.1 PR529 PR530 PR539 PR560
PR80.1 PR82.1 PR85.1 PR89.1 UK102 UK330
UK560 TA147
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TRD-COMPANY Numeric 4 BN150 ET530
Element: Company Hr ETI2.1 LP130
PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-EMPLOYEE Numeric 9 BN150 ET530
Element: Employee Contains the employee number. Each ETI2.1 LP130
person employed by the company is PR128 PR130
assigned a unique number. The system PR131 PR132
uses the employee number to correlate PR134 PR136
all of the information related to that PR189 PR29.1
person. PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-TIME-SEQ Numeric 12 BN150 ET530
Element: Time Seq Contains the sequence number of the ETI2.1 LP130
time record. PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-STATUS Numeric 1 BN150 BN66.1
Element: Status Contains the status of the time record. ET530 ETI2.1
0 = Unreleased (Batch) LP130 PR128
1 = Future PR130 PR131
2 = Current PR132 PR134
3 = Error PR136 PR137
4 = Processed PR139 PR140
5 = Manual 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 PR37.1
PR38.1 PR39.1
PR45.1 PR529
PR530 PR539
PR560 PR80.1
PR82.1 PR89.1
TA147 UK102
UK560
TRD-BATCH-NBR Numeric 6 BN150 ET530
Element: Batch Nbr Contains the batch number to which the ETI2.1 LP130
entered time records belong. PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-PROCESS-LEVEL Alpha 5 BN150 BN305
Element: Process Lev HrContains the employee's home process ET530 ETI2.1
level. HR11.1 HR11.2
HR511 LP130
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
TRD-DEPARTMENT Alpha 5 BN150 BN305
Element: Department Contains the employee's home ET530 ETI2.1
department. HR11.1 HR11.2
HR511 LP130
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
TRD-PAY-SUM-GRP Alpha 3 BN150 ET530
Element: Pay Sum Grp Contains the pay summary group ETI2.1 LP130
associated with the pay code. PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-JOB-CODE Alpha 9 BN150 ET530
Element: Job Code Contains a user-defined code that ETI2.1 LP130
identifies a type of job. PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-PAY-CODE Alpha 4 BN150 ET530
Element: Pay Code Contains the pay code. A pay code is a ETI2.1 LP130
user-defined code that identifies a kind PR128 PR130
of pay. PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-HOURS Signed 7.2 BN150 ET530
Element: Hours Contains the hours associated with the ETI2.1 LP130
time record. PR128 PR130
PR131 PR132
PR134 PR136
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
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PR85.1 TA147
UK102 UK560
TRD-RATE Signed 13.4 BN150 BN66.1
Element: Rate Contains the rate of pay associated ET530 ETI2.1
with the time record. LP130 PR128
PR130 PR131
PR132 PR134
PR136 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 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 PR85.1
PR89.1 TA147
UK102 UK50.3
UK560
TRD-WAGE-AMOUNT Signed 13.2 BN150 BN66.1
Element: Wage Amount Contains the total wage amount for the ET530 ETI2.1
time record as calculated according to LP130 PR128
the calculation type defined for the pay PR130 PR131
code, the employee's rate of pay, salary PR132 PR134
class, and the number of hours entered. PR136 PR137
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 PR37.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PR89.1 TA147
UK102 UK560
TRD-SHIFT Numeric 1 BN150 ET530
Element: Shift Contains the shift number associated ETI2.1 LP130
with the pay. PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-CHECK-GRP Alpha 1 BN150 ET530
Element: Check Grp Contains a value that identifies a ETI2.1 LP130
check group. All time records with a PR128 PR130
common entry in this field are grouped PR131 PR132
on one payment record for the employee. PR134 PR136
A number in this field indicates the PR189 PR29.1
deduction cycle the system uses for PR32.2 PR33.2
calculating deductions on the payment. PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-PROCESS-GRP Alpha 1 BN150 ET530
Element: Process Grp Identifies a process group. All time ETI2.1 LP130
records with a common value in this PR128 PR130
field are grouped for taxing purposes PR131 PR132
within a check group for an employee. A PR134 PR136
number in this field indicates the PR189 PR29.1
deduction cycle the application uses for PR32.2 PR33.2
calculating deductions on the payment. PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-TR-DATE Numeric 8 (yyyymmdd) BN150 ET530
Element: Tr Date Contains the time record date. The ETI2.1 LP130
application uses the time record date to PR128 PR130
determine which time records to process PR131 PR132
in PR38.1 (Time Record Selection) or PR134 PR136
PR137 (Batch Time Record Update). PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-DIST-PROC-LEV Alpha 5 BN150 BN66.1
Element: Process Lev HrContains the process level to which the ET530 ETI2.1
system distributes wage expenses. LP130 PR128
PR130 PR131
PR132 PR134
PR136 PR140
PR189 PR195
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 PR89.1
TA147 UK102
UK560
TRD-DIST-DEPART Alpha 5 BN150 BN66.1
Element: Department Contains the department to which the ET530 ETI2.1
system distributes wage expenses. LP130 PR128
PR130 PR131
PR132 PR134
PR136 PR140
PR189 PR195
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 PR89.1
TA147 UK102
UK560
TRD-DST-ACCT-UNIT Alpha 15 BN150 BN66.1
Element: Acct Unit Contains the general ledger accounting ET530 ETI2.1
unit to which the application posts the LP130 PR128
wage expense amount PR130 PR131
PR132 PR134
PR136 PR140
PR189 PR195
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 PR89.1
TA147 UK102
UK560
TRD-DST-ACCOUNT Numeric 6 BN150 BN66.1
Element: Account Contains the general ledger account to ET530 ETI2.1
which the application posts the wage LP130 PR128
expense amount. PR130 PR131
PR132 PR134
PR136 PR140
PR189 PR195
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 PR89.1
TA147 UK102
UK560
TRD-DST-SUB-ACCT Numeric 4 BN150 BN66.1
Element: Sub Acct Contains the general ledger subaccount ET530 ETI2.1
to which the application posts the wage LP130 PR128
expense amount. PR130 PR131
PR132 PR134
PR136 PR140
PR189 PR195
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 PR89.1
TA147 UK102
UK560
TRD-DIST-COMPANY Numeric 4 BN150 BN66.1
Element: Company Contains the company number to which a ET530 ETI2.1
transaction is posted. A valid LP130 PR128
intercompany relationship must be PR130 PR131
defined in the General Ledger PR132 PR134
application. PR136 PR140
PR189 PR195
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 PR89.1
TA147 UK102
UK560
TRD-PCT-DIST-FLAG Alpha 1 BN150 ET530
Element: Pct Dist Flag Contains the value that indicates if ETI2.1 LP130
employee override distributions exist in PR128 PR130
the Emp Acct Distribution Override file. PR131 PR132
When the value is Y (Yes), PR150 PR134 PR136
(Distribution Edit) and PR199 (Payroll PR189 PR29.1
Close) use the override accounts to PR32.2 PR33.2
create Employee Payment Distribution PR33.3 PR35.1
file and GL Interface File records. PR35.2 PR35.3
Y = Distribution override exists PR35.4 PR35.5
N = No override exists PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-ERROR-FLAG Alpha 1 BN150 ET530
Element: Error Flag A value of Y (Yes) in this field ETI2.1 LP130
indicates an error in processing the PR128 PR130
time record. PR130 (Time Record PR131 PR132
Interface) uses this field to indicate PR134 PR136
if a field from the interface time PR189 PR29.1
record does not pass the edits. If a PR32.2 PR33.2
field from the interface time record PR33.3 PR35.1
does not pass the edits, the system PR35.2 PR35.3
creates the time record with this field PR35.4 PR35.5
set to Y (Yes). Time record entry PR35.6 PR35.8
programs then use this field to PR35.9 PR36.1
determine if editing is still necessary. PR45.1 PR529
Y = Created with errors PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-CHECK-ID Numeric 12 BN150 BN66.1
Element: Check Id Contains the payment identification ET530 ETI2.1
number generated by the time record. LP130 PR128
PR130 PR131
PR132 PR134
PR136 PR140
PR189 PR195
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 PR89.1
TA147 UK102
UK560
TRD-CHECK-TYPE Alpha 1 BN150 ET530
Element: Check Type Contains the payment type. ETI2.1 LP130
S = System PR128 PR130
M = Manual PR131 PR132
J = Adjustment PR134 PR136
G = Gross Up PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-SCHEDULE Alpha 9 BN150 ET530
Element: Schedule Contains the value that identifies a ETI2.1 LP130
step and grade schedule. PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-PAY-STEP Numeric 2 BN150 ET530
Element: Pay Step Contains the step number from the step ETI2.1 LP130
and grade schedule. PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-PAY-GRADE Alpha 3 BN150 ET530
Element: Pay Grade Contains the grade from the step and ETI2.1 LP130
grade schedule. PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-ANNUAL-SALARY Signed 13.4 BN150 ET530
Element: Annual Salary Contains the calculated annual salary ETI2.1 LP130
used for salaried employees when the PR128 PR130
time record contains step and grade PR131 PR132
information or is using an alternate pay PR134 PR136
rate. PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-ATTEND-CODE Alpha 2 BN150 ET530
Element: Attend Code Contains the attendance code used for ETI2.1 LP130
creating Employee Attendance History PR128 PR130
records in PR199 (Payroll Close) The PR131 PR132
Time and Attendance system uses this PR134 PR136
field. PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-OCCURRENCE Alpha 1 BN150 ET530
Element: Occurrence Contains the value that indicates if ETI2.1 LP130
the referenced time is a new occurrence PR128 PR130
or a continuation of an existing PR131 PR132
occurrence. The Time and Attendance PR134 PR136
application uses this field. PR189 PR29.1
Y = Yes PR32.2 PR33.2
N = No PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-PCD-SEQ-NBR Numeric 4 BN150 ET530
Element: Pcd Seq Nbr Contains the sequence number associated ETI2.1 LP130
with the time record relative to the pay PR128 PR130
code. PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-TAX-STATE Alpha 2 BN150 ET530
Element: Tax State Contains the 2-digit state code that ETI2.1 LP130
represents the employee's resident PR128 PR130
state. PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-WORK-STATE Alpha 2 BN150 ET530
Element: Work State Identifies the state in which the ETI2.1 LP130
workers' compensation plan is effective. PR128 PR130
This field stores the work state for PR131 PR132
withholding purposes. PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-UNION-CODE Alpha 10 BN150 ET530
Element: Union Code Contains the union code associated with ETI2.1 LP130
the time record. PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-PER-END-DATE Numeric 8 (yyyymmdd) BN150 ET530
Element: Per End Date Contains the pay period end date which ETI2.1 LP130
is determined by the employee's pay plan PR128 PR130
and the time record date. PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 TA170
UK102 UK560
TRD-OT-PREM-AMT Signed 13.2 BN150 ET530
Element: Ot Prem Amt Contains the overtime amount associated ETI2.1 LP130
with the time record. PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PR85.1 TA147
UK102 UK560
TRD-SHIFT-DIFF Signed 13.2 BN150 ET530
Element: Shift Diff Contains the differential from the pay ETI2.1 LP130
code for the shift entered on the time PR128 PR130
record. PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PR85.1 TA147
UK102 UK560
TRD-WC-CLASS Alpha 4 BN150 ET530
Element: Wc Class Contains the workers' compensation ETI2.1 LP130
classification associated with the job PR128 PR130
code entered on the time record. PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-OT-RECORD Alpha 1 BN150 ET530
Element: Ot Record Contains the value that indicates if ETI2.1 LP130
the time record was created for PR128 PR130
retroactive, overtime, flex time, or PR131 PR132
tips pay. PR134 PR136
Y = Yes PR189 PR29.1
R = Retro PR32.2 PR33.2
F = Flex PR33.3 PR35.1
T = Tips PR35.2 PR35.3
U = Updated PR35.4 PR35.5
X = Exception Processed PR35.6 PR35.8
O = Offset Time Record PR35.9 PR36.1
P = Payout PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-WRK-END-DATE Numeric 8 (yyyymmdd) BN150 ET530
Element: Wrk End Date Contains the work period end date which ETI2.1 LP130
is determined by the employee's pay plan PR128 PR130
and the time record date. PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-SUPP-TAX-CODE Alpha 2 BN150 ET530
Element: Supp Tax Code Contains the supplementary tax code ETI2.1 LP130
associated with the time record. PR115 PR128
PR130 PR131
PR132 PR134
PR136 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
TRD-LOCAT-CODE Alpha 10 BN150 ET530
Element: Locat Code ETI2.1 LP130
PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-WC-STATE Alpha 2 BN150 ET530
Element: Wc State Contains the workers' compensation ETI2.1 LP130
state associated with the time record. PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-PAY-PERIODS Numeric 2 BN150 ET530
Element: Pay Periods Contains the number of times a bonus is ETI2.1 LP130
paid during the year. The system uses PR128 PR130
this value to annualize the payment. PR131 PR132
This is used with bonus type pay codes PR134 PR136
and is referred to as the Aggregation PR189 PR29.1
with Pay Periods method. PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-POSITION Alpha 12 BN150 ET530
Element: Position Contains the user-defined code that ETI2.1 LP130
represents a position in the company. PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-ACTIVITY Alpha 15 BN150 ET530
Element: Activity Activities are the processes or ETI2.1 LP130
procedures that produce work. Cost PR128 PR130
objects (products, services, customers, PR131 PR132
and so on) are the reasons for PR134 PR136
performing the activity. PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-ACCT-CATEGORY Alpha 5 BN150 ET530
Element: Acct Category Account categories are groupings of ETI2.1 LP130
costs, revenues, or a combination of PR128 PR130
both used for reporting and inquiries PR131 PR132
for activities in the Activity PR134 PR136
Management system. All transactions are PR189 PR29.1
posted to an account category within an PR32.2 PR33.2
activity. You can assign a specific PR33.3 PR35.1
General Ledger account or range of PR35.2 PR35.3
accounts (company, accounting unit, PR35.4 PR35.5
account, and subaccount) that make up PR35.6 PR35.8
the transactions posted to an account PR35.9 PR36.1
category using AC07.1 (Account PR45.1 PR529
Assignment). PR530 PR560
PR80.1 PR82.1
Period-to-date, year-to-date, and TA147 UK102
life-to-date balances are maintained by UK560
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
TRD-ATN-OBJ-ID Numeric 12 BN150 ET530
Element: Obj Id This is the object identifier. It is ETI2.1 LP130
used to relate commitments or posted PR128 PR130
transactions back to the originating PR131 PR132
subsystems. Each subsystem record that PR134 PR136
is updated as a commitment or posted PR137 PR189
transaction is assigned an object PR29.1 PR32.1
identifier. The object identifier is PR32.2 PR33.1
maintained in the subsystem files and in PR33.2 PR33.3
the Activity Commitments Detail and PR35.1 PR35.2
Activity Transaction files. The object PR35.3 PR35.4
identifier is a unique key used to drill PR35.5 PR35.6
back from Activity Management to the PR35.8 PR35.9
subsystems. PR36.1 PR37.1
PR38.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
TRD-GLT-OBJ-ID Numeric 12 BN150 ET530
Element: Obj Id This is the object identifier. It is ETI2.1 LP130
used to relate commitments or posted PR128 PR130
transactions back to the originating PR131 PR132
subsystems. Each subsystem record that PR134 PR136
is updated as a commitment or posted PR137 PR189
transaction is assigned an object PR29.1 PR32.1
identifier. The object identifier is PR32.2 PR33.1
maintained in the subsystem files and in PR33.2 PR33.3
the Activity Commitments Detail and PR35.1 PR35.2
Activity Transaction files. The object PR35.3 PR35.4
identifier is a unique key used to drill PR35.5 PR35.6
back from Activity Management to the PR35.8 PR35.9
subsystems. PR36.1 PR37.1
PR38.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
TRD-TIME-ACC-FLAG Alpha 1 BN150 BN66.1
Element: Time Acc Flag Contains an L (Last) if an employee is ET530 ETI2.1
terminating employment with the company LP130 PR128
and you are issuing the final payment PR130 PR131
through PR80.1 (Manual Payment). PR132 PR134
A = Created by LP Neg Bal Options PR136 PR140
PR189 PR195
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 PR89.1
TA147 UK102
UK560
TRD-SHFT-DIFF-RATE Signed 13.4 BN150 ET530
Element: Shft Diff RateThe rate used to calculate the shift ETI2.1 LP130
differential. PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-SH-OBJ-ID Numeric 12 BN150 ET530
Element: Sh Obj Id The object id of the shift table used ETI2.1 LP130
in calculating the SHIFT-DIFF and PR128 PR130
SHIFT-DIFF-RATE. PR131 PR132
PR134 PR136
PR189 PR195
PR197 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PR85.1 TA147
UK102 UK560
TRD-OT-RATE Signed 13.4 BN150 ET530
Element: Ot Rate Contains the overtime rate. ETI2.1 LP130
PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-AC-UPDATED Alpha 1 BN150 ET530
Element: Ac191 Updated Y = Yes ETI2.1 LP130
" " = No PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-TAX-COUNTY Alpha 10 BN150 ET530
Element: Tax County Contains the county taxing authority ETI2.1 LP130
code. PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-TAX-CITY Alpha 10 BN150 ET530
Element: Tax City Contains the city taxing authority code. ETI2.1 LP130
PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-TAX-SCHOOL Alpha 10 BN150 ET530
Element: Tax School Contains the tax school. ETI2.1 LP130
PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-TAX-TRANSPORT Alpha 10
Element: Tax Transport Contains the transport tax code.
TRD-SEGMENT-FLAG Alpha 1 BN150 ET530
Element: Segment Flag Defines if segment block data exists ETI2.1 LP130
for the time record. PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR195
PR197 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PR85.1 TA147
UK102 UK560
TRD-CURRENCY-CODE Alpha 5 BN150 ET530
Element: Currency Code This field contains the company base ETI2.1 LP130
currency code established in Company PR128 PR130
(GL10.1 ). PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-CURR-ND Numeric 1 BN150 ET530
Element: Acct Nd The number of decimals assigned to a ETI2.1 LP130
particular account as determined by the PR128 PR130
account currency. PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-TAX-FREQ-OVER Numeric 1 BN150 ET530
Element: Tax Freq Over 1 = Weekly ETI2.1 LP130
2 = Biweekly PR128 PR130
3 = Semi-monthly PR131 PR132
4 = Monthly PR134 PR136
5 = Daily PR189 PR29.1
6 = Quarterly PR32.2 PR33.2
7 = Semi-annually PR33.3 PR35.1
8 = Annually PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-COUNTRY-CODE Alpha 2 BN150 ET530
Element: Country Code The country code. Required for VAT and ETI2.1 LP130
intrastat reporting. Must be defined in PR128 PR130
IN01.1 (Country Maintenance). PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-PAYMENT-TYPE Alpha 2 BN150 ET530
Element: Payment Type Contains the payment type. ETI2.1 LP130
PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-REMUN-CODE Alpha 4 BN150 ET530
Element: Remun Code Contains the remuneration code. Valid ETI2.1 LP130
value is C001 = Bonus. PR115 PR128
E002 = US Pay Advances PR130 PR131
E003 = US Athletic Facilities PR132 PR134
E004 = US Non-Qual Plan Awrds and Prz PR136 PR189
E005 = US Back Pay PR29.1 PR32.2
E006 = US Bonuses PR33.2 PR33.3
E007 = US Business Expense PR35.1 PR35.2
E009 = US Gifts PR35.3 PR35.4
E010 = US Commissions PR35.5 PR35.6
E013 = US Discounts PR35.8 PR35.9
E014 = US Dismissal/Severance PR36.1 PR45.1
E015 = US Educational Assistance PR529 PR530
E016 = US Employment Agency PR560 PR80.1
E017 = US Qual Equip/Tool/Uniform PR82.1 TA147
E018 = US Business Use of Company Car UK102 UK560
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
TRD-REPORT-ENTITY Alpha 5 BN150 ET530
Element: Report Entity Contains the report entity. ETI2.1 LP130
PR128 PR130
Report Entity is the Process Level or PR131 PR132
Company that this Process Level reports PR134 PR136
to for tax reporting. If the Process PR189 PR29.1
Level itself is independent then the PR32.2 PR33.2
independent Process Level is the Report PR33.3 PR35.1
Entity. If the Process Level is non PR35.2 PR35.3
independent and is associated to a PR35.4 PR35.5
independent head Process Level then the PR35.6 PR35.8
independent head Process Level is the PR35.9 PR36.1
Report Entity. If the Process Level is PR45.1 PR529
non independent and is not associated to PR530 PR560
a independent head Process Level then PR80.1 PR82.1
the Company is the Report Entity. TA147 UK102
UK560
TRD-BUS-NBR-GRP Alpha 4 BN150 ET530
Element: Bus Nbr Grp Contains the business number group. ETI2.1 LP130
PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-QC-ENT-NBR-GRP Alpha 4 BN150 ET530
Element: Qc Ent Nbr GrpContains the Quebec enterprise number ETI2.1 LP130
group. PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-CA-WC-CLASS Alpha 10 BN150 ET530
Element: Ca Wc Class Contains the Canadian WC Class from ETI2.1 LP130
employees job. Use to identify the PR128 PR130
PRTIME wages by WC Class. PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-PENS-SEQ-NBR Numeric 4 BN150 ET530
Element: Pens Seq Nbr ETI2.1 LP130
PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-PAY-UNITS Signed 7.2 BN150 ET530
Element: Pay Units ETI2.1 LP130
PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-UNIT-MEASURE Alpha 12 BN150 ET530
Element: Unit Measure ETI2.1 LP130
PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-USER-ID Alpha 10 (Lower Case) BN150 BN305
Element: User BN66.1 ET530
ETI2.1 HR11.1
HR11.2 HR511
LP130 LP54.1
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR115 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 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
PR37.1 PR38.1
PR39.1 PR45.1
...
TRD-DATE-STAMP Numeric 8 (yyyymmdd) BN150 BN305
Element: Date Stamp This field contains the server date BN66.1 ET530
(month, date, and year) of the last ETI2.1 HR11.1
change to this record. HR11.2 HR511
LP130 LP54.1
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR115 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 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
PR37.1 PR38.1
PR39.1 PR45.1
...
TRD-NON-EARNINGS Numeric 1 BN150 ET530
Element: Non Earnings 0 = No - wages ETI2.1 LP130
1 = Yes - other remuneration PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-ORIG-OBJ-ID Numeric 12 BN150 ET530
Element: Orig Obj Id ETI2.1 LP130
PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-RECORD-TYPE Alpha 1 BN150 ET530
Element: Record Type Identifies adjustment status for ETI2.1 LP130
Databasics and Grants. PR128 PR130
PR131 PR132
Blank = Normal (not adjusted) PR134 PR136
1 = Adjustment Offset PR189 PR29.1
2 = Adjustment Entry PR32.2 PR33.2
3 = Adjustment on Adjustment PR33.3 PR35.1
PR35.2 PR35.3
Additional values identify time records PR35.4 PR35.5
created from GM170: PR35.6 PR35.8
PR35.9 PR36.1
4 = Cost Transfer Reversing Entry PR45.1 PR529
5 = Cost Transfer Adjusting Entry PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-LEAVE-STATUS Numeric 1 BN150 ET530
Element: Leave Status ETI2.1 LP130
PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-REASON-CODE Alpha 4 BN150 ET530
Element: Ta Reason Cd ETI2.1 LP130
LP54.1 PR128
PR130 PR131
PR132 PR134
PR136 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
TRD-TES-OBJ-ID Numeric 12 BN150 ET530
Element: Tes Obj Id ETI2.1 LP130
PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-RETRO-PENSION Alpha 1 BN150 ET530
Element: Retro Pension " " = No ETI2.1 LP130
N = No PR128 PR130
Y = Yes; open payment PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-SERVICE-CODE Alpha 4 BN150 ET530
Element: Ta Service Cd ETI2.1 LP130
PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-TIME-STAMP Numeric 6 (hhmmss) BN150 BN305
Element: Time Stamp Contains the server time (hour, minute, BN66.1 ET530
and second) when the record was last ETI2.1 HR11.1
changed. HR11.2 HR511
LP130 LP54.1
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR115 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 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
PR37.1 PR38.1
PR39.1 PR45.1
...
TRD-CREATE-DATE Numeric 8 (yyyymmdd) BN150 ET530
Element: Date Stamp This field contains the server date ETI2.1 LP130
(month, date, and year) of the last PR128 PR130
change to this record. PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-CREATE-TIME Numeric 6 (hhmmss) BN150 ET530
Element: Time Stamp Contains the server time (hour, minute, ETI2.1 LP130
and second) when the record was last PR128 PR130
changed. PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TRD-CREATE-USER-ID Alpha 10 (Lower Case) BN150 ET530
Element: User Id Contains the user ID of the person who ETI2.1 LP130
last changed this record. PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TIMERECORD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TRDSET1 COMPANY BN134 BN150
EMPLOYEE BN305 BN66.1
TIME-SEQ ET530 ETI2.1
HR00.1 HR01.1
HR02.1 HR04.9
HR06.1 HR11.1
HR11.2 HR506
HR511 LP130
LP54.1 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR05.1
...
TRDSET10 COMPANY KeyChange, Subset PR135
PROCESS-LEVEL Where STATUS = Zeroes
EMPLOYEE
WRK-END-DATE
PAY-CODE
JOB-CODE
TR-DATE
TIME-SEQ
TRDSET11 COMPANY KeyChange, Subset PR135 PR137
PROCESS-LEVEL Where STATUS = 1
EMPLOYEE
TR-DATE
TIME-SEQ
TRDSET12 COMPANY KeyChange BN150 BN66.1
PROCESS-LEVEL ET530 ETI2.1
EMPLOYEE LP130 PR128
TIME-SEQ PR130 PR131
PR132 PR134
PR135 PR136
PR137 PR139
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
...
TRDSET13 COMPANY KeyChange, Subset BN150 ET530
EMPLOYEE Where PENS-SEQ-NBR != Zeroes ETI2.1 LP130
PENS-SEQ-NBR PR128 PR130
TIME-SEQ PR131 PR132
PR134 PR136
PR160 PR180
PR189 PR195
PR197 PR229
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
...
TRDSET14 COMPANY Subset
GLT-OBJ-ID Where GLT-OBJ-ID != Zeroes
TIME-SEQ
TRDSET15 COMPANY KeyChange, Subset
EMPLOYEE Where (LEAVE-STATUS = 2 )
ATTEND-CODE Or (LEAVE-STATUS = 3 )
TR-DATE Or (LEAVE-STATUS = 4 )
TIME-SEQ
TRDSET2 COMPANY Subset ET530 PR134
BATCH-NBR Where ERROR-FLAG != Spaces PR136 PR137
TIME-SEQ 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 PR37.1
PR530
TRDSET3 COMPANY KeyChange, Subset PR135 PR38.1
EMPLOYEE Where STATUS = 1
TR-DATE
TIME-SEQ
TRDSET4 COMPANY KeyChange, Subset BN134 BN66.1
PROCESS-LEVEL Where STATUS = 2 LP130 PR128
EMPLOYEE Or STATUS = 3 PR130 PR131
CHECK-GRP Or STATUS = 4 PR132 PR135
REPORT-ENTITY Or STATUS = 5 PR140 PR189
BUS-NBR-GRP PR195 PR36.1
SUPP-TAX-CODE PR45.1 PR80.1
PROCESS-GRP PR89.1 UK102
TIME-SEQ UK330 TA146
TRDSET5 COMPANY KeyChange, Subset ET530 PR134
BATCH-NBR Where STATUS = Zeroes PR135 PR136
EMPLOYEE PR137 PR32.1
WRK-END-DATE PR32.2 PR33.1
PAY-CODE PR33.2 PR33.3
JOB-CODE PR35.1 PR35.2
TR-DATE PR35.3 PR35.4
TIME-SEQ PR35.5 PR35.6
PR35.7 PR35.8
PR35.9 PR37.1
PR530
TRDSET6 COMPANY KeyChange, Subset BN66.1 PR132
PROCESS-LEVEL Where STATUS = 3 PR140 PR189
EMPLOYEE PR195 PR36.1
CHECK-GRP PR80.1 PR89.1
REPORT-ENTITY
BUS-NBR-GRP
SUPP-TAX-CODE
PROCESS-GRP
TIME-SEQ
TRDSET7 COMPANY KeyChange PR115 PR20.4
PCD-SEQ-NBR UK102
EMPLOYEE
TIME-SEQ
TRDSET8 COMPANY KeyChange, Subset BN150 BN66.1
EMPLOYEE Where CHECK-ID != Zeroes ET530 ETI2.1
CHECK-ID HR170 HR70.1
PAY-SUM-GRP LP130 PR128
TIME-SEQ PR130 PR131
PR132 PR134
PR136 PR137
PR139 PR140
PR141 PR142
PR160 PR180
PR189 PR195
PR197 PR274
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
...
TRDSET9 COMPANY KeyChange, Subset
ATN-OBJ-ID Where ATN-OBJ-ID != Zeroes
TIME-SEQ
TIMERECORD FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
Tmtime TMTIME Not Required
TRD-COMPANY -> TMT-COMPANY
TRD-EMPLOYEE -> TMT-EMPLOYEE
TRD-TIME-SEQ -> TMT-TIME-SEQ
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 RELATED
NAME 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
|