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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#TRX-COMPANY PK
COMPANY		Numeric 4—HS05.1, PR28.1
#TRX-GROUP-NAME PK
GROUP_NAME		Alpha 10Contains an employee group name.HS05.1, PR28.1
#TRX-COLUMN-NUMBER PK
COLUMN_NUMBER		Numeric 3Contains 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 SET2
PAY_CODE		Alpha 4Contains 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 4Contains a pay code that is to be used as the offset pay code.HS05.1, PR28.1
#TRX-TIMECARD-TYPE
TIMECARD_TYPE		Numeric 1Contains 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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
TRXSET1
  1. COMPANY
  2. GROUP-NAME
  3. COLUMN-NUMBER
PrimaryHR55.1, HR55.2, HR55.3, HS05.1, HS21.1, HS36.1, PR128, PR28.1
TRXSET2
  1. COMPANY
  2. GROUP-NAME
  3. PAY-CODE
  4. COLUMN-NUMBER
KeyChangeHS22.1, HS36.1, PR128, PR28.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PERSGROUPPRSYSTEMPRPAYCODETREXCEPT

One to one (2) — lookups and parents

RelationTableRulesConditionField map
PersgroupPERSGROUPRequired
TRX-COMPANY→PRG-COMPANY
TRX-GROUP-NAME→PRG-GROUP-NAME
PrsystemPRSYSTEMRequired
TRX-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL

One to many (2) — child tables

RelationTableRulesConditionField map
Offset PaycodePRPAYCODE
TRX-COMPANY→PCD-COMPANY
TRX-OFFSET-PAY→PCD-PAY-CODE
—→PCD-PROCESS-LEVEL
—→PCD-JOB-CODE
PaycodePRPAYCODE
TRX-COMPANY→PCD-COMPANY
TRX-PAY-CODE→PCD-PAY-CODE
—→PCD-PROCESS-LEVEL
—→PCD-JOB-CODE

Programs

Updated by (2)

Referenced by (7)