OSHESTDTL – No description in the Lawson data dictionary

System
Personnel (PA)
Prefix
ODT
Primary key
COMPANY, ESTABLISHMENT, PROCESS-LEVEL, DEPARTMENT, LOCAT-CODE
Fields
5
Updated by
2 programs
Referenced by
2 programs

OSHESTDTL is a Lawson Personnel table (prefix ODT); no description in the lawson data dictionary. It is indexed by COMPANY, ESTABLISHMENT, PROCESS-LEVEL, DEPARTMENT, LOCAT-CODE (ODTSET1); alternate indexes: ODTSET2, ODTSET3 and ODTSET4. It is related 1:1 to PRSYSTEM, DEPTCODE, OSHESTAB and PCODES and 1:M to OSHA. It is updated by PA92.1 and PA92.2 and referenced by PA292 and PA490. The table has 5 fields, 4 indexes and 6 documented relations.

About OSHESTDTL

No description in the Lawson data dictionary.

Fields (5)

Column = COBOL field name without the ODT- 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
#ODT-COMPANY PK
COMPANY		Numeric 4—PA92.2
#ODT-ESTABLISHMENT PK
ESTABLISHMENT		Alpha 10—PA92.2
#ODT-PROCESS-LEVEL PK
PROCESS_LEVEL		Alpha 5—PA92.2
#ODT-DEPARTMENT PK
DEPARTMENT		Alpha 5Contains the department.PA92.2
#ODT-LOCAT-CODE PK
LOCAT_CODE		Alpha 10—PA92.2

Indexes (4)

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
ODTSET1
  1. COMPANY
  2. ESTABLISHMENT
  3. PROCESS-LEVEL
  4. DEPARTMENT
  5. LOCAT-CODE
PrimaryPA292, PA490, PA92.1, PA92.2
ODTSET2
  1. COMPANY
  2. ESTABLISHMENT
  3. LOCAT-CODE
  4. DEPARTMENT
  5. PROCESS-LEVEL
PA92.2
ODTSET3
  1. COMPANY
  2. ESTABLISHMENT
  3. LOCAT-CODE
  4. PROCESS-LEVEL
  5. DEPARTMENT
PA92.2
ODTSET4
  1. COMPANY
  2. PROCESS-LEVEL
  3. DEPARTMENT
  4. LOCAT-CODE
  5. ESTABLISHMENT
PA92.2

Relations

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

One to one (5) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
ODT-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
DepartmentDEPTCODERequiredWhen ODT-DEPARTMENT != Spaces
ODT-COMPANY→DPT-COMPANY
ODT-PROCESS-LEVEL→DPT-PROCESS-LEVEL
ODT-DEPARTMENT→DPT-DEPARTMENT
EstablishmentOSHESTABRequired
ODT-COMPANY→OTB-COMPANY
ODT-ESTABLISHMENT→OTB-ESTABLISHMENT
PcodesPCODESRequiredWhen ODT-LOCAT-CODE != Spaces
"LO"→PCO-TYPE
ODT-LOCAT-CODE→PCO-CODE
Process LevelPRSYSTEMRequiredWhen ODT-PROCESS-LEVEL != Spaces
ODT-COMPANY→PRS-COMPANY
ODT-PROCESS-LEVEL→PRS-PROCESS-LEVEL

One to many (1) — child tables

RelationTableRulesConditionField map
OshaOSHA
ODT-COMPANY→OSH-COMPANY
ODT-ESTABLISHMENT→OSH-ESTABLISHMENT
—→OSH-SEQ-NBR
—→OSH-EMPLOYEE

Programs

Updated by (2)

Referenced by (2)