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