TAREASCODE – Absence Plan Reason Code

System
Absence Management (LP)
Prefix
TRE
Primary key
COMPANY, REASON-CODE
Fields
8
Updated by
5 programs
Referenced by
57 programs

TAREASCODE is the Absence Plan Reason Code table in Lawson Absence Management (prefix TRE). It is indexed by COMPANY, REASON-CODE (TRESET1). It is related 1:1 to PRSYSTEM and TASERVCODE and 1:M to TAREASONS. It is updated by HR00.1, HR01.1, LP08.2, LP09.2 and LP209 and referenced by BN150, EXI2.1, EXI4.1, LP10.1, LP130, LP199, LP201, LP208 and 49 more. The table has 8 fields, 1 index and 3 documented relations.

About TAREASCODE

No description in the Lawson data dictionary.

Fields (8)

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

Field / columnTypeDescription & valuesUpdated by
TRE-COMPANY PK
COMPANY		Numeric 4—LP09.2
TRE-REASON-CODE PK
REASON_CODE		Alpha 4—LP09.2
TRE-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)—LP09.2
TRE-REASON-TYPE
REASON_TYPE		Numeric 1—
  • 1 Absence
  • 2 Non Absence
LP09.2
TRE-PLAN-BALANCE
PLAN_BALANCE		Numeric 1—
  • 0 None
  • 1 Available
  • 2 Reserve
LP09.2
TRE-SERVICE-CODE
SERVICE_CODE		Alpha 10—LP09.2
TRE-POINTS
POINTS		Signed 7.2—LP09.2
TRE-STATUS
STATUS		Numeric 1—
  • 0 Active
  • 1 Inactive
LP09.2

Indexes (1)

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

IndexKeysFlagsConditionUsed in
TRESET1COMPANY, REASON-CODEPrimaryBN150, HR00.1, HR01.1, PR521, EXI2.1, EXI4.1, LP08.2, LP09.2 +22 more (list truncated in source)

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredTRE-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
Service CodeTASERVCODERequiredWhen (TRE-SERVICE-CODE != Spaces)TRE-COMPANY → TSC-COMPANY, TRE-SERVICE-CODE → TSC-SERVICE-CODE

One to many (1) — child tables

RelationTableRulesConditionField map
Ta ReasonTAREASONSDelete CascadesTRE-COMPANY → TRO-COMPANY, TRE-REASON-CODE → TRO-REASON-CODE, → TRO-REASON-CLASS

Programs

Updated by (5)

Referenced by (57)