TAREASONS – Reason Class & Code Relations

System
Absence Management (LP)
Prefix
TRO
Primary key
COMPANY, REASON-CLASS, REASON-CODE
Fields
3
Updated by
6 programs
Referenced by
11 programs

TAREASONS is the Reason Class & Code Relations table in Lawson Absence Management (prefix TRO). It is indexed by COMPANY, REASON-CLASS, REASON-CODE (TROSET1); alternate indexes: TROSET2. It is related 1:1 to PRSYSTEM, TAREASCLSS and TAREASCODE. It is updated by HR00.1, HR01.1, LP09.1, LP09.2, LP09.3 and LP09.4 and referenced by LP199, LP211, LP251, LP260, LP262, LP353, LP60.2, LP60.4 and 3 more. The table has 3 fields, 2 indexes and 3 documented relations.

About TAREASONS

No description in the Lawson data dictionary.

Fields (3)

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

Field / columnTypeDescription & valuesUpdated by
TRO-COMPANY PK
COMPANY		Numeric 4—LP09.3, LP09.4
TRO-REASON-CLASS PK
REASON_CLASS		Alpha 3—LP09.3, LP09.4
TRO-REASON-CODE PK
REASON_CODE		Alpha 4—LP09.3, LP09.4

Indexes (2)

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

IndexKeysFlagsConditionUsed in
TROSET1COMPANY, REASON-CLASS, REASON-CODEPrimaryHR00.1, HR01.1, LP09.1, LP09.3, LP211, LP251, LP260, LP262 +6 more
TROSET2COMPANY, REASON-CODE, REASON-CLASSLP09.2, LP09.4, LP199

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredTRO-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
Reason ClassTAREASCLSSRequiredTRO-COMPANY → TRL-COMPANY, TRO-REASON-CLASS → TRL-REASON-CLASS
Reason CodeTAREASCODERequiredTRO-COMPANY → TRE-COMPANY, TRO-REASON-CODE → TRE-REASON-CODE

Programs

Updated by (6)

Referenced by (11)