 |
Lawson Insight Technical Documentation |
|
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 PA115 PBIP.1 PR05.1 PR09.1
PR135 PR24.1 TA170 UK60.1 PR160 PR180
PR229 TA146 PR20.4 HR170 HR70.1 PR141
PR142
UPDATED BY
AC530 AC541 AC542 BN134 BN150 BN66.1
HR11.1 HR11.2 HR511 HR650 PA02.1 PA100
PA102 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
PR36.1 PR37.1 PR38.1 PR39.1 PR45.1 PR529
PR530 PR560 PR80.1 PR82.1 PR85.1 PR89.1
PRSA.1 UK102 UK330 TA147 UK120
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TRD-COMPANY Numeric 4 AC541 AC542
Company The company number represents an BN150 PR128
established company and is entered on PR130 PR131
all function codes. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-EMPLOYEE Numeric 9 AC541 AC542
Employee Contains the employee number. Each BN150 PR128
person employed by the company is PR130 PR131
assigned a unique number. The system PR132 PR134
uses the employee number to correlate PR136 PR189
all of the information related to that PR29.1 PR32.2
person. PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-TIME-SEQ Numeric 12 AC541 AC542
Sequence Number Contains the sequence number of the BN150 PR128
time record. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-STATUS Numeric 1 AC541 AC542
Status Contains the status of the time record. BN150 BN66.1
PR128 PR130
0 = Unreleased (Batch) PR131 PR132
1 = Future PR134 PR136
2 = Current PR137 PR139
3 = Error PR140 PR189
4 = Processed PR195 PR29.1
5 = Manual PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR37.1
PR38.1 PR39.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PR89.1 TA147
UK102 UK120
TRD-BATCH-NBR Numeric 6 AC541 AC542
Batch Number Contains the batch number to which the BN150 PR128
entered time records belong. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-PROCESS-LEVEL Alpha 5 AC541 AC542
Process Level Contains the employee's home process BN150 HR11.1
level. HR11.2 HR511
HR650 PA02.1
PA100 PA102
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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-DEPARTMENT Alpha 5 AC541 AC542
Department Contains the employee's home BN150 HR11.1
department. HR11.2 HR511
HR650 PA02.1
PA100 PA102
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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-PAY-SUM-GRP Alpha 3 AC541 AC542
Payment Summary Contains the pay summary group BN150 PR128
Group associated with the pay code. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-JOB-CODE Alpha 9 AC541 AC542
Job Code Contains a user-defined code that BN150 PR128
identifies a type of job. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-PAY-CODE Alpha 4 AC541 AC542
Payment Code Contains the pay code. A pay code is a BN150 PR128
user-defined code that identifies a kind PR130 PR131
of pay. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-HOURS Signed 7.2 AC541 AC542
Hours Contains the hours associated with the BN150 PR128
time record. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PR85.1 TA147
UK102 UK120
TRD-RATE Signed 13.4 AC541 AC542
Rate Contains the rate of pay associated BN150 BN66.1
with the time record. 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
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 PR85.1
PR89.1 TA147
UK102 UK120
TRD-WAGE-AMOUNT Signed 13.2 AC541 AC542
Wage Amount Contains the total wage amount for the BN150 BN66.1
time record as calculated according to PR128 PR130
the calculation type defined for the pay PR131 PR132
code, the employee's rate of pay, salary PR134 PR136
class, and the number of hours entered. PR140 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PR89.1 PRSA.1
TA147 UK102
UK120
TRD-SHIFT Numeric 1 AC541 AC542
Shift Contains the shift number associated BN150 PR128
with the pay. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-CHECK-GRP Alpha 1 AC541 AC542
Payment Group Contains a value that identifies a BN150 PR128
check group. All time records with a PR130 PR131
common entry in this field are grouped PR132 PR134
on one payment record for the employee. PR136 PR189
A number in this field indicates the PR29.1 PR32.2
deduction cycle the system uses for PR33.2 PR33.3
calculating deductions on the payment. PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-PROCESS-GRP Alpha 1 AC541 AC542
Process Group Identifies a process group. All time BN150 PR128
records with a common value in this PR130 PR131
field are grouped for taxing purposes PR132 PR134
within a check group for an employee. A PR136 PR189
number in this field indicates the PR29.1 PR32.2
deduction cycle the system uses for PR33.2 PR33.3
calculating deductions on the payment. PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-TR-DATE Numeric 8 (yyyymmdd) AC541 AC542
Time Record Date Contains the time record date. The BN150 PR128
system uses the time record date to PR130 PR131
determine which time records to process PR132 PR134
in PR38.1 (Time Record Selection) or PR136 PR189
PR137 (Batch Time Record Update). PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-DIST-PROC-LEV Alpha 5 AC541 AC542
Distribution Contains the process level to which the BN150 BN66.1
Process Level system distributes wage expenses. 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
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 PR89.1
TA147 UK102
UK120
TRD-DIST-DEPART Alpha 5 AC541 AC542
Distribution Contains the department to which the BN150 BN66.1
Department system distributes wage expenses. 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
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 PR89.1
TA147 UK102
UK120
TRD-DST-ACCT-UNIT Alpha 15 AC541 AC542
Distribution Contains the general ledger accounting BN150 BN66.1
Accounting Unit unit to which the system posts the wage PR128 PR130
expense amount 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
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 PR89.1
TA147 UK102
UK120
TRD-DST-ACCOUNT Numeric 6 AC541 AC542
Distribution Contains the general ledger account to BN150 BN66.1
Account Number which the system posts the wage expense PR128 PR130
amount. 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
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 PR89.1
TA147 UK102
UK120
TRD-DST-SUB-ACCT Numeric 4 AC541 AC542
Distribution Contains the general ledger subaccount BN150 BN66.1
Subaccount Number to which the system posts the wage PR128 PR130
expense amount. 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
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 PR89.1
TA147 UK102
UK120
TRD-DIST-COMPANY Numeric 4 AC541 AC542
Distribution Company Contains the company number to which a BN150 BN66.1
transaction is posted. A valid PR128 PR130
intercompany relationship must be PR131 PR132
defined in the General Ledger system. 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
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 PR89.1
TA147 UK102
UK120
TRD-PCT-DIST-FLAG Alpha 1 AC541 AC542
Percent Contains the value that indicates if BN150 PR128
Distribution Flag employee override distributions exist in PR130 PR131
the Emp Acct Distribution Override file. PR132 PR134
When the value is Y (Yes), PR150 PR136 PR189
(Distribution Edit) and PR199 (Payroll PR29.1 PR32.2
Close) use the override accounts to PR33.2 PR33.3
create Employee Payment Distribution PR35.1 PR35.2
file and GL Interface File records. PR35.3 PR35.4
Y = Distribution override exists PR35.5 PR35.6
N = No override exists PR35.8 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-ERROR-FLAG Alpha 1 AC541 AC542
Error Flag A value of Y (Yes) in this field BN150 PR128
indicates an error in processing the PR130 PR131
time record. PR130 (Time Record PR132 PR134
Interface) uses this field to indicate PR136 PR189
if a field from the interface time PR29.1 PR32.2
record does not pass the edits. If a PR33.2 PR33.3
field from the interface time record PR35.1 PR35.2
does not pass the edits, the system PR35.3 PR35.4
creates the time record with this field PR35.5 PR35.6
set to Y (Yes). Time record entry PR35.8 PR36.1
programs then use this field to PR45.1 PR529
determine if editing is still necessary. PR530 PR560
Y = Created with errors PR80.1 PR82.1
TA147 UK102
UK120
TRD-CHECK-ID Numeric 12 AC541 AC542
Internal Check ID Contains the payment identification BN150 BN66.1
Number number generated by the time record. 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
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 PR89.1
TA147 UK102
UK120
TRD-CHECK-TYPE Alpha 1 AC541 AC542
Payment Type Contains the payment type. BN150 PR128
S = System PR130 PR131
M = Manual PR132 PR134
J = Adjustment PR136 PR189
G = Gross Up PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-SCHEDULE Alpha 9 AC541 AC542
Schedule Contains the value that identifies a BN150 PR128
step and grade schedule. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-PAY-STEP Numeric 2 AC541 AC542
Step Contains the step number from the step BN150 PR128
and grade schedule. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-PAY-GRADE Alpha 3 AC541 AC542
Grade Contains the grade from the step and BN150 PR128
grade schedule. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-ANNUAL-SALARY Signed 13.4 AC541 AC542
Annual Salary Contains the calculated annual salary BN150 PR128
used for salaried employees when the PR130 PR131
time record contains step and grade PR132 PR134
information or is using an alternate pay PR136 PR189
rate. PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-ATTEND-CODE Alpha 2 AC541 AC542
Attendance Code Contains the attendance code used for BN150 PR128
creating Employee Attendance History PR130 PR131
records in PR199 (Payroll Close) The PR132 PR134
Time and Attendance system uses this PR136 PR189
field. PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-OCCURRENCE Alpha 1 AC541 AC542
Occurrence Contains the value that indicates if BN150 PR128
the referenced time is a new occurrence PR130 PR131
or a continuation of an existing PR132 PR134
occurrence. The Time and Attendance PR136 PR189
system uses this field. PR29.1 PR32.2
PR33.2 PR33.3
Y = Yes PR35.1 PR35.2
N = No PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-PCD-SEQ-NBR Numeric 4 AC541 AC542
Pcd Seq Nbr Contains the sequence number associated BN150 PR128
with the time record relative to the pay PR130 PR131
code. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-TAX-STATE Alpha 2 AC541 AC542
State Taxing Contains the 2-digit state code that BN150 PR128
Authority Code represents the employee's resident PR130 PR131
state. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-WORK-STATE Alpha 2 AC541 AC542
Work State Identifies the state in which the BN150 PR128
workers' compensation plan is effective. PR130 PR131
This field stores the work state for PR132 PR134
withholding purposes. PR136 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-UNION-CODE Alpha 10 AC541 AC542
Union Code Contains the union code associated with BN150 PR128
the time record. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-PER-END-DATE Numeric 8 (yyyymmdd) AC541 AC542
Period End Date Contains the pay period end date which BN150 PR128
is determined by the employee's pay plan PR130 PR131
and the time record date. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-OT-PREM-AMT Signed 13.2 AC541 AC542
Ot Prem Amt Contains the overtime amount associated BN150 PR128
with the time record. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PR85.1 TA147
UK102 UK120
TRD-SHIFT-DIFF Signed 13.2 AC541 AC542
Shift Differential Contains the differential from the pay BN150 PR128
code for the shift entered on the time PR130 PR131
record. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PR85.1 TA147
UK102 UK120
TRD-WC-CLASS Alpha 4 AC541 AC542
Workers Comp Contains the workers' compensation BN150 PR128
Classification classification associated with the job PR130 PR131
code entered on the time record. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-OT-RECORD Alpha 1 AC541 AC542
Ot Record Contains the value that indicates if BN150 PR128
the time record was created for PR130 PR131
retroactive, overtime, flex time, or PR132 PR134
tips pay. PR136 PR189
Y = Yes PR29.1 PR32.2
R = Retro PR33.2 PR33.3
F = Flex PR35.1 PR35.2
T = Tips PR35.3 PR35.4
U = Updated PR35.5 PR35.6
X = Exception Processed PR35.8 PR36.1
O = Offset Time Record PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-WRK-END-DATE Numeric 8 (yyyymmdd) AC541 AC542
Wrk End Date Contains the work period end date which BN150 PR128
is determined by the employee's pay plan PR130 PR131
and the time record date. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-SUPP-TAX-CODE Alpha 2 AC541 AC542
Supp Tax Code Contains the supplementary tax code BN150 PR115
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
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK120
TRD-LOCAT-CODE Alpha 10 AC541 AC542
Location BN150 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-WC-STATE Alpha 2 AC541 AC542
Wc State Contains the workers' compensation BN150 PR128
state associated with the time record. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-PAY-PERIODS Numeric 2 AC541 AC542
Pay Periods Contains the number of times a bonus is BN150 PR128
paid during the year. The system uses PR130 PR131
this value to annualize the payment. PR132 PR134
This is used with bonus type pay codes PR136 PR189
and is referred to as the Aggregation PR29.1 PR32.2
with Pay Periods method. PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-POSITION Alpha 12 AC541 AC542
Position Contains the user-defined code that BN150 PR128
represents a position in the company. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-ACTIVITY Alpha 15 AC541 AC542
Activity Activities are the processes or BN150 PR128
procedures that produce work. Cost PR130 PR131
objects (products, services, customers, PR132 PR134
and so on) are the reasons for PR136 PR189
performing the activity. PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-ACCT-CATEGORY Alpha 5 AC541 AC542
Account Category Account categories are groupings of BN150 PR128
costs, revenues, or a combination of PR130 PR131
both used for reporting and inquiries PR132 PR134
for activities in the Activity PR136 PR189
Management system. All transactions are PR29.1 PR32.2
posted to an account category within an PR33.2 PR33.3
activity. You can assign a specific PR35.1 PR35.2
General Ledger account or range of PR35.3 PR35.4
accounts (company, accounting unit, PR35.5 PR35.6
account, and subaccount) that make up PR35.8 PR36.1
the transactions posted to an account PR45.1 PR529
category using AC07.1 (Account PR530 PR560
Assignment). PR80.1 PR82.1
TA147 UK102
Period-to-date, year-to-date, and UK120
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.
TRD-ATN-OBJ-ID Numeric 12 AC530 AC541
Atn Object ID The system-defined object id AC542 BN150
representing the Activity Management PR128 PR130
commitment. PR131 PR132
PR134 PR136
PR137 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR38.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 PRSA.1
TA147 UK102
UK120
TRD-GLT-OBJ-ID Numeric 12 AC541 AC542
Subsystem GL This is a subsystem GL interface BN150 PR128
Interface ID identification number. It is used for PR130 PR131
Drill Around purposes. PR132 PR134
PR136 PR137
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR38.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PRSA.1 TA147
UK102 UK120
TRD-TIME-ACC-FLAG Alpha 1 AC541 AC542
Time Acc Flag Contains an L (Last) if an employee is BN150 PR128
terminating employment with the company PR130 PR131
and you are issuing the final payment PR132 PR134
through PR80.1 (Manual Payment). PR136 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-SHFT-DIFF-RATE Signed 13.4 AC541 AC542
Shft Diff Rate The rate used to calculate the shift BN150 PR128
differential. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-SH-OBJ-ID Numeric 12 AC541 AC542
Sh Obj Id The object id of the shift table used BN150 PR128
in calculating the SHIFT-DIFF and PR130 PR131
SHIFT-DIFF-RATE. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PR85.1 TA147
UK102 UK120
TRD-OT-RATE Signed 13.4 AC541 AC542
Ot Rate Contains the overtime rate. BN150 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-AC-UPDATED Alpha 1 AC530 AC541
Ac Updated Indicates the completion of AC530 for AC542 BN150
Activity Management commitments. PR128 PR130
Y = Yes PR131 PR132
" " = No 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
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK120
TRD-TAX-COUNTY Alpha 10 AC541 AC542
County Taxing Contains the county taxing authority BN150 PR128
Authority Code code. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-TAX-CITY Alpha 10 AC541 AC542
City Taxing Contains the city taxing authority code. BN150 PR128
Authority Code 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-TAX-SCHOOL Alpha 10 AC541 AC542
Tax School Contains the tax school. BN150 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-TAX-TRANSPORT Alpha 10
Tax Transport Contains the transport tax code.
TRD-SEGMENT-FLAG Alpha 1 AC541 AC542
Segment Flag Defines if segment block data exists BN150 PR128
for the time record. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PR85.1 TA147
UK102 UK120
TRD-CURRENCY-CODE Alpha 5 AC541 AC542
Currency Code This field contains the company base BN150 PR128
currency code established in Company PR130 PR131
(GL10.1 ). 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-CURR-ND Numeric 1 AC541 AC542
Currency Number of Represents the number of decimals BN150 PR128
Decimals defined for the currency of the object. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-TAX-FREQ-OVER Numeric 1 AC541 AC542
Tax Freq Over 1 = Weekly BN150 PR128
2 = Biweekly PR130 PR131
3 = Semi-monthly PR132 PR134
4 = Monthly PR136 PR189
5 = Daily PR29.1 PR32.2
6 = Quarterly PR33.2 PR33.3
7 = Semi-annually PR35.1 PR35.2
8 = Annually PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-COUNTRY-CODE Alpha 2 AC541 AC542
Country Code The country code. Required for VAT and BN150 PR128
intrastat reporting. Must be defined in PR130 PR131
IN01.1 (Country Maintenance). 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-PAYMENT-TYPE Alpha 2 AC541 AC542
Payment Type Contains the payment type. BN150 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-REMUN-CODE Alpha 4 AC541 AC542
Remun Code Contains the remuneration code. Valid BN150 PR128
value is C001 = Bonus. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-REPORT-ENTITY Alpha 5 AC541 AC542
Report Entity Contains the report entity. BN150 PR128
PR130 PR131
Report Entity is the Process Level or PR132 PR134
Company that this Process Level reports PR136 PR189
to for tax reporting. If the Process PR29.1 PR32.2
Level itself is independent then the PR33.2 PR33.3
independent Process Level is the Report PR35.1 PR35.2
Entity. If the Process Level is non PR35.3 PR35.4
independent and is associated to a PR35.5 PR35.6
independent head Process Level then the PR35.8 PR36.1
independent head Process Level is the PR45.1 PR529
Report Entity. If the Process Level is PR530 PR560
non independent and is not associated to PR80.1 PR82.1
a independent head Process Level then TA147 UK102
the Company is the Report Entity. UK120
TRD-BUS-NBR-GRP Alpha 4 AC541 AC542
Bus Nbr Grp Contains the business number group. BN150 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-QC-ENT-NBR-GRP Alpha 4 AC541 AC542
Qc Ent Nbr Grp Contains the Quebec enterprise number BN150 PR128
group. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-CA-WC-CLASS Alpha 10 AC541 AC542
Ca Wc Class Contains the Canadian WC Class from BN150 PR128
employees job. Use to identify the PR130 PR131
PRTIME wages by WC Class. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-PENS-SEQ-NBR Numeric 4 AC541 AC542
Pens Seq Nbr BN150 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-ABN-OBJ-ID Numeric 12 AC541 AC542
Abn Obj Id BN150 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-PAY-UNITS Signed 7.2
Pay Units
TRD-UNIT-MEASURE Alpha 12
Unit Measure
TRD-USER-ID Alpha 10 (Lower Case) AC541 AC542
User ID Name Contains the user ID of the person who BN150 PR128
last changed this record. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-DATE-STAMP Numeric 8 (yyyymmdd) AC541 AC542
Date Stamp This field contains the server date BN150 PR128
(month, date, and year) of the last PR130 PR131
change to this record. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-NON-EARNINGS Numeric 1
Non Earnings 0 = No - wages
1 = Yes - other remuneration
TRD-ORIG-OBJ-ID Numeric 12 AC541 AC542
Orig Obj Id BN150 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TRD-RECORD-TYPE Alpha 1 AC541 AC542
Record Type This field identifies the type of BN150 PR128
record defined. PR130 PR131
PR132 PR134
Valid values are: PR136 PR189
S = Summary PR29.1 PR32.2
D = Detail PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
TIMERECORD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TRDSET1 COMPANY AC530 AC541
EMPLOYEE AC542 BN134
TIME-SEQ BN150 BN66.1
HR00.1 HR01.1
HR11.1 HR11.2
HR511 HR650
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PBIP.1 PR05.1
PR09.1 PR110
PR113 PR120
...
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, Subset
DIST-PROC-LEV Where (STATUS = 2 )
EMPLOYEE Or (STATUS = 3 )
CHECK-GRP Or (STATUS = 4 )
REPORT-ENTITY
BUS-NBR-GRP
SUPP-TAX-CODE
PROCESS-GRP
TIME-SEQ
TRDSET13 COMPANY KeyChange, Subset AC541 AC542
EMPLOYEE Where PENS-SEQ-NBR != Zeroes BN150 PR128
PENS-SEQ-NBR PR130 PR131
TIME-SEQ 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
PR36.1 PR45.1
PR529 PR530
...
TRDSET14 COMPANY Subset
GLT-OBJ-ID Where GLT-OBJ-ID != Zeroes
TIME-SEQ
TRDSET2 COMPANY Subset PR134 PR136
BATCH-NBR Where ERROR-FLAG != Spaces PR137 PR32.1
TIME-SEQ PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 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 PR128 PR130
EMPLOYEE Or STATUS = 3 PR131 PR132
CHECK-GRP Or STATUS = 4 PR135 PR140
REPORT-ENTITY Or STATUS = 5 PR189 PR195
BUS-NBR-GRP PR197 PR36.1
SUPP-TAX-CODE PR45.1 PR80.1
PROCESS-GRP PR85.1 PR89.1
TIME-SEQ UK102 UK330
TA146 UK120
TRDSET5 COMPANY KeyChange, Subset PR134 PR135
BATCH-NBR Where STATUS = Zeroes PR136 PR137
EMPLOYEE PR32.1 PR32.2
WRK-END-DATE PR33.1 PR33.2
PAY-CODE PR33.3 PR35.1
JOB-CODE PR35.2 PR35.3
TR-DATE PR35.4 PR35.5
TIME-SEQ PR35.6 PR35.7
PR35.8 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 AC542 BN66.1
EMPLOYEE Where CHECK-ID != Zeroes HR170 HR70.1
CHECK-ID PR139 PR140
PAY-SUM-GRP PR141 PR142
TIME-SEQ PR160 PR180
PR189 PR195
PR197 PR45.1
PR80.1 PR80.2
PR82.1 PR85.1
PR89.1
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
Abtrans ABTRANS Not Required
Valid When TRD-ABN-OBJ-ID != Zeroes
TRD-ABN-OBJ-ID -> ABN-OBJ-ID
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
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
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
Position PAPOSITION
Valid When TRD-POSITION != Spaces
TRD-COMPANY -> POS-COMPANY
TRD-POSITION -> POS-POSITION
POS-EFFECT-DATE
|