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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
ODT-COMPANY PKCOMPANY | Numeric 4 | — | PA92.2 |
ODT-ESTABLISHMENT PKESTABLISHMENT | Alpha 10 | — | PA92.2 |
ODT-PROCESS-LEVEL PKPROCESS_LEVEL | Alpha 5 | — | PA92.2 |
ODT-DEPARTMENT PKDEPARTMENT | Alpha 5 | Contains the department. | PA92.2 |
ODT-LOCAT-CODE PKLOCAT_CODE | Alpha 10 | — | PA92.2 |
Indexes (4)
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 |
|---|---|---|---|---|
ODTSET1 | COMPANY, ESTABLISHMENT, PROCESS-LEVEL, DEPARTMENT, LOCAT-CODE | Primary | PA292, PA490, PA92.1, PA92.2 | |
ODTSET2 | COMPANY, ESTABLISHMENT, LOCAT-CODE, DEPARTMENT, PROCESS-LEVEL | PA92.2 | ||
ODTSET3 | COMPANY, ESTABLISHMENT, LOCAT-CODE, PROCESS-LEVEL, DEPARTMENT | PA92.2 | ||
ODTSET4 | COMPANY, PROCESS-LEVEL, DEPARTMENT, LOCAT-CODE, ESTABLISHMENT | PA92.2 |
Relations
One to one (5) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Company | PRSYSTEM | Required | ODT-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL | |
| Department | DEPTCODE | Required | When ODT-DEPARTMENT != Spaces | ODT-COMPANY → DPT-COMPANY, ODT-PROCESS-LEVEL → DPT-PROCESS-LEVEL, ODT-DEPARTMENT → DPT-DEPARTMENT |
| Establishment | OSHESTAB | Required | ODT-COMPANY → OTB-COMPANY, ODT-ESTABLISHMENT → OTB-ESTABLISHMENT | |
| Pcodes | PCODES | Required | When ODT-LOCAT-CODE != Spaces | "LO" → PCO-TYPE, ODT-LOCAT-CODE → PCO-CODE |
| Process Level | PRSYSTEM | Required | When ODT-PROCESS-LEVEL != Spaces | ODT-COMPANY → PRS-COMPANY, ODT-PROCESS-LEVEL → PRS-PROCESS-LEVEL |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Osha | OSHA | ODT-COMPANY → OSH-COMPANY, ODT-ESTABLISHMENT → OSH-ESTABLISHMENT, OSH-SEQ-NBR, OSH-EMPLOYEE |