Lawson Insight Technical Documentation |
|
TIMERECORD
TIMERECORD FILE
Employee Time Records
The Employee Time Cards file contains information that is used to compute an
employee's pay. It is the primary input file to PR140 (Earnings and Deductions
Calculation). There are many programs that create time records. PR199 (Payroll
Close) deletes the Employee Time Cards file records that were used during the
payroll cycle.
REFERENCED BY
HR00.1 HR01.1 HR02.1 PA115 PBIP.1 PR05.1
PR09.1 PR135 PR20.4 PR24.1 TA170 PR160
PR180 PR229 TA146 HR170 HR70.1 PR141
PR142 UK141 UK145 UK201 UK202 UK50.3
UPDATED BY
BN134 BN150 HR11.1 HR11.2 HR511 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 PR197 PR29.1 PR32.1 PR32.2 PR33.1
PR33.2 PR33.3 PR35.1 PR35.2 PR35.3 PR35.4
PR35.5 PR35.6 PR35.8 PR35.9 PR36.1 PR37.1
PR38.1 PR39.1 PR45.1 PR529 PR530 PR560
PR82.1 PR85.1 PRSA.1 UK102 UK330 TA147
TP135
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TRD-COMPANY Numeric 4 BN150 PR128
Element: Company Hr Identifies the AP company if the PR130 PR131
resource type = V. Identifies the HR PR132 PR134
company if the resource type = E. It is PR136 PR29.1
blank for type A, P or Q resources. PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-EMPLOYEE Numeric 9 BN150 PR128
Element: Employee Contains the employee number. Each PR130 PR131
person employed by the company is PR132 PR134
assigned a unique number. The system PR136 PR29.1
uses the employee number to correlate PR32.2 PR33.2
all of the information related to that PR33.3 PR35.1
person. PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-TIME-SEQ Numeric 12 BN150 PR128
Element: Sequence NumbeContains the sequence number of the PR130 PR131
time record. PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-STATUS Numeric 1 BN150 PR128
Element: Status Contains the status of the time record. PR130 PR131
0 = Unreleased (Batch) PR132 PR134
1 = Future PR136 PR137
2 = Current PR29.1 PR32.1
3 = Error PR32.2 PR33.1
4 = Processed PR33.2 PR33.3
5 = Manual PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR37.1
PR38.1 PR39.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-BATCH-NBR Numeric 6 BN150 PR128
Element: Batch Number Contains the batch number to which the PR130 PR131
entered time records belong. PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-PROCESS-LEVEL Alpha 5 BN150 HR11.1
Element: Process Lev HrContains the employee's home process HR11.2 HR511
level. 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
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR82.1
TA147 TP135
UK102
TRD-DEPARTMENT Alpha 5 BN150 HR11.1
Element: Department Contains the employee's home HR11.2 HR511
department. 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
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR82.1
TA147 TP135
UK102
TRD-PAY-SUM-GRP Alpha 3 BN150 PR128
Payment Summary Contains the pay summary group PR130 PR131
Group associated with the pay code. PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-JOB-CODE Alpha 9 BN150 PR128
Element: Job Code Contains a user-defined code that PR130 PR131
identifies a type of job. PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-PAY-CODE Alpha 4 BN150 PR128
Element: Payment Code Contains the pay code. A pay code is a PR130 PR131
user-defined code that identifies a kind PR132 PR134
of pay. PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-HOURS Signed 7.2 BN150 PR128
Element: Hours Contains the hours associated with the PR130 PR131
time record. PR132 PR134
PR136 PR197
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR82.1
PR85.1 TA147
TP135 UK102
TRD-RATE Signed 13.4 BN150 PR128
Element: Rate Contains the rate of pay associated PR130 PR131
with the time record. PR132 PR134
PR136 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 PR85.1
TA147 TP135
UK102
TRD-WAGE-AMOUNT Signed 13.2 BN150 PR128
Element: Wage Amount Contains the total wage amount for the PR130 PR131
time record as calculated according to PR132 PR134
the calculation type defined for the pay PR136 PR197
code, the employee's rate of pay, salary PR29.1 PR32.2
class, and the number of hours entered. PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR82.1
PRSA.1 TA147
TP135 UK102
TRD-SHIFT Numeric 1 BN150 PR128
Element: Shift Contains the shift number associated PR130 PR131
with the pay. PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-CHECK-GRP Alpha 1 BN150 PR128
Element: Payment Group Contains a value that identifies a PR130 PR131
check group. All time records with a PR132 PR134
common entry in this field are grouped PR136 PR29.1
on one payment record for the employee. PR32.2 PR33.2
A number in this field indicates the PR33.3 PR35.1
deduction cycle the system uses for PR35.2 PR35.3
calculating deductions on the payment. PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-PROCESS-GRP Alpha 1 BN150 PR128
Element: Process Group Identifies a process group. All time PR130 PR131
records with a common value in this PR132 PR134
field are grouped for taxing purposes PR136 PR29.1
within a check group for an employee. A PR32.2 PR33.2
number in this field indicates the PR33.3 PR35.1
deduction cycle the system uses for PR35.2 PR35.3
calculating deductions on the payment. PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-TR-DATE Numeric 8 (yyyymmdd) BN150 PR128
Element: Time Record DaContains the time record date. The PR130 PR131
system uses the time record date to PR132 PR134
determine which time records to process PR136 PR29.1
in PR38.1 (Time Record Selection) or PR32.2 PR33.2
PR137 (Batch Time Record Update). PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-DIST-PROC-LEV Alpha 5 BN150 PR128
Element: Process Lev HrContains the process level to which the PR130 PR131
system distributes wage expenses. PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-DIST-DEPART Alpha 5 BN150 PR128
Element: Department Contains the department to which the PR130 PR131
system distributes wage expenses. PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-DST-ACCT-UNIT Alpha 15 BN150 PR128
Element: Accounting UniContains the general ledger accounting PR130 PR131
unit to which the system posts the wage PR132 PR134
expense amount PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-DST-ACCOUNT Numeric 6 BN150 PR128
Element: Account Contains the general ledger account to PR130 PR131
which the system posts the wage expense PR132 PR134
amount. PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-DST-SUB-ACCT Numeric 4 BN150 PR128
Element: Subaccount Contains the general ledger subaccount PR130 PR131
to which the system posts the wage PR132 PR134
expense amount. PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-DIST-COMPANY Numeric 4 BN150 PR128
Element: Company Contains the company number to which a PR130 PR131
transaction is posted. A valid PR132 PR134
intercompany relationship must be PR136 PR29.1
defined in the General Ledger system. PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-PCT-DIST-FLAG Alpha 1 BN150 PR128
Percent Contains the value that indicates if PR130 PR131
Distribution Flag employee override distributions exist in PR132 PR134
the Emp Acct Distribution Override file. PR136 PR29.1
When the value is Y (Yes), PR150 PR32.2 PR33.2
(Distribution Edit) and PR199 (Payroll PR33.3 PR35.1
Close) use the override accounts to PR35.2 PR35.3
create Employee Payment Distribution PR35.4 PR35.5
file and GL Interface File records. PR35.6 PR35.8
Y = Distribution override exists PR35.9 PR36.1
N = No override exists PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-ERROR-FLAG Alpha 1 BN150 PR128
Element: Error Flag A value of Y (Yes) in this field PR130 PR131
indicates an error in processing the PR132 PR134
time record. PR130 (Time Record PR136 PR29.1
Interface) uses this field to indicate PR32.2 PR33.2
if a field from the interface time PR33.3 PR35.1
record does not pass the edits. If a PR35.2 PR35.3
field from the interface time record PR35.4 PR35.5
does not pass the edits, the system PR35.6 PR35.8
creates the time record with this field PR35.9 PR36.1
set to Y (Yes). Time record entry PR45.1 PR529
programs then use this field to PR530 PR560
determine if editing is still necessary. PR82.1 TA147
Y = Created with errors TP135 UK102
TRD-CHECK-ID Numeric 12 BN150 PR128
Internal Check ID Contains the payment identification PR130 PR131
Number number generated by the time record. PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-CHECK-TYPE Alpha 1 BN150 PR128
Element: Payment Type Contains the payment type. PR130 PR131
S = System PR132 PR134
M = Manual PR136 PR29.1
J = Adjustment PR32.2 PR33.2
G = Gross Up PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-SCHEDULE Alpha 9 BN150 PR128
Element: Schedule Contains the value that identifies a PR130 PR131
step and grade schedule. PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-PAY-STEP Numeric 2 BN150 PR128
Element: Step Contains the step number from the step PR130 PR131
and grade schedule. PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-PAY-GRADE Alpha 3 BN150 PR128
Element: Grade Contains the grade from the step and PR130 PR131
grade schedule. PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-ANNUAL-SALARY Signed 13.4 BN150 PR128
Element: Annual Salary Contains the calculated annual salary PR130 PR131
used for salaried employees when the PR132 PR134
time record contains step and grade PR136 PR29.1
information or is using an alternate pay PR32.2 PR33.2
rate. PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-ATTEND-CODE Alpha 2 BN150 PR128
Element: Attendance CodContains the attendance code used for PR130 PR131
creating Employee Attendance History PR132 PR134
records in PR199 (Payroll Close) The PR136 PR29.1
Time and Attendance system uses this PR32.2 PR33.2
field. PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-OCCURRENCE Alpha 1 BN150 PR128
Element: Occurrence Contains the value that indicates if PR130 PR131
the referenced time is a new occurrence PR132 PR134
or a continuation of an existing PR136 PR29.1
occurrence. The Time and Attendance PR32.2 PR33.2
system uses this field. PR33.3 PR35.1
Y = Yes PR35.2 PR35.3
N = No PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-PCD-SEQ-NBR Numeric 4 BN150 PR128
Element: Pcd Seq Nbr Contains the sequence number associated PR130 PR131
with the time record relative to the pay PR132 PR134
code. PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-TAX-STATE Alpha 2 BN150 PR128
State Taxing Contains the 2-digit state code that PR130 PR131
Authority Code represents the employee's resident PR132 PR134
state. PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-WORK-STATE Alpha 2 BN150 PR128
Element: Work State Identifies the state in which the PR130 PR131
workers' compensation plan is effective. PR132 PR134
This field stores the work state for PR136 PR29.1
withholding purposes. PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-UNION-CODE Alpha 10 BN150 PR128
Element: Union Code Contains the union code associated with PR130 PR131
the time record. PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-PER-END-DATE Numeric 8 (yyyymmdd) BN150 PR128
Element: Period End DatContains the pay period end date which PR130 PR131
is determined by the employee's pay plan PR132 PR134
and the time record date. PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TA170 TP135
UK102
TRD-OT-PREM-AMT Signed 13.2 BN150 PR128
Element: Ot Prem Amt Contains the overtime amount associated PR130 PR131
with the time record. PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 PR85.1
TA147 TP135
UK102
TRD-SHIFT-DIFF Signed 13.2 BN150 PR128
Element: Shift DifferenContains the differential from the pay PR130 PR131
code for the shift entered on the time PR132 PR134
record. PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 PR85.1
TA147 TP135
UK102
TRD-WC-CLASS Alpha 4 BN150 PR128
Workers Comp Contains the workers' compensation PR130 PR131
Classification classification associated with the job PR132 PR134
code entered on the time record. PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-OT-RECORD Alpha 1 BN150 PR128
Element: Ot Record Contains the value that indicates if PR130 PR131
the time record was created for PR132 PR134
retroactive, overtime, flex time, or PR136 PR29.1
tips pay. PR32.2 PR33.2
Y = Yes PR33.3 PR35.1
R = Retro PR35.2 PR35.3
F = Flex PR35.4 PR35.5
T = Tips PR35.6 PR35.8
U = Updated PR35.9 PR36.1
X = Exception Processed PR45.1 PR529
O = Offset Time Record PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-WRK-END-DATE Numeric 8 (yyyymmdd) BN150 PR128
Element: Wrk End Date Contains the work period end date which PR130 PR131
is determined by the employee's pay plan PR132 PR134
and the time record date. PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-SUPP-TAX-CODE Alpha 2 BN150 PR115
Element: Supp Tax Code Contains the supplementary tax code PR128 PR130
associated with the time record. PR131 PR132
PR134 PR136
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR82.1
TA147 TP135
UK102
TRD-LOCAT-CODE Alpha 10 BN150 PR128
Element: Location PR130 PR131
PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-WC-STATE Alpha 2 BN150 PR128
Element: Wc State Contains the workers' compensation PR130 PR131
state associated with the time record. PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-PAY-PERIODS Numeric 2 BN150 PR128
Element: Pay Periods Contains the number of times a bonus is PR130 PR131
paid during the year. The system uses PR132 PR134
this value to annualize the payment. PR136 PR29.1
This is used with bonus type pay codes PR32.2 PR33.2
and is referred to as the Aggregation PR33.3 PR35.1
with Pay Periods method. PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-POSITION Alpha 12 BN150 PR128
Element: Position Contains the user-defined code that PR130 PR131
represents a position in the company. PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-ACTIVITY Alpha 15 BN150 PR128
Element: Activity Activities are the processes or PR130 PR131
procedures that produce work. Cost PR132 PR134
objects (products, services, customers, PR136 PR29.1
and so on) are the reasons for PR32.2 PR33.2
performing the activity. PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-ACCT-CATEGORY Alpha 5 BN150 PR128
Element: Account CategoAccount categories are groupings of PR130 PR131
costs, revenues, or a combination of PR132 PR134
both used for reporting and inquiries PR136 PR29.1
for activities in the Activity PR32.2 PR33.2
Management system. All transactions are PR33.3 PR35.1
posted to an account category within an PR35.2 PR35.3
activity. You can assign a specific PR35.4 PR35.5
General Ledger account or range of PR35.6 PR35.8
accounts (company, accounting unit, PR35.9 PR36.1
account, and subaccount) that make up PR45.1 PR529
the transactions posted to an account PR530 PR560
category using AC07.1 (Account PR82.1 TA147
Assignment). TP135 UK102
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
Valid account category types are:
cost
revenue
accrual
pass thru
TRD-ATN-OBJ-ID Numeric 12 BN150 PR128
Object The system-defined object id PR130 PR131
Identification representing the Activity Management PR132 PR134
commitment. PR136 PR137
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR38.1
PR45.1 PR529
PR530 PR560
PR82.1 PRSA.1
TA147 TP135
UK102
TRD-GLT-OBJ-ID Numeric 12 BN150 PR128
Object This is a subsystem GL interface PR130 PR131
Identification identification number. It is used for PR132 PR134
Drill Around purposes. PR136 PR137
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR38.1
PR45.1 PR529
PR530 PR560
PR82.1 PRSA.1
TA147 TP135
UK102
TRD-TIME-ACC-FLAG Alpha 1 BN150 PR128
Element: Time Acc Flag Contains an L (Last) if an employee is PR130 PR131
terminating employment with the company PR132 PR134
and you are issuing the final payment PR136 PR29.1
through PR80.1 (Manual Payment). PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-SHFT-DIFF-RATE Signed 13.4 BN150 PR128
Element: Shft Diff RateThe rate used to calculate the shift PR130 PR131
differential. PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-SH-OBJ-ID Numeric 12 BN150 PR128
Element: Sh Obj Id The object id of the shift table used PR130 PR131
in calculating the SHIFT-DIFF and PR132 PR134
SHIFT-DIFF-RATE. PR136 PR197
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR82.1
PR85.1 TA147
TP135 UK102
TRD-OT-RATE Signed 13.4 BN150 PR128
Element: Ot Rate Contains the overtime rate. PR130 PR131
PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-AC-UPDATED Alpha 1 BN150 PR128
Element: Ac191 Updated Indicates the completion of AC530 for PR130 PR131
Activity Management commitments. PR132 PR134
Y = Yes PR136 PR29.1
" " = No PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-TAX-COUNTY Alpha 10 BN150 PR128
County Taxing Contains the county taxing authority PR130 PR131
Authority Code code. PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-TAX-CITY Alpha 10 BN150 PR128
City Taxing Contains the city taxing authority code. PR130 PR131
Authority Code PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-TAX-SCHOOL Alpha 10 BN150 PR128
Element: Tax School Contains the tax school. PR130 PR131
PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-TAX-TRANSPORT Alpha 10
Element: Tax Transport Contains the transport tax code.
TRD-SEGMENT-FLAG Alpha 1 BN150 PR128
Element: Segment Flag Defines if segment block data exists PR130 PR131
for the time record. PR132 PR134
PR136 PR197
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR82.1
PR85.1 TA147
TP135 UK102
TRD-CURRENCY-CODE Alpha 5 BN150 PR128
Element: Currency Code This field contains the company base PR130 PR131
currency code established in Company PR132 PR134
(GL10.1 ). PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-CURR-ND Numeric 1 BN150 PR128
Account Currency Represents the number of decimals PR130 PR131
Code defined for the currency of the object. PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-TAX-FREQ-OVER Numeric 1 BN150 PR128
Element: Tax Freq Over 1 = Weekly PR130 PR131
2 = Biweekly PR132 PR134
3 = Semi-monthly PR136 PR29.1
4 = Monthly PR32.2 PR33.2
5 = Daily PR33.3 PR35.1
6 = Quarterly PR35.2 PR35.3
7 = Semi-annually PR35.4 PR35.5
8 = Annually PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-COUNTRY-CODE Alpha 2 BN150 PR128
Element: Country Code The country code. Required for VAT and PR130 PR131
intrastat reporting. Must be defined in PR132 PR134
IN01.1 (Country Maintenance). PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-PAYMENT-TYPE Alpha 2 BN150 PR128
Element: Payment Type Contains the payment type. PR130 PR131
PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-REMUN-CODE Alpha 4 BN150 PR128
Element: Remun Code Contains the remuneration code. Valid PR130 PR131
value is C001 = Bonus. PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-REPORT-ENTITY Alpha 5 BN150 PR128
Element: Report Entity Contains the report entity. PR130 PR131
PR132 PR134
Report Entity is the Process Level or PR136 PR29.1
Company that this Process Level reports PR32.2 PR33.2
to for tax reporting. If the Process PR33.3 PR35.1
Level itself is independent then the PR35.2 PR35.3
independent Process Level is the Report PR35.4 PR35.5
Entity. If the Process Level is non PR35.6 PR35.8
independent and is associated to a PR35.9 PR36.1
independent head Process Level then the PR45.1 PR529
independent head Process Level is the PR530 PR560
Report Entity. If the Process Level is PR82.1 TA147
non independent and is not associated to TP135 UK102
a independent head Process Level then
the Company is the Report Entity.
TRD-BUS-NBR-GRP Alpha 4 BN150 PR128
Element: Bus Nbr Grp Contains the business number group. PR130 PR131
PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-QC-ENT-NBR-GRP Alpha 4 BN150 PR128
Element: Qc Ent Nbr GrpContains the Quebec enterprise number PR130 PR131
group. PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-CA-WC-CLASS Alpha 10 BN150 PR128
Element: Ca Wc Class Contains the Canadian WC Class from PR130 PR131
employees job. Use to identify the PR132 PR134
PRTIME wages by WC Class. PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-PENS-SEQ-NBR Numeric 4 BN150 PR128
Element: Pens Seq Nbr PR130 PR131
PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-PAY-UNITS Signed 7.2 BN150 PR128
Element: Pay Units PR130 PR131
PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-UNIT-MEASURE Alpha 12 BN150 PR128
Element: Unit Measure PR130 PR131
PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-USER-ID Alpha 10 (Lower Case) BN150 PR128
Element: User Contains the user ID of the person who PR130 PR131
last changed this record. PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-DATE-STAMP Numeric 8 (yyyymmdd) BN150 PR128
Element: Date Stamp This field contains the server date PR130 PR131
(month, date, and year) of the last PR132 PR134
change to this record. PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-NON-EARNINGS Numeric 1 BN150 PR128
Element: Non Earnings 0 = No - wages PR130 PR131
1 = Yes - other remuneration PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-ORIG-OBJ-ID Numeric 12 BN150 PR128
Element: Orig Obj Id PR130 PR131
PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-RECORD-TYPE Alpha 1 BN150 PR128
Element: Record Type Identifies adjustment status for PR130 PR131
Databasics and Grants. PR132 PR134
PR136 PR29.1
Blank = Normal (not adjusted) PR32.2 PR33.2
1 = Adjustment Offset PR33.3 PR35.1
2 = Adjustment Entry PR35.2 PR35.3
3 = Adjustment on Adjustment PR35.4 PR35.5
PR35.6 PR35.8
Additional values identify time records PR35.9 PR36.1
created from GM170: PR45.1 PR529
PR530 PR560
4 = Cost Transfer Reversing Entry PR82.1 TA147
5 = Cost Transfer Adjusting Entry TP135 UK102
TRD-LEAVE-STATUS Numeric 1 BN150 PR128
Element: Leave Status PR130 PR131
PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-REASON-CODE Alpha 4 BN150 PR128
Element: Ta Reason Cd This field contains the reason code, PR130 PR131
which indicates the cause for credit PR132 PR134
memos. PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-TES-OBJ-ID Numeric 12 BN150 PR128
Element: Tes Obj Id PR130 PR131
PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-RETRO-PENSION Alpha 1 BN150 PR128
Element: Retro Pension " " = No PR130 PR131
N = No PR132 PR134
Y = Yes; open payment PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TRD-SERVICE-CODE Alpha 4 BN150 PR128
Element: Ta Service Cd PR130 PR131
PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TIMERECORD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TRDSET1 COMPANY BN134 BN150
EMPLOYEE HR00.1 HR01.1
TIME-SEQ HR02.1 HR11.1
HR11.2 HR511
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
PR128 PR13.1
PR13.5 PR13.6
...
TRDSET10 COMPANY KeyChange, Subset PR135
PROCESS-LEVEL Where STATUS = Zeroes
EMPLOYEE
WRK-END-DATE
PAY-CODE
JOB-CODE
TR-DATE
TIME-SEQ
TRDSET11 COMPANY KeyChange, Subset PR135 PR137
PROCESS-LEVEL Where STATUS = 1
EMPLOYEE
TR-DATE
TIME-SEQ
TRDSET12 COMPANY KeyChange BN150 PR128
PROCESS-LEVEL PR130 PR131
EMPLOYEE PR132 PR134
TIME-SEQ PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 PRSA.1
UK102 TA147
TP135
TRDSET13 COMPANY KeyChange, Subset BN150 PR128
EMPLOYEE Where PENS-SEQ-NBR != Zeroes PR130 PR131
PENS-SEQ-NBR PR132 PR134
TIME-SEQ PR136 PR160
PR180 PR197
PR229 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 PR85.1
...
TRDSET14 COMPANY Subset
GLT-OBJ-ID Where GLT-OBJ-ID != Zeroes
TIME-SEQ
TRDSET15 COMPANY KeyChange, Subset
EMPLOYEE Where (LEAVE-STATUS = 2 )
ATTEND-CODE Or (LEAVE-STATUS = 3 )
TR-DATE Or (LEAVE-STATUS = 4 )
TIME-SEQ
TRDSET2 COMPANY Subset 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 PR35.9
PR37.1 PR530
TRDSET3 COMPANY KeyChange, Subset PR135 PR38.1
EMPLOYEE Where STATUS = 1
TR-DATE
TIME-SEQ
TRDSET4 COMPANY KeyChange, Subset BN134 PR128
PROCESS-LEVEL Where STATUS = 2 PR130 PR131
EMPLOYEE Or STATUS = 3 PR132 PR135
CHECK-GRP Or STATUS = 4 PR197 PR36.1
REPORT-ENTITY Or STATUS = 5 PR45.1 PR85.1
BUS-NBR-GRP UK102 UK330
SUPP-TAX-CODE TA146
PROCESS-GRP
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 PR35.9
PR37.1 PR530
TRDSET6 COMPANY KeyChange, Subset PR132 PR36.1
PROCESS-LEVEL Where STATUS = 3 TP135
EMPLOYEE
CHECK-GRP
REPORT-ENTITY
BUS-NBR-GRP
SUPP-TAX-CODE
PROCESS-GRP
TIME-SEQ
TRDSET7 COMPANY KeyChange PR115 PR20.4
PCD-SEQ-NBR UK102
EMPLOYEE
TIME-SEQ
TRDSET8 COMPANY KeyChange, Subset BN150 HR170
EMPLOYEE Where CHECK-ID != Zeroes HR70.1 PR128
CHECK-ID PR130 PR131
PAY-SUM-GRP PR132 PR134
TIME-SEQ PR136 PR137
PR141 PR142
PR160 PR180
PR197 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
...
TRDSET9 COMPANY KeyChange, Subset
ATN-OBJ-ID Where ATN-OBJ-ID != Zeroes
TIME-SEQ
TIMERECORD FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acct Category ACACCTCAT Required
When TRD-ACCT-CATEGORY != Spaces
TRD-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Activity ACACTIVITY Required
When TRD-ACTIVITY != Spaces
TRD-ACTIVITY -> ACV-ACTIVITY
Acuom ACUOM Required
When TRD-UNIT-MEASURE != Spaces
TRD-UNIT-MEASURE -> UOM-UNIT-MEASURE
Attend Code ATTENDCODE Required
When TRD-ATTEND-CODE != Spaces
TRD-COMPANY -> ATC-COMPANY
TRD-ATTEND-CODE -> ATC-ATTEND-CODE
Batch Number PRBATCH Required
When TRD-BATCH-NBR != Zeroes
TRD-COMPANY -> PRB-COMPANY
TRD-BATCH-NBR -> PRB-BATCH-NBR
Company PRSYSTEM Required
TRD-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Department DEPTCODE Required
When TRD-DEPARTMENT != Spaces
TRD-COMPANY -> DPT-COMPANY
TRD-PROCESS-LEVEL -> DPT-PROCESS-LEVEL
TRD-DEPARTMENT -> DPT-DEPARTMENT
Dist Account GLMASTER Required
When TRD-DST-ACCOUNT != Zeroes
TRD-COMPANY -> GLM-COMPANY
TRD-DST-ACCT-UNIT -> GLM-ACCT-UNIT
TRD-DST-ACCOUNT -> GLM-ACCOUNT
TRD-DST-SUB-ACCT -> GLM-SUB-ACCOUNT
Employee EMPLOYEE Required
TRD-COMPANY -> EMP-COMPANY
TRD-EMPLOYEE -> EMP-EMPLOYEE
Job Code JOBCODE Required
When TRD-JOB-CODE != Spaces
TRD-COMPANY -> JBC-COMPANY
TRD-JOB-CODE -> JBC-JOB-CODE
Pay Code PRPAYCODE Required
TRD-COMPANY -> PCD-COMPANY
TRD-PCD-SEQ-NBR -> PCD-SEQ-NBR
Pay Sum Group PAYSUMGRP Required
TRD-COMPANY -> PSG-COMPANY
TRD-PAY-SUM-GRP -> PSG-PAY-SUM-GRP
Paymastr PAYMASTR Not Required
Valid When TRD-CHECK-ID != Zeroes
TRD-COMPANY -> PYM-COMPANY
TRD-EMPLOYEE -> PYM-EMPLOYEE
TRD-CHECK-ID -> PYM-CHECK-ID
Pens Payment PRPENPAY Not Required
TRD-COMPANY -> PNP-COMPANY
TRD-EMPLOYEE -> PNP-EMPLOYEE
TRD-PENS-SEQ-NBR -> PNP-PENS-SEQ-NBR
Process Level PRSYSTEM Required
TRD-COMPANY -> PRS-COMPANY
TRD-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
Prqcentgrp PRQCENTGRP Not Required
TRD-COMPANY -> PQC-COMPANY
TRD-PROCESS-LEVEL -> PQC-PROCESS-LEVEL
TRD-QC-ENT-NBR-GRP -> PQC-QC-ENT-NBR-GRP
Reason Code TAREASCODE Required
When (TRD-REASON-CODE != Spaces )
TRD-COMPANY -> TRE-COMPANY
TRD-REASON-CODE -> TRE-REASON-CODE
Res County PRTAXAUTH Not Required
TRD-TAX-COUNTY -> PRX-TAX-ID-CODE
Res School PRTAXAUTH Not Required
TRD-TAX-SCHOOL -> PRX-TAX-ID-CODE
Res Transport PRTAXAUTH Not Required
TRD-TAX-TRANSPORT -> PRX-TAX-ID-CODE
Resident City PRTAXAUTH Not Required
TRD-TAX-CITY -> PRX-TAX-ID-CODE
Resident State PRSTATE Required
TRD-TAX-STATE -> PSA-STATE
Service Code TASERVCODE Required
When (TRD-SERVICE-CODE != Spaces )
TRD-COMPANY -> TSC-COMPANY
TRD-SERVICE-CODE -> TSC-SERVICE-CODE
Tmtime TMTIME Not Required
TRD-COMPANY -> TMT-COMPANY
TRD-EMPLOYEE -> TMT-EMPLOYEE
TRD-TIME-SEQ -> TMT-TIME-SEQ
Trsgblck TRSGBLCK Not Required
TRD-COMPANY -> TRS-COMPANY
TRD-EMPLOYEE -> TRS-EMPLOYEE
TRD-TIME-SEQ -> TRS-TIME-SEQ
Wc Province PRPROVINCE Required
When (TRD-WC-STATE != Spaces )
And (TRD-CA-WC-CLASS != Spaces )
TRD-WC-STATE -> PPV-PROVINCE
Wc State PRSTATE Required
When (TRD-WC-STATE != Spaces )
And (TRD-WC-CLASS != Spaces )
TRD-WC-STATE -> PSA-STATE
Work Province PRPROVINCE Required
When (TRD-WORK-STATE != Spaces )
And (TRD-CA-WC-CLASS != Spaces )
TRD-WORK-STATE -> PPV-PROVINCE
Work State PRSTATE Required
When (TRD-WORK-STATE != Spaces )
And (TRD-WC-CLASS != Spaces )
TRD-WORK-STATE -> PSA-STATE
TIMERECORD FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Penfsrc PRPENFSRC
TRD-COMPANY -> PNF-COMPANY
TRD-EMPLOYEE -> PNF-EMPLOYEE
TRD-PENS-SEQ-NBR -> PNF-PENS-SEQ-NBR
PNF-FUNDING-SOURCE
PNF-RETRO-PAYMENT
Position PAPOSITION
Valid When TRD-POSITION != Spaces
TRD-COMPANY -> POS-COMPANY
TRD-POSITION -> POS-POSITION
POS-EFFECT-DATE
|