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 PA115 PBIP.1 PR05.1 PR09.1
PR135 PR24.1 UK50.4 UK50.3 TA170 UK60.1
PR160 PR180 PR229 TA146 PR20.4 HR170
HR70.1 PR141 PR142 UK13.1 UK141 UK145
UK201 UK202
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 UK560 TA147 UK120
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TRD-COMPANY Numeric 4 AC541 AC542
Element: 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 UK560
TRD-EMPLOYEE Numeric 9 AC541 AC542
Element: 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 UK560
TRD-TIME-SEQ Numeric 12 AC541 AC542
Element: Sequence NumbeContains 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 UK560
TRD-STATUS Numeric 1 AC541 AC542
Element: Status Contains the status of the time record. BN150 BN66.1
0 = Unreleased (Batch) PR128 PR130
1 = Future PR131 PR132
2 = Current PR134 PR136
3 = Error PR137 PR139
4 = Processed PR140 PR189
5 = Manual 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 PR37.1
PR38.1 PR39.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PR89.1 TA147
UK102 UK120
UK560
TRD-BATCH-NBR Numeric 6 AC541 AC542
Element: 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 UK560
TRD-PROCESS-LEVEL Alpha 5 AC541 AC542
Element: 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 UK560
TRD-DEPARTMENT Alpha 5 AC541 AC542
Element: 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 UK560
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 UK560
TRD-JOB-CODE Alpha 9 AC541 AC542
Element: 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 UK560
TRD-PAY-CODE Alpha 4 AC541 AC542
Element: 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 UK560
TRD-HOURS Signed 7.2 AC541 AC542
Element: 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
UK560
TRD-RATE Signed 13.4 AC541 AC542
Element: 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
UK50.3 UK560
TRD-WAGE-AMOUNT Signed 13.2 AC541 AC542
Element: 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 UK560
TRD-SHIFT Numeric 1 AC541 AC542
Element: 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 UK560
TRD-CHECK-GRP Alpha 1 AC541 AC542
Element: 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 UK560
TRD-PROCESS-GRP Alpha 1 AC541 AC542
Element: 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 UK560
TRD-TR-DATE Numeric 8 (yyyymmdd) AC541 AC542
Element: Time Record DaContains 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 UK560
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 UK560
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 UK560
TRD-DST-ACCT-UNIT Alpha 15 AC541 AC542
Element: Accounting UniContains the general ledger accounting BN150 BN66.1
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 UK560
TRD-DST-ACCOUNT Numeric 6 AC541 AC542
Element: Account Contains the general ledger account to BN150 BN66.1
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 UK560
TRD-DST-SUB-ACCT Numeric 4 AC541 AC542
Element: Subaccount Contains the general ledger subaccount BN150 BN66.1
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 UK560
TRD-DIST-COMPANY Numeric 4 AC541 AC542
Element: 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 UK560
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 UK560
TRD-ERROR-FLAG Alpha 1 AC541 AC542
Element: 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 UK560
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 UK560
TRD-CHECK-TYPE Alpha 1 AC541 AC542
Element: 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 UK560
TRD-SCHEDULE Alpha 9 AC541 AC542
Element: 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 UK560
TRD-PAY-STEP Numeric 2 AC541 AC542
Element: 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 UK560
TRD-PAY-GRADE Alpha 3 AC541 AC542
Element: 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 UK560
TRD-ANNUAL-SALARY Signed 13.4 AC541 AC542
Element: 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 UK560
TRD-ATTEND-CODE Alpha 2 AC541 AC542
Element: Attendance CodContains 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 UK560
TRD-OCCURRENCE Alpha 1 AC541 AC542
Element: 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
Y = Yes PR33.2 PR33.3
N = No 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 UK560
TRD-PCD-SEQ-NBR Numeric 4 AC541 AC542
Element: 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 UK560
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 UK560
TRD-WORK-STATE Alpha 2 AC541 AC542
Element: 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 UK560
TRD-UNION-CODE Alpha 10 AC541 AC542
Element: 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 UK560
TRD-PER-END-DATE Numeric 8 (yyyymmdd) AC541 AC542
Element: 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 TA170
UK102 UK120
UK560
TRD-OT-PREM-AMT Signed 13.2 AC541 AC542
Element: 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
UK560
TRD-SHIFT-DIFF Signed 13.2 AC541 AC542
Element: Shift DifferenContains 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
UK560
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 UK560
TRD-OT-RECORD Alpha 1 AC541 AC542
Element: 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 UK560
TRD-WRK-END-DATE Numeric 8 (yyyymmdd) AC541 AC542
Element: 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 UK560
TRD-SUPP-TAX-CODE Alpha 2 AC541 AC542
Element: 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
UK560
TRD-LOCAT-CODE Alpha 10 AC541 AC542
Element: 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 UK560
TRD-WC-STATE Alpha 2 AC541 AC542
Element: 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 UK560
TRD-PAY-PERIODS Numeric 2 AC541 AC542
Element: 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 UK560
TRD-POSITION Alpha 12 AC541 AC542
Element: 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 UK560
TRD-ACTIVITY Alpha 15 AC541 AC542
Element: 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 UK560
TRD-ACCT-CATEGORY Alpha 5 AC541 AC542
Element: Account CategoAccount 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 UK560
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
Object AC542 BN150
Identification PR128 PR130
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 UK560
TRD-GLT-OBJ-ID Numeric 12 AC541 AC542
Object BN150 PR128
Identification PR130 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
UK560
TRD-TIME-ACC-FLAG Alpha 1 AC541 AC542
Element: Time Acc Flag Contains an L (Last) if an employee is BN150 BN66.1
terminating employment with the company PR128 PR130
and you are issuing the final payment PR131 PR132
through PR80.1 (Manual Payment). 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 UK560
TRD-SHFT-DIFF-RATE Signed 13.4 AC541 AC542
Element: Shft Diff RateThe 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 UK560
TRD-SH-OBJ-ID Numeric 12 AC541 AC542
Element: 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
UK560
TRD-OT-RATE Signed 13.4 AC541 AC542
Element: 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 UK560
TRD-AC-UPDATED Alpha 1 AC530 AC541
Element: Ac191 Updated Y = Yes AC542 BN150
" " = 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
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK120
UK560
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 UK560
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 UK560
TRD-TAX-SCHOOL Alpha 10 AC541 AC542
Element: 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 UK560
TRD-TAX-TRANSPORT Alpha 10
Element: Tax Transport Contains the transport tax code.
TRD-SEGMENT-FLAG Alpha 1 AC541 AC542
Element: 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
UK560
TRD-CURRENCY-CODE Alpha 5 AC541 AC542
Element: 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 UK560
TRD-CURR-ND Numeric 1 AC541 AC542
Account Currency BN150 PR128
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 UK560
TRD-TAX-FREQ-OVER Numeric 1 AC541 AC542
Element: 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 UK560
TRD-COUNTRY-CODE Alpha 2 AC541 AC542
Element: 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 UK560
TRD-PAYMENT-TYPE Alpha 2 AC541 AC542
Element: 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 UK560
TRD-REMUN-CODE Alpha 4 AC541 AC542
Element: 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 UK560
TRD-REPORT-ENTITY Alpha 5 AC541 AC542
Element: Process Level 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 UK560
TRD-BUS-NBR-GRP Alpha 4 AC541 AC542
Element: 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 UK560
TRD-QC-ENT-NBR-GRP Alpha 4 AC541 AC542
Element: Qc Ent Nbr GrpContains 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 UK560
TRD-CA-WC-CLASS Alpha 10 AC541 AC542
Element: 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 UK560
TRD-PENS-SEQ-NBR Numeric 4 AC541 AC542
Element: 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 UK560
TRD-ABN-OBJ-ID Numeric 12
Element: Abn Obj Id
TRD-PAY-UNITS Signed 7.2
Element: Pay Units
TRD-UNIT-MEASURE Alpha 12
Element: Unit Measure
TRD-USER-ID Alpha 10 (Lower Case) AC541 AC542
Element: User 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 UK560
TRD-DATE-STAMP Numeric 8 (yyyymmdd) AC541 AC542
Element: 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 UK560
TRD-NON-EARNINGS Numeric 1
Element: Non Earnings 0 = No - wages
1 = Yes - other remuneration
TRD-ORIG-OBJ-ID Numeric 12 AC541 AC542
Element: 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 UK560
TRD-RECORD-TYPE Alpha 1 AC541 AC542
Element: 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 UK560
TRD-LEAVE-STATUS Numeric 1 AC541 AC542
Element: Leave Status 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 UK560
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
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 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 AC541 AC542
EMPLOYEE Where CHECK-ID != Zeroes BN150 BN66.1
CHECK-ID HR170 HR70.1
PAY-SUM-GRP PR128 PR130
TIME-SEQ PR131 PR132
PR134 PR136
PR137 PR139
PR140 PR141
PR142 PR160
PR180 PR189
PR195 PR197
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
...
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
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
|