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 PR135
PR24.1 TA170 UK60.1 PR20.4 BN66.1 HR170
HR70.1 PR141 PR142 PR160 PR180 PR89.1
UPDATED BY
AC530 BN134 BN150 HR11.1 HR511 PA02.1
PA100 PA102 PA13.1 PA13.2 PA502 PA513
PA52.1 PA52.3 PA52.4 PA52.5 PR128 PR13.1
PR131 PR132 PR134 PR136 PR137 PR139
PR140 PR150 PR195 PR199 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 PR530 PR80.1 PR82.1
PR85.1 PRSA.1 UK102 UK330 UK120
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TRD-COMPANY Numeric 4 BN150 PR128
Company The company number represents an PR131 PR132
established company and is entered on PR134 PR136
all function codes. PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-EMPLOYEE Numeric 9 BN150 PR128
Employee Contains the employee number. Each PR131 PR132
person employed by the company is PR134 PR136
assigned a unique number. The system PR137 PR140
uses the employee number to correlate PR150 PR195
all of the information related to that PR199 PR32.1
person. 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-TIME-SEQ Numeric 12 BN150 PR128
Sequence Number Contains the sequence number of the PR131 PR132
time record. PR134 PR136
PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-STATUS Numeric 1 BN150 PR128
Status Contains the status of the time record. PR131 PR132
0 = Unreleased (Batch) PR134 PR136
1 = Future PR137 PR139
2 = Current PR140 PR150
3 = Error PR195 PR199
4 = Processed 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 PR530
PR80.1 PR82.1
PR85.1 UK102
UK120 UK330
TRD-BATCH-NBR Numeric 6 BN150 PR128
Batch Number Contains the batch number to which the PR131 PR132
entered time records belong. PR134 PR136
PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-PROCESS-LEVEL Alpha 5 BN150 HR11.1
Process Level Contains the employee's home process HR511 PA02.1
level. PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR128 PR13.1
PR131 PR132
PR134 PR136
PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-DEPARTMENT Alpha 5 BN150 HR11.1
Department Contains the employee's home HR511 PA02.1
department. PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR128 PR13.1
PR131 PR132
PR134 PR136
PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-PAY-SUM-GRP Alpha 3 BN150 PR128
Payment Summary Contains the pay summary group PR131 PR132
Group associated with the pay code. PR134 PR136
PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-JOB-CODE Alpha 9 BN150 PR128
Job Code Contains a user-defined code that PR131 PR132
identifies a type of job. PR134 PR136
PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-PAY-CODE Alpha 4 BN150 PR128
Payment Code Contains the pay code. A pay code is a PR131 PR132
user-defined code that identifies a kind PR134 PR136
of pay. PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-HOURS Signed 7.2 BN150 PR128
Hours Contains the hours associated with the PR131 PR132
time record. PR134 PR136
PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-RATE Signed 13.4 BN150 PR128
Rate Contains the rate of pay associated PR131 PR132
with the time record. PR134 PR136
PR137 PR140
PR150 PR160
PR180 PR195
PR199 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 PR45.1
PR530 PR80.1
PR80.2 PR82.1
PR85.1 UK102
UK120 UK330
TRD-WAGE-AMOUNT Signed 11.2 BN150 PR128
Wage Amount Contains the total wage amount for the PR131 PR132
time record as calculated according to PR134 PR136
the calculation type defined for the pay PR137 PR140
code, the employee's rate of pay, salary PR150 PR195
class, and the number of hours entered. PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
PRSA.1 UK102
UK120 UK330
TRD-SHIFT Numeric 1 BN150 PR128
Shift Contains the shift number associated PR131 PR132
with the pay. PR134 PR136
PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-CHECK-GRP Alpha 1 BN150 PR128
Payment Group Contains a value that identifies a PR131 PR132
check group. All time records with a PR134 PR136
common entry in this field are grouped PR137 PR140
on one payment record for the employee. PR150 PR195
A number in this field indicates the PR199 PR32.1
deduction cycle the system uses for PR32.2 PR33.1
calculating deductions on the payment. PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-PROCESS-GRP Alpha 1 BN150 PR128
Process Group Identifies a process group. All time PR131 PR132
records with a common value in this PR134 PR136
field are grouped for taxing purposes PR137 PR140
within a check group for an employee. A PR150 PR195
number in this field indicates the PR199 PR32.1
deduction cycle the system uses for PR32.2 PR33.1
calculating deductions on the payment. PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-TR-DATE Numeric 8 (yyyymmdd) BN150 PR128
Time Record Date Contains the time record date. The PR131 PR132
system uses the time record date to PR134 PR136
determine which time records to process PR137 PR140
in PR38.1 (Time Record Selection) or PR150 PR195
PR137 (Batch Time Record Update). PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-DIST-PROC-LEV Alpha 5 BN150 PR128
Distribution Contains the process level to which the PR131 PR132
Process Level system distributes wage expenses. PR134 PR136
PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-DIST-DEPART Alpha 5 BN150 PR128
Distribution Contains the department to which the PR131 PR132
Department system distributes wage expenses. PR134 PR136
PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-DST-ACCT-UNIT Alpha 15 BN150 PR128
Distribution Contains the general ledger accounting PR131 PR132
Accounting Unit unit to which the system posts the wage PR134 PR136
expense amount PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-DST-ACCOUNT Numeric 6 BN150 PR128
Distribution Contains the general ledger account to PR131 PR132
Account Number which the system posts the wage expense PR134 PR136
amount. PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-DST-SUB-ACCT Numeric 4 BN150 PR128
Distribution Contains the general ledger subaccount PR131 PR132
Subaccount Number to which the system posts the wage PR134 PR136
expense amount. PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-DIST-COMPANY Numeric 4 BN150 PR128
Distribution Company Contains the company number to which a PR131 PR132
transaction is posted. A valid PR134 PR136
intercompany relationship must be PR137 PR140
defined in the General Ledger system. PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-PCT-DIST-FLAG Alpha 1 BN150 PR128
Percent Contains the value that indicates if PR131 PR132
Distribution Flag employee override distributions exist in PR134 PR136
the Emp Acct Distribution Override file. PR137 PR140
When the value is Y (Yes), PR150 PR150 PR195
(Distribution Edit) and PR199 (Payroll PR199 PR32.1
Close) use the override accounts to PR32.2 PR33.1
create Employee Payment Distribution PR33.2 PR33.3
file and GL Interface File records. PR35.1 PR35.2
Y = Distribution override exists PR35.3 PR35.4
N = No override exists PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-ERROR-FLAG Alpha 1 BN150 PR128
Error Flag A value of Y (Yes) in this field PR131 PR132
indicates an error in processing the PR134 PR136
time record. PR130 (Time Record PR137 PR140
Interface) uses this field to indicate PR150 PR195
if a field from the interface time PR199 PR32.1
record does not pass the edits. If a PR32.2 PR33.1
field from the interface time record PR33.2 PR33.3
does not pass the edits, the system PR35.1 PR35.2
creates the time record with this field PR35.3 PR35.4
set to Y (Yes). Time record entry PR35.5 PR35.6
programs then use this field to PR35.8 PR36.1
determine if editing is still necessary. PR37.1 PR45.1
Y = Created with errors PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-CHECK-ID Numeric 12 BN150 PR128
Internal Check ID Contains the payment identification PR131 PR132
Number number generated by the time record. PR134 PR136
PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-CHECK-TYPE Alpha 1 BN150 PR128
Payment Type Contains the payment type. PR131 PR132
S = System PR134 PR136
M = Manual PR137 PR140
J = Adjustment PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-SCHEDULE Alpha 9 BN150 PR128
Schedule Contains the value that identifies a PR131 PR132
step and grade schedule. PR134 PR136
PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-PAY-STEP Numeric 2 BN150 PR128
Step Contains the step number from the step PR131 PR132
and grade schedule. PR134 PR136
PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-PAY-GRADE Alpha 3 BN150 PR128
Grade Contains the grade from the step and PR131 PR132
grade schedule. PR134 PR136
PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-ANNUAL-SALARY Signed 13.4 BN150 PR128
Annual Salary Contains the calculated annual salary PR131 PR132
used for salaried employees when the PR134 PR136
time record contains step and grade PR137 PR140
information or is using an alternate pay PR150 PR195
rate. PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-ATTEND-CODE Alpha 2 BN150 PR128
Attendance Code Contains the attendance code used for PR131 PR132
creating Employee Attendance History PR134 PR136
records in PR199 (Payroll Close) The PR137 PR140
Time and Attendance system uses this PR150 PR195
field. PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-OCCURRENCE Alpha 1 BN150 PR128
Occurrence Contains the value that indicates if PR131 PR132
the referenced time is a new occurrence PR134 PR136
or a continuation of an existing PR137 PR140
occurrence. The Time and Attendance PR150 PR195
system uses this field. PR199 PR32.1
Y = Yes PR32.2 PR33.1
N = No PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-PCD-SEQ-NBR Numeric 4 BN150 PR128
Pcd Seq Nbr Contains the sequence number associated PR131 PR132
with the time record relative to the pay PR134 PR136
code. PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-TAX-STATE Alpha 2 BN150 PR128
State Taxing Contains the 2-digit state code that PR131 PR132
Authority Code represents the employee's resident PR134 PR136
state. PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-WORK-STATE Alpha 2 BN150 PR128
Work State Identifies the state in which the PR131 PR132
workers' compensation plan is affective. PR134 PR136
PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-UNION-CODE Alpha 10 BN150 PR128
Union Code Contains the union code associated with PR131 PR132
the time record. PR134 PR136
PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-PER-END-DATE Numeric 8 (yyyymmdd) BN150 PR128
Period End Date Contains the pay period end date which PR131 PR132
is determined by the employee's pay plan PR134 PR136
and the time record date. PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-OT-PREM-AMT Signed 11.2 BN150 PR128
Ot Prem Amt Contains the overtime amount associated PR131 PR132
with the time record. PR134 PR136
PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-SHIFT-DIFF Signed 11.2 BN150 PR128
Shift Differential Contains the differential from the pay PR131 PR132
code for the shift entered on the time PR134 PR136
record. PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-WC-CLASS Alpha 4 BN150 PR128
Workers Comp Contains the workers' compensation PR131 PR132
Classification classification associated with the job PR134 PR136
code entered on the time record. PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-OT-RECORD Alpha 1 BN150 PR128
Ot Record Contains the value that indicates if PR131 PR132
the time record was created for PR134 PR136
retroactive, overtime, flex time, or PR137 PR140
tips pay. PR150 PR195
Y = Yes PR199 PR32.1
R = Retro PR32.2 PR33.1
F = Flex PR33.2 PR33.3
T = Tips PR35.1 PR35.2
U = Updated PR35.3 PR35.4
X = Exception Processed PR35.5 PR35.6
O = Offset Time Record PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-WRK-END-DATE Numeric 8 (yyyymmdd) BN150 PR128
Wrk End Date Contains the work period end date which PR131 PR132
is determined by the employee's pay plan PR134 PR136
and the time record date. PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-SUPP-TAX-CODE Alpha 2 BN150 PR128
Supp Tax Code Contains the supplementary tax code PR131 PR132
associated with the time record. PR134 PR136
PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-TAX-GROUP Alpha 10 BN150 PR128
Reportable Income Contains the tax group associated with PR131 PR132
Group the time record. PR134 PR136
PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-WC-STATE Alpha 2 BN150 PR128
Wc State Contains the workers' compensation PR131 PR132
state associated with the time record. PR134 PR136
PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-PAY-PERIODS Numeric 2 BN150 PR128
Pay Periods Contains the number of times a bonus is PR131 PR132
paid during the year. The system uses PR134 PR136
this value to annualize the payment. PR137 PR140
This is used with bonus type pay codes PR150 PR195
and is referred to as the Aggregation PR199 PR32.1
with Pay Periods method. 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-POSITION Alpha 12 BN150 PR128
Position Contains the user-defined code that PR131 PR132
represents a position in the company. PR134 PR136
PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-ACTIVITY Alpha 15 BN150 PR128
Activity Activities are the processes or PR131 PR132
procedures that produce work. Cost PR134 PR136
objects (products, services, customers, PR137 PR140
and so on) are the reasons for PR150 PR195
performing the activity. Activities and PR199 PR32.1
cost object activities are used PR32.2 PR33.1
synonymously in the Activity Management PR33.2 PR33.3
system. Direct costs are posted to PR35.1 PR35.2
activities, and indirect costs are PR35.3 PR35.4
allocated to activities based on PR35.5 PR35.6
activity drivers. PR35.8 PR36.1
PR37.1 PR45.1
Activities are grouped or organized by PR530 PR80.1
activity levels. There are two kinds of PR82.1 PR85.1
activities: "posting allowed" and UK102 UK120
"summary only." Use posting level UK330
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
TRD-ACCT-CATEGORY Alpha 5 BN150 PR128
Account Category Account categories are groupings of PR131 PR132
costs, revenues, or a combination of PR134 PR136
both used for reporting and inquiries PR137 PR140
for activities in the Activity PR150 PR195
Management system. All transactions are PR199 PR32.1
posted to an account category within an PR32.2 PR33.1
activity. You can assign a specific PR33.2 PR33.3
General Ledger account or range of PR35.1 PR35.2
accounts (company, accounting unit, PR35.3 PR35.4
account, and subaccount) that make up PR35.5 PR35.6
the transactions posted to an account PR35.8 PR36.1
category using AC07.1 (Account PR37.1 PR45.1
Assignment). PR530 PR80.1
PR82.1 PR85.1
Period-to-date, year-to-date, and UK102 UK120
life-to-date balances are maintained by UK330
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 BN150
AC System Object ID The system-defined object id PR128 PR131
(Sales) representing the Activity Management PR132 PR134
committment. PR136 PR137
PR140 PR150
PR195 PR199
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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
PRSA.1 UK102
UK120 UK330
TRD-TIME-ACC-FLAG Alpha 1 BN150 PR128
Time Acc Flag Contains an L (Last) if an employee is PR131 PR132
terminating employment with the company PR134 PR136
and you are issuing the final payment PR137 PR140
through PR80.1 (Manual Payment). PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-SHFT-DIFF-RATE Signed 13.4 BN150 PR128
Shft Diff Rate The rate used to calculate the shift PR131 PR132
differential. PR134 PR136
PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-SH-OBJ-ID Numeric 12 BN150 PR128
Sh Obj Id The object id of the shift table used in PR131 PR132
calulating the SHIFT-DIFF and PR134 PR136
SHIFT-DIFF-RATE. PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-OT-RATE Signed 13.4 BN150 PR128
Ot Rate Contains the overtime rate. PR131 PR132
PR134 PR136
PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-AC-UPDATED Alpha 1 AC530
Ac Updated Indicates the completion of AC530 for
Activity Management committments.
Y = Yes
" " = No
TRD-TAX-COUNTY Alpha 10 BN150 PR128
County Taxing Contains the county taxing authority PR131 PR132
Authority Code code. PR134 PR136
PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-TAX-CITY Alpha 10 BN150 PR128
City Taxing Contains the city taxing authority code. PR131 PR132
Authority Code PR134 PR136
PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-TAX-SCHOOL Alpha 10 BN150 PR128
Tax School Contains the tax school. PR131 PR132
PR134 PR136
PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-TAX-TRANSPORT Alpha 10
Tax Transport Contains the transport tax code.
TRD-SEGMENT-FLAG Alpha 1 BN150 PR128
Segment Flag Defines if segment block data exists for PR131 PR132
the time record. PR134 PR136
PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-CURRENCY-CODE Alpha 5 BN150 PR128
Currency Code This field contains the company base PR131 PR132
currency code established in GL10.1 PR134 PR136
(Company). PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-CURR-ND Numeric 1 BN150 PR128
Currency Number of Represents the number of decimals PR131 PR132
Decimals defined for the currency of the object. PR134 PR136
PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TRD-TAX-FREQ-OVER Numeric 1 BN150 PR128
Tax Freq Over PR131 PR132
PR134 PR136
PR137 PR140
PR150 PR195
PR199 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 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TIMERECORD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TRDSET1 COMPANY AC530 BN134
EMPLOYEE BN150 HR00.1
TIME-SEQ HR01.1 HR11.1
HR511 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PBIP.1
PR05.1 PR128
PR13.1 PR131
PR132 PR134
PR135 PR136
PR137 PR139
...
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 PR137
EMPLOYEE Where STATUS = 1 PR38.1
TR-DATE
TIME-SEQ
TRDSET4 COMPANY KeyChange, Subset BN134 PR128
PROCESS-LEVEL Where STATUS = 2 PR131 PR132
EMPLOYEE Or STATUS = 3 PR135 PR140
CHECK-GRP Or STATUS = 4 PR36.1 PR45.1
SUPP-TAX-CODE UK102 UK330
PROCESS-GRP UK120
TIME-SEQ
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 PR132 PR140
PROCESS-LEVEL Where STATUS = 3 PR36.1
EMPLOYEE
CHECK-GRP
SUPP-TAX-CODE
PROCESS-GRP
TIME-SEQ
TRDSET7 COMPANY KeyChange PR140 PR20.4
PCD-SEQ-NBR UK102
EMPLOYEE
TIME-SEQ
TRDSET8 COMPANY KeyChange, Subset BN66.1 HR170
EMPLOYEE Where CHECK-ID != Zeroes HR70.1 PR139
CHECK-ID PR140 PR141
PAY-SUM-GRP PR142 PR150
TIME-SEQ PR160 PR180
PR195 PR199
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
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
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
Process Level PRSYSTEM Required
TRD-COMPANY -> PRS-COMPANY
TRD-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
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 State PRSTATE Required
When TRD-WC-STATE != Spaces
TRD-WC-STATE -> PSA-STATE
Work State PRSTATE Required
TRD-WORK-STATE -> PSA-STATE
TIMERECORD FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Position PAPOSITION
Valid When TRD-POSITION != Spaces
TRD-COMPANY -> POS-COMPANY
TRD-POSITION -> POS-POSITION
POS-EFFECT-DATE
|