TIMERECORD – Employee Time Records

System: Payroll (PR)
Prefix: TRD
Primary key: COMPANY, EMPLOYEE, TIME-SEQ
Fields: 107
Updated by: 96 programs
Referenced by: 13 programs

TIMERECORD is the Employee Time Records table in Lawson Payroll (prefix TRD). It is indexed by COMPANY, EMPLOYEE, TIME-SEQ (TRDSET1); alternate indexes: TRDSET10, TRDSET11, TRDSET12, TRDSET13, TRDSET14, TRDSET15, TRDSET2, TRDSET3 and 6 more. It is related 1:1 to ACACCTCAT, ACACTIVITY, ACUOM, ATTENDCODE, PRBATCH, PRSYSTEM, DEPTCODE, GLMASTER and 15 more and 1:M to PRPENFSRC and PAPOSITION. It is updated by BN134, BN150, BN305, BN66.1, EXI2.1, EXI4.1, HR00.1, HR01.1 and 88 more and referenced by HR04.9, HR170, HR70.1, PR05.1, PR09.1, PR141, PR142, PR160 and 5 more. The table has 107 fields, 15 indexes and 32 documented relations.

About TIMERECORD

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.

Fields (107)

Column = COBOL field name without the TRD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`TRD-COMPANY` PK COMPANY	Numeric 4	—	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-TIME-SEQ` PK TIME_SEQ	Numeric 12	Contains the sequence number of the time record.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-STATUS` STATUS	Numeric 1	Contains the status of the time record. `0` Unreleased (Batch) `1` Future `2` Current `3` Error `4` Processed `5` Manual	BN150, BN66.1, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +41 more
`TRD-BATCH-NBR` BATCH_NBR	Numeric 6	Contains the batch number to which the entered time records belong.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-PROCESS-LEVEL` PROCESS_LEVEL	Alpha 5	Contains the employee's home process level.	BN150, BN305, EXI2.1, EXI4.1, HR11.1, HR11.2, HR11.4, HR28.1 +52 more (list truncated in source)
`TRD-DEPARTMENT` DEPARTMENT	Alpha 5	Contains the employee's home department.	BN150, BN305, EXI2.1, EXI4.1, HR11.1, HR11.2, HR11.4, HR28.1 +52 more (list truncated in source)
`TRD-PAY-SUM-GRP` PAY_SUM_GRP	Alpha 3	Contains the pay summary group associated with the pay code.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-JOB-CODE` JOB_CODE	Alpha 9	Contains a user-defined code that identifies a type of job.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-PAY-CODE` PAY_CODE	Alpha 4	Contains the pay code. A pay code is a user-defined code that identifies a kind of pay.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-HOURS` HOURS	Signed 7.2	Contains the hours associated with the time record.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +35 more
`TRD-RATE` RATE	Signed 13.4	Contains the rate of pay associated with the time record.	BN150, BN66.1, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +38 more
`TRD-WAGE-AMOUNT` WAGE_AMOUNT	Signed 13.2	Contains the total wage amount for the time record as calculated according to the calculation type defined for the pay code, the employee's rate of pay, salary class, and the number of hours entered.	BN150, BN66.1, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +39 more
`TRD-SHIFT` SHIFT	Numeric 1	Contains the shift number associated with the pay.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-CHECK-GRP` CHECK_GRP	Alpha 1	Contains a value that identifies a check group. All time records with a common entry in this field are grouped on one payment record for the employee. A number in this field indicates the deduction cycle the system uses for calculating deductions on the payment.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-PROCESS-GRP` PROCESS_GRP	Alpha 1	Identifies a process group. All time records with a common value in this field are grouped for taxing purposes within a check group for an employee. A number in this field indicates the deduction cycle the application uses for calculating deductions on the payment.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-TR-DATE` TR_DATE	Numeric 8 (yyyymmdd)	Contains the time record date. The application uses the time record date to determine which time records to process in PR38.1 (Time Record Selection) or PR137 (Batch Time Record Update).	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-DIST-PROC-LEV` DIST_PROC_LEV	Alpha 5	Contains the process level to which the system distributes wage expenses.	BN150, BN66.1, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +37 more
`TRD-DIST-DEPART` DIST_DEPART	Alpha 5	Contains the department to which the system distributes wage expenses.	BN150, BN66.1, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +37 more
`TRD-DST-ACCT-UNIT` DST_ACCT_UNIT	Alpha 15	Contains the general ledger accounting unit to which the application posts the wage expense amount	BN150, BN66.1, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +37 more
`TRD-DST-ACCOUNT` DST_ACCOUNT	Numeric 6	Contains the general ledger account to which the application posts the wage expense amount.	BN150, BN66.1, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +37 more
`TRD-DST-SUB-ACCT` DST_SUB_ACCT	Numeric 4	Contains the general ledger subaccount to which the application posts the wage expense amount.	BN150, BN66.1, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +37 more
`TRD-DIST-COMPANY` DIST_COMPANY	Numeric 4	Contains the company number to which a transaction is posted. A valid intercompany relationship must be defined in the General Ledger application.	BN150, BN66.1, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +37 more
`TRD-PCT-DIST-FLAG` PCT_DIST_FLAG	Alpha 1	Contains the value that indicates if employee override distributions exist in the Emp Acct Distribution Override file. When the value is Y (Yes), PR150 (Distribution Edit) and PR199 (Payroll Close) use the override accounts to create Employee Payment Distribution file and GL Interface File records. `Y` Distribution override exists `N` No override exists	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-ERROR-FLAG` ERROR_FLAG	Alpha 1	A value of Y (Yes) in this field indicates an error in processing the time record. PR130 (Time Record Interface) uses this field to indicate if a field from the interface time record does not pass the edits. If a field from the interface time record does not pass the edits, the system creates the time record with this field set to Y (Yes). Time record entry programs then use this field to determine if editing is still necessary. `Y` Created with errors	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-CHECK-ID` CHECK_ID	Numeric 12	Contains the payment identification number generated by the time record.	BN150, BN66.1, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +37 more
`TRD-CHECK-TYPE` CHECK_TYPE	Alpha 1	Contains the payment type. `S` System `M` Manual `J` Adjustment `G` Gross Up	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-SCHEDULE` SCHEDULE	Alpha 9	Contains the value that identifies a step and grade schedule.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-PAY-STEP` PAY_STEP	Numeric 2	Contains the step number from the step and grade schedule.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-PAY-GRADE` PAY_GRADE	Alpha 3	Contains the grade from the step and grade schedule.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-ANNUAL-SALARY` ANNUAL_SALARY	Signed 13.4	Contains the calculated annual salary used for salaried employees when the time record contains step and grade information or is using an alternate pay rate.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-ATTEND-CODE` ATTEND_CODE	Alpha 2	Contains the attendance code used for creating Employee Attendance History records in PR199 (Payroll Close) The Time and Attendance system uses this field.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-OCCURRENCE` OCCURRENCE	Alpha 1	Contains the value that indicates if the referenced time is a new occurrence or a continuation of an existing occurrence. The Time and Attendance application uses this field. `Y` Yes `N` No	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-PCD-SEQ-NBR` PCD_SEQ_NBR	Numeric 8	Contains the sequence number associated with the time record relative to the pay code.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-TAX-STATE` TAX_STATE	Alpha 2	Contains the 2-digit state code that represents the employee's resident state.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-WORK-STATE` WORK_STATE	Alpha 2	Identifies the state in which the workers' compensation plan is effective. This field stores the work state for withholding purposes.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-UNION-CODE` UNION_CODE	Alpha 10	Contains the union code associated with the time record.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-PER-BEG-DATE` PER_BEG_DATE	Numeric 8 (yyyymmdd)	—	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-PER-END-DATE` PER_END_DATE	Numeric 8 (yyyymmdd)	Contains the pay period end date which is determined by the employee's pay plan and the time record date.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-OT-PREM-AMT` OT_PREM_AMT	Signed 13.2	Contains the overtime amount associated with the time record.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +33 more
`TRD-SHIFT-DIFF` SHIFT_DIFF	Signed 13.2	Contains the differential from the pay code for the shift entered on the time record.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +33 more
`TRD-WC-CLASS` WC_CLASS	Alpha 4	Contains the workers' compensation classification associated with the job code entered on the time record.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-OT-RECORD` OT_RECORD	Alpha 1	Contains the value that indicates if the time record was created for retroactive, overtime, flex time, or tips pay. `Y` Yes `R` Retro `F` Flex `T` Tips `U` Updated `X` Exception Processed `O` Offset Time Record `P` Payout `C` Created by Employee Contract `I` Created by BN150	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-WRK-BEG-DATE` WRK_BEG_DATE	Numeric 8 (yyyymmdd)	—	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-WRK-END-DATE` WRK_END_DATE	Numeric 8 (yyyymmdd)	Contains the work period end date which is determined by the employee's pay plan and the time record date.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-SUPP-TAX-CODE` SUPP_TAX_CODE	Alpha 2	Contains the supplementary tax code associated with the time record.	BN150, EXI2.1, EXI4.1, LP130, PR115, PR128, PR131, PR132 +33 more
`TRD-LOCAT-CODE` LOCAT_CODE	Alpha 10	—	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-WC-STATE` WC_STATE	Alpha 2	Contains the workers' compensation state associated with the time record.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-PAY-PERIODS` PAY_PERIODS	Numeric 2	Contains the number of times a bonus is paid during the year. The system uses this value to annualize the payment. This is used with bonus type pay codes and is referred to as the Aggregation with Pay Periods method.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-POSITION` POSITION	Alpha 12	Contains the user-defined code that represents a position in the company.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-ACTIVITY` ACTIVITY	Alpha 15	Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account 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. Valid account category types are: cost revenue accrual pass thru	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-ATN-OBJ-ID` ATN_OBJ_ID	Numeric 12	This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +33 more
`TRD-GLT-OBJ-ID` GLT_OBJ_ID	Numeric 12	This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +33 more
`TRD-TIME-ACC-FLAG` TIME_ACC_FLAG	Alpha 1	Contains an L (Last) if an employee is terminating employment with the company and you are issuing the final payment through PR80.1 (Manual Payment). `A` Created by LP Neg Bal Options	BN150, BN66.1, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +37 more
`TRD-SHFT-DIFF-RATE` SHFT_DIFF_RATE	Signed 13.4	The rate used to calculate the shift differential.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-SH-OBJ-ID` SH_OBJ_ID	Numeric 12	The object id of the shift table used in calculating the SHIFT-DIFF and SHIFT-DIFF-RATE.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +35 more
`TRD-OT-RATE` OT_RATE	Signed 13.4	Contains the overtime rate.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-AC-UPDATED` AC_UPDATED	Alpha 1	" " = No `Y` Yes	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-TAX-COUNTY` TAX_COUNTY	Alpha 10	Contains the county taxing authority code.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-TAX-CITY` TAX_CITY	Alpha 10	Contains the city taxing authority code.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-TAX-SCHOOL` TAX_SCHOOL	Alpha 10	Contains the tax school.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-TAX-TRANSPORT` TAX_TRANSPORT	Alpha 10	Contains the transport tax code.	—
`TRD-SEGMENT-FLAG` SEGMENT_FLAG	Alpha 1	Defines if segment block data exists for the time record.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +35 more
`TRD-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field contains the company base currency code established in Company (GL10.1 ).	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-CURR-ND` CURR_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-TAX-FREQ-OVER` TAX_FREQ_OVER	Numeric 3	Number of Pay Periods Per Year that is used to determine how to calculate amount of taxes withheld. `001` Weekly `002` Biweekly `003` Semi-monthly `004` Monthly `005` Daily `006` Quarterly `007` Semi-annually `008` Annually `009` 9 Month Academic Monthly `010` 10 Month Academic Monthly	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-COUNTRY-CODE` COUNTRY_CODE	Alpha 2	The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-PAYMENT-TYPE` PAYMENT_TYPE	Alpha 2	Contains the payment type.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-REMUN-CODE` REMUN_CODE	Alpha 4	Contains the remuneration code. Valid value is C001 = Bonus. `E002` US Pay Advances `E003` US Athletic Facilities `E004` US Non-Qual Plan Awrds and Prz `E005` US Back Pay `E006` US Bonuses `E007` US Business Expense `E009` US Gifts `E010` US Commissions `E013` US Discounts `E014` US Dismissal/Severance `E015` US Educational Assistance `E016` US Employment Agency `E017` US Qual Equip/Tool/Uniform `E018` US Business Use of Company Car `E019` US Personal Use of Company Car `E020` US No Additional Cost Services `E021` US Golden Parachute `E022` US Group Legal Services `E023` US Guaranteed Wage `E024` US Jury Duty Pay `E025` US Below Market Loans to Empl `E026` US Meals and Lodging `E027` US Supplemental Military Pay `E028` US Qualified Moving Expenses `E029` US Non-Cash Fringe `E030` US Outplacement Services `E031` US Overtime `E032` US Qualified Parking `E033` US Pre-employment Reimbursmnt `E034` US Probationary Pay `E035` US Regular Wages `E036` US Scholarships `E037` US Sick/Disability Pay `E038` US Standby/Idle Time `E039` US Stock Purch & Incentive Pln `E040` US Supper Money `E041` US Supplemental Unemployment `E042` US Taxes Paid by Employer `E043` US Tips `E044` US Travel; Exp Reimbursement `E045` US Tuition Reimbursement `E046` US Union Pay `E047` US Vacation Pay `E048` US Group Term Life G.T. 50000 `E049` US Ministers Housing Allowance `E999` US Custom Earnings `E051` US Income Under Section 409A `E052` US Transportation CHV `E055` US Commuter Benefits `E067` US Tips Non-Taxable `E068` US Diff Pay - Active Mil Duty `E070` US EE Adult Child Hlth Ins `E071` US ER Adult Child Hlth Ins	BN150, EXI2.1, EXI4.1, LP130, PR115, PR128, PR131, PR132 +33 more
`TRD-REPORT-ENTITY` REPORT_ENTITY	Alpha 5	Contains the report entity. Report Entity is the Process Level or Company that this Process Level reports to for tax reporting. If the Process Level itself is independent then the independent Process Level is the Report Entity. If the Process Level is non independent and is associated to a independent head Process Level then the independent head Process Level is the 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.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-BUS-NBR-GRP` BUS_NBR_GRP	Alpha 4	Contains the business number group.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-QC-ENT-NBR-GRP` QC_ENT_NBR_GRP	Alpha 4	Contains the Quebec enterprise number group.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-CA-WC-CLASS` CA_WC_CLASS	Alpha 10	Contains the Canadian WC Class from employees job. Use to identify the PRTIME wages by WC Class.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-PENS-SEQ-NBR` PENS_SEQ_NBR	Numeric 4	—	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-PAY-UNITS` PAY_UNITS	Signed 7.2	—	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-UNIT-MEASURE` UNIT_MEASURE	Alpha 12	—	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	BN150, BN305, BN66.1, EXI2.1, EXI4.1, HR11.1, HR11.2, HR11.4 +52 more (list truncated in source)
`TRD-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	BN150, BN305, BN66.1, EXI2.1, EXI4.1, HR11.1, HR11.2, HR11.4 +52 more (list truncated in source)
`TRD-NON-EARNINGS` NON_EARNINGS	Numeric 1	— `0` No - wages `1` Yes - other remuneration	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-ORIG-OBJ-ID` ORIG_OBJ_ID	Numeric 12	—	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-RECORD-TYPE` RECORD_TYPE	Alpha 1	Identifies adjustment status for Databasics and Grants. Additional values identify time records created from GM170: `Blank` Normal (not adjusted) `1` Adjustment Offset `2` Adjustment Entry `3` Adjustment on Adjustment `4` Cost Transfer Reversing Entry `5` Cost Transfer Adjusting Entry	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-LEAVE-STATUS` LEAVE_STATUS	Numeric 1	—	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-REASON-CODE` REASON_CODE	Alpha 4	—	BN150, EXI2.1, EXI4.1, LP130, LP54.1, PR128, PR131, PR132 +33 more
`TRD-TES-OBJ-ID` TES_OBJ_ID	Numeric 12	—	BN150, EXI2.1, EXI4.1, LP130, LP353, PR128, PR131, PR132 +33 more
`TRD-RETRO-PENSION` RETRO_PENSION	Alpha 1	" " = No `N` No `Y` Yes; open payment	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-SERVICE-CODE` SERVICE_CODE	Alpha 10	—	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	BN150, BN305, BN66.1, EXI2.1, EXI4.1, HR11.1, HR11.2, HR11.4 +52 more (list truncated in source)
`TRD-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	Contains the user ID of the person who last changed this record.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-LNK-TIME-SEQ` LNK_TIME_SEQ	Numeric 12	Used to associate user created time records with LP created time records.	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-CONT-SEQ-NBR` CONT_SEQ_NBR	Numeric 12	—	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-CONTRACT-YEAR` CONTRACT_YEAR	Numeric 4	—	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-CWC-EFFECT-DT` CWC_EFFECT_DT	Numeric 8 (yyyymmdd)	—	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-CONTRACT-NBR` CONTRACT_NBR	Numeric 6	—	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-SEGMENT-NBR` SEGMENT_NBR	Numeric 6	—	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-CYC-START-DATE` CYC_START_DATE	Numeric 8 (yyyymmdd)	—	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-CYC-END-DATE` CYC_END_DATE	Numeric 8 (yyyymmdd)	—	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-CM-REG-FLAG` CM_REG_FLAG	Numeric 1	— `0` Non-contract `1` Regular pay `2` Reserve pay `3` Docking pay `4` Adjustment `5` Summer Deferral	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-CM130-FLAG` CM130_FLAG	Numeric 1	— `0` No `1` Yes	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-MEMO` MEMO	Alpha 64 (Lower Case)	—	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-ABN-OBJ-ID` ABN_OBJ_ID	Numeric 12	—	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-EXP-RPT-NBR` EXP_RPT_NBR	Alpha 22	—	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-REC-TYPE` REC_TYPE	Numeric 4	—	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more
`TRD-NOTIONAL` NOTIONAL	Signed 13.4	—	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +33 more
`TRD-ADDTL-RATE` ADDTL_RATE	Numeric 1	—	BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +32 more

Indexes (15)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`TRDSET1`	`COMPANY`, `EMPLOYEE`, `TIME-SEQ`	Primary		BN134, BN150, BN305, BN66.1, HR00.1, HR01.1, HR02.1, HR04.9 +22 more (list truncated in source)
`TRDSET10`	`COMPANY`, `PROCESS-LEVEL`, `EMPLOYEE`, `WRK-END-DATE`, `PAY-CODE`, `JOB-CODE`, `TR-DATE`, `TIME-SEQ`	KeyChange, Subset	Where STATUS = Zeroes	LP130, PR135
`TRDSET11`	`COMPANY`, `PROCESS-LEVEL`, `EMPLOYEE`, `TR-DATE`, `TIME-SEQ`	KeyChange, Subset	Where STATUS = 1	LP130, PR135, PR137
`TRDSET12`	`COMPANY`, `PROCESS-LEVEL`, `EMPLOYEE`, `TIME-SEQ`	KeyChange		BN150, BN66.1, PR521, EXI2.1, EXI4.1, LP130, PR128, PR131 +22 more (list truncated in source)
`TRDSET13`	`COMPANY`, `EMPLOYEE`, `PENS-SEQ-NBR`, `TIME-SEQ`	KeyChange, Subset	Where PENS-SEQ-NBR != Zeroes	BN150, PR521, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +22 more (list truncated in source)
`TRDSET14`	`COMPANY`, `GLT-OBJ-ID`, `TIME-SEQ`	Subset	Where GLT-OBJ-ID != Zeroes	—
`TRDSET15`	`COMPANY`, `EMPLOYEE`, `ATTEND-CODE`, `TR-DATE`, `TIME-SEQ`	KeyChange, Subset	Where (LEAVE-STATUS = 2) Or (LEAVE-STATUS = 3) Or (LEAVE-STATUS = 4)	—
`TRDSET2`	`COMPANY`, `BATCH-NBR`, `TIME-SEQ`	Subset	Where ERROR-FLAG != Spaces	BN150, PR521, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +22 more (list truncated in source)
`TRDSET3`	`COMPANY`, `EMPLOYEE`, `TR-DATE`, `TIME-SEQ`	KeyChange, Subset	Where STATUS = 1	PR135, PR38.1
`TRDSET4`	`COMPANY`, `PROCESS-LEVEL`, `EMPLOYEE`, `CHECK-GRP`, `REPORT-ENTITY`, `BUS-NBR-GRP`, `SUPP-TAX-CODE`, `PROCESS-GRP`, `TIME-SEQ`	KeyChange, Subset	Where STATUS = 2 Or STATUS = 3 Or STATUS = 4 Or STATUS = 5	BN134, BN66.1, LP130, PR128, PR131, PR132, PR135, PR138 +11 more
`TRDSET5`	`COMPANY`, `BATCH-NBR`, `EMPLOYEE`, `WRK-END-DATE`, `PAY-CODE`, `JOB-CODE`, `TR-DATE`, `TIME-SEQ`	KeyChange, Subset	Where STATUS = Zeroes	BN150, PR521, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +22 more (list truncated in source)
`TRDSET6`	`COMPANY`, `PROCESS-LEVEL`, `EMPLOYEE`, `CHECK-GRP`, `REPORT-ENTITY`, `BUS-NBR-GRP`, `SUPP-TAX-CODE`, `PROCESS-GRP`, `TIME-SEQ`	KeyChange, Subset	Where STATUS = 3	BN66.1, PR132, PR140, PR189, PR195, PR36.1, PR36.4, PR80.1 +3 more
`TRDSET7`	`COMPANY`, `PCD-SEQ-NBR`, `EMPLOYEE`, `TIME-SEQ`	KeyChange		BN150, PR521, EXI2.1, EXI4.1, LP130, PR115, PR128, PR131 +22 more (list truncated in source)
`TRDSET8`	`COMPANY`, `EMPLOYEE`, `CHECK-ID`, `PAY-SUM-GRP`, `TIME-SEQ`	KeyChange, Subset	Where CHECK-ID != Zeroes	BN150, BN66.1, HR170, HR70.1, PR521, EXI2.1, EXI4.1, LP130 +22 more (list truncated in source)
`TRDSET9`	`COMPANY`, `ATN-OBJ-ID`, `TIME-SEQ`	KeyChange, Subset	Where ATN-OBJ-ID != Zeroes	—

Relations

One to one (30) — lookups and parents

Relation	Table	Rules	Condition	Field map
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`
Taempserv	TAEMPSERV	Not Required	Valid When TRD-TES-OBJ-ID != Zeroes	`TRD-COMPANY` → `TES-COMPANY`, `TRD-EMPLOYEE` → `TES-EMPLOYEE`, `TRD-TES-OBJ-ID` → `TES-TES-OBJ-ID`
Tax Group	C6TAXGRP	Required		`TRD-COMPANY` → `C6G-COMPANY`, `TRD-PROCESS-LEVEL` → `C6G-PROCESS-LEVEL`, `TRD-BUS-NBR-GRP` → `C6G-BUS-NBR-GRP`
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`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
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`

Programs

Updated by (96)

BN134 Current Flex Time Record Delete
BN150 Life Insurance Reportable Income
BN305 Highly Compensated Employees
BN66.1 Estimated Pay Calculation
EXI2.1 Invoke for PRTRDPD
EXI4.1 Invoke for PRPRBPD
HR00.1 Company
HR01.1 Process Level
HR02.1 Department
HR06.1 Job Code
HR11.1 Employee
HR11.2 Compensation Analysis
HR11.4 Employee Assignment Inquiry
HR28.1 Employee Ethnicity
HR506 Job Code Conversion
HR511 Employee Conversion
LP130 Absence Plan Payout
LP353 Employee Service History Purge
LP54.1 Employee Event History Update
LT101 HRM Receiver Update
LT111 HRM Receiver Update
PA02.1 Position
PA100 Action Update
PA102 Position Update
PA115 Employee Purge
PA13.1 Multiple Positions and Jobs
PA13.2 Multiple Position and Job History
PA502 Position Conversion
PA513 Position and Job Conversion
PA52.1 Individual Action
PA52.3 Mass Action
PA52.4 Hire an Applicant
PA52.5 Position and Job Action
PA95.1 Grade Range Schedule
PR01.2 Bank Code
PR110 Step And Grade Audit
PR113 United States Tax Deduction Update
PR115 Deduction, Garnishment Fee, Pay Summary Grp Update
PR12.6 Employee Automatic Deposit
PR120 Mass Pay Update
PR128 Offset Time Record Creation
PR13.1 Employee United States Taxes
PR13.5 Employee Canada Taxes
PR13.6 Employee Canada Taxes
PR13.8 U.S. Tax Deduction Errors
PR13.9 Employee Additional Tax Details
PR131 Retroactive Pay Calculation
PR132 FLSA Overtime Calculation
PR134 Automatic Time Records
PR135 Time Record Edit
PR136 Missing Time Records
PR137 Batch Time Record Update
PR138 Percent of Earnings Calculation
PR139 Arrears Automation
PR140 Earnings and Deductions Calculation
PR189 Gross Up Calculation
PR195 Accrual Program
PR197 Payroll Close
PR20.4 Pay Code
PR29.1 Pension Payment Maintenance
PR30.2 Employee Automatic Time Record
PR32.1 Employee Daily Time Entry
PR32.2 Employee Daily Time Entry
PR33.1 Speed Entry Setup
PR33.2 Speed Entry by Number
PR33.3 Speed Entry by Name
PR35.1 Time Entry
PR35.2 Detail Time Entry
PR35.3 Speed Time Entry
PR35.4 Step and Grade, Grade Range Time Entry
PR35.5 Attendance Time Entry
PR35.6 Activity Time Entry
PR35.8 Position Time Entry
PR35.9 Reason Code Time Entry
PR36.1 Time Record Entry
PR36.4 Manual Time Record Maintenance
PR37.1 Batch Time Control
PR38.1 Time Record Selection
PR39.1 One Time Deduction
PR45.1 Error Processing
PR512 Employee ACH Distribution Interface
PR521 Nonstandard Pay and Work Period CSV Load
PR529 Pension Payroll Conversion
PR530 Time Record Interface CSV
PR539 One Time Deduction Load
PR560 Payroll History Load CSV
PR582 Mass Adjustment Load
PR80.1 Manual Check
PR80.4 Manual Payment
PR82.1 Adjustment
PR85.1 Bank Account Reconciliation
PR89.1 Payment Modeling
PRAT.1 Alltax connection test
TA147 Canada Vacation Audit
UK102 Bonus Pay Update
ZH510 Update PCP from ZPENDPCP

Referenced by (13)

HR04.9 Human Resource Codes
HR170 Human Resource Writer Report Request
HR70.1 Human Resource Writer Inquiry
PR05.1 Deduction
PR09.1 Head Process Level
PR141 Payroll Register
PR142 Consolidated Payroll Register
PR160 Payment Print
PR180 Manual Payment Print
PR229 Pension Participant Listing
PR24.1 Shift Table
PR274 Statistics Canada
ZP139 PPH Union Dues Calc