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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#EOD-COMPANY PK
COMPANY		Numeric 4Contains the company number which represents an established company.PA93.4
#EOD-ESTBLSH-NBR PK
ESTBLSH_NBR		Alpha 9Contains the establishment number. Establishment numbers are setup in the EEO Establishment file.PA93.4
#EOD-PROCESS-LEVEL PK
PROCESS_LEVEL		Alpha 5Contains the process level.PA93.4
#EOD-DEPARTMENT PK
DEPARTMENT		Alpha 5Contains the department.PA93.4
#EOD-LOCAT-CODE PK
LOCAT_CODE		Alpha 10Location code defines locations that are valid within an establishment.PA93.4

Indexes (3)

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
EODSET1
  1. COMPANY
  2. ESTBLSH-NBR
  3. PROCESS-LEVEL
  4. DEPARTMENT
  5. LOCAT-CODE
PrimaryPA393, PA93.2, PA93.4, PA93.6
EODSET2
  1. COMPANY
  2. PROCESS-LEVEL
  3. DEPARTMENT
  4. LOCAT-CODE
PA390, PA392, PA393, PA93.1, PA93.4, PA93.5
EODSET3
  1. COMPANY
  2. LOCAT-CODE
  3. PROCESS-LEVEL
  4. DEPARTMENT
—

Relations

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

One to one (5) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
EOD-COMPANY→PRS-COMPANY (PRSSET1)
Spaces→PRS-PROCESS-LEVEL
DepartmentDEPTCODERequiredWhen (EOD-DEPARTMENT != Spaces) And (EOD-DEPARTMENT != "ALL")
EOD-COMPANY→DPT-COMPANY
EOD-PROCESS-LEVEL→DPT-PROCESS-LEVEL
EOD-DEPARTMENT→DPT-DEPARTMENT
EstablishmentEEOUNITRequired
EOD-COMPANY→EEO-COMPANY
EOD-ESTBLSH-NBR→EEO-ESTBLSH-NBR
PcodesPCODESRequiredWhen (EOD-LOCAT-CODE != Spaces) And (EOD-LOCAT-CODE != "ALL")
"LO"→PCO-TYPE
EOD-LOCAT-CODE→PCO-CODE
Process LevelPRSYSTEMRequiredWhen EOD-PROCESS-LEVEL != Spaces
EOD-COMPANY→PRS-COMPANY
EOD-PROCESS-LEVEL→PRS-PROCESS-LEVEL

Programs

Updated by (5)

Referenced by (3)