TREXCEPT – This file contains exception pay codes and offsetting pay codes for deviating employee attendances, such as absences.

System: Payroll (PR)
Prefix: TRX
Primary key: COMPANY, GROUP-NAME, COLUMN-NUMBER
Fields: 8
Updated by: 2 programs
Referenced by: 7 programs

TREXCEPT is the This file contains exception pay codes and offsetting pay codes for deviating employee attendances, such as absences. table in Lawson Payroll (prefix TRX). It is indexed by COMPANY, GROUP-NAME, COLUMN-NUMBER (TRXSET1); alternate indexes: TRXSET2. It is related 1:1 to PERSGROUP and PRSYSTEM and 1:M to PRPAYCODE. It is updated by HS05.1 and PR28.1 and referenced by HR55.1, HR55.2, HR55.3, HS21.1, HS22.1, HS36.1 and PR128. The table has 8 fields, 2 indexes and 4 documented relations.

About TREXCEPT

This file contains exception pay codes and offsetting pay codes for deviating employee attendances, such as absences. It is also used by web self service to create column definitions.

Fields (8)

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

Field / column	Type	Description & values	Updated by
`TRX-COMPANY` PK COMPANY	Numeric 4	—	HS05.1, PR28.1
`TRX-GROUP-NAME` PK GROUP_NAME	Alpha 10	Contains an employee group name.	HS05.1, PR28.1
`TRX-COLUMN-NUMBER` PK COLUMN_NUMBER	Numeric 3	Contains the column number value.	HS05.1, PR28.1
`TRX-COLUMN-LABEL` COLUMN_LABEL	Alpha 15 (Lower Case)	Contains the column label to be used for Web Exception Time Entry.	HS05.1, PR28.1
`TRX-PAY-CODE` PAY_CODE	Alpha 4	Contains the pay code. A pay code is a user-defined code that identifies a kind of pay.	HS05.1, PR28.1
`TRX-OFFSET-PAY` OFFSET_PAY	Alpha 4	Contains a pay code that is to be used as the offset pay code.	HS05.1, PR28.1
`TRX-TIMECARD-TYPE` TIMECARD_TYPE	Numeric 1	Contains a value that determines the type of time record. Valid values are: 2 `0` Normal. `1` Exception.	HS22.1, HS36.1, PR28.1
`TRX-FORM-TYPE` FORM_TYPE	Alpha 1	" " = Employee `E` Employee `M` Manager	—

Indexes (2)

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
`TRXSET1`	`COMPANY`, `GROUP-NAME`, `COLUMN-NUMBER`	Primary		HR55.1, HR55.2, HR55.3, HS05.1, HS21.1, HS36.1, PR128, PR28.1
`TRXSET2`	`COMPANY`, `GROUP-NAME`, `PAY-CODE`, `COLUMN-NUMBER`	KeyChange		HS22.1, HS36.1, PR128, PR28.1

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Persgroup	PERSGROUP	Required		`TRX-COMPANY` → `PRG-COMPANY`, `TRX-GROUP-NAME` → `PRG-GROUP-NAME`
Prsystem	PRSYSTEM	Required		`TRX-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
Offset Paycode	PRPAYCODE			`TRX-COMPANY` → `PCD-COMPANY`, `TRX-OFFSET-PAY` → `PCD-PAY-CODE`, → `PCD-PROCESS-LEVEL`, → `PCD-JOB-CODE`
Paycode	PRPAYCODE			`TRX-COMPANY` → `PCD-COMPANY`, `TRX-PAY-CODE` → `PCD-PAY-CODE`, → `PCD-PROCESS-LEVEL`, → `PCD-JOB-CODE`

Programs

Updated by (2)

HS05.1 Time Record Exception Setup
PR28.1 Exception, Offset Time Record Rules

Referenced by (7)

HR55.1 Employee Group Definition
HR55.2 Employee Groups By Employees
HR55.3 Employee Groups By Criteria
HS21.1 Time Form Inquiry
HS22.1 Pending Time Summary
HS36.1 Pending Time Records
PR128 Offset Time Record Creation