EEODETAIL – EEO Establishment Detail
- System
- Personnel (PA)
- Prefix
EOD- Primary key
COMPANY,ESTBLSH-NBR,PROCESS-LEVEL,DEPARTMENT,LOCAT-CODE- Fields
- 5
- Updated by
- 5 programs
- Referenced by
- 3 programs
EEODETAIL is the EEO Establishment Detail table in Lawson Personnel (prefix EOD). It is indexed by COMPANY, ESTBLSH-NBR, PROCESS-LEVEL, DEPARTMENT, LOCAT-CODE (EODSET1); alternate indexes: EODSET2 and EODSET3. It is related 1:1 to PRSYSTEM, DEPTCODE, EEOUNIT and PCODES. It is updated by PA93.1, PA93.2, PA93.4, PA93.5 and PA93.6 and referenced by PA390, PA392 and PA393. The table has 5 fields, 3 indexes and 5 documented relations.
About EEODETAIL
The EEO Establishment Detail file contains EEO establishment structures where the company reports multi-establishments. An EEO establishment consists of one or more combinations of process levels and departments.
Fields (5)
Column = COBOL field name without the EOD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
EOD-COMPANY PKCOMPANY | Numeric 4 | Contains the company number which represents an established company. | PA93.4 |
EOD-ESTBLSH-NBR PKESTBLSH_NBR | Alpha 9 | Contains the establishment number. Establishment numbers are setup in the EEO Establishment file. | PA93.4 |
EOD-PROCESS-LEVEL PKPROCESS_LEVEL | Alpha 5 | Contains the process level. | PA93.4 |
EOD-DEPARTMENT PKDEPARTMENT | Alpha 5 | Contains the department. | PA93.4 |
EOD-LOCAT-CODE PKLOCAT_CODE | Alpha 10 | Location code defines locations that are valid within an establishment. | PA93.4 |
Indexes (3)
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 |
|---|---|---|---|---|
EODSET1 | COMPANY, ESTBLSH-NBR, PROCESS-LEVEL, DEPARTMENT, LOCAT-CODE | Primary | PA393, PA93.2, PA93.4, PA93.6 | |
EODSET2 | COMPANY, PROCESS-LEVEL, DEPARTMENT, LOCAT-CODE | PA390, PA392, PA393, PA93.1, PA93.4, PA93.5 | ||
EODSET3 | COMPANY, LOCAT-CODE, PROCESS-LEVEL, DEPARTMENT | — |
Relations
One to one (5) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Company | PRSYSTEM | Required | EOD-COMPANY → PRS-COMPANY (PRSSET1), Spaces → PRS-PROCESS-LEVEL | |
| Department | DEPTCODE | Required | When (EOD-DEPARTMENT != Spaces) And (EOD-DEPARTMENT != "ALL") | EOD-COMPANY → DPT-COMPANY, EOD-PROCESS-LEVEL → DPT-PROCESS-LEVEL, EOD-DEPARTMENT → DPT-DEPARTMENT |
| Establishment | EEOUNIT | Required | EOD-COMPANY → EEO-COMPANY, EOD-ESTBLSH-NBR → EEO-ESTBLSH-NBR | |
| Pcodes | PCODES | Required | When (EOD-LOCAT-CODE != Spaces) And (EOD-LOCAT-CODE != "ALL") | "LO" → PCO-TYPE, EOD-LOCAT-CODE → PCO-CODE |
| Process Level | PRSYSTEM | Required | When EOD-PROCESS-LEVEL != Spaces | EOD-COMPANY → PRS-COMPANY, EOD-PROCESS-LEVEL → PRS-PROCESS-LEVEL |
Programs
Updated by (5)
- PA93.1 EEO-1 Company
- PA93.2 EEO-1 Multi-Establishment
- PA93.4 Selection Critera
- PA93.5 EEO-5 Single Schools/Districts
- PA93.6 EEO-5 Multiple Schools/Districts