PAAEEORACE – Personnel Applicant Equal Employment Opportunity Race
- System
- Personnel (PA)
- Prefix
AEO- Primary key
COMPANY,APPLICANT,RACE- Fields
- 5
- Updated by
- 8 programs
- Referenced by
- 3 programs
PAAEEORACE is the Personnel Applicant Equal Employment Opportunity Race table in Lawson Personnel (prefix AEO). It is indexed by COMPANY, APPLICANT, RACE (AEOSET1); alternate indexes: AEOSET2. It is related 1:1 to APPLICANT and 1:M to HRCTRYCODE. It is updated by LT101, LT111, PA100, PA120, PA28.1, PA31.1, PA52.4 and PA531 and referenced by HR170, HR70.1 and PA228. The table has 5 fields, 2 indexes and 2 documented relations.
About PAAEEORACE
Personnel Applicant Equal Employment Opportunity Race
Fields (5)
Column = COBOL field name without the AEO- 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 / column | Type | Description & values | Updated by |
|---|---|---|---|
#AEO-COMPANY PKCOMPANY | Numeric 4 | — | LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531 |
#AEO-APPLICANT PKAPPLICANT | Numeric 9 | — | LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531 |
#AEO-RACE PKRACE | Alpha 4 (Lower Case) | — | LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531 |
#AEO-UPDATE-DATEUPDATE_DATE | Numeric 8 (yyyymmdd) | — | LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531 |
#AEO-UPDATE-USER-IDUPDATE_USER_ID | Alpha 10 (Lower Case) | — | LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531 |
Indexes (2)
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
AEOSET1 |
| Primary | HR170, HR70.1, LT101, LT111, PA100, PA120, PA228, PA28.1 +3 more | |
AEOSET2 |
| — |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Applicant | APPLICANT | Required |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Ethnicity | HRCTRYCODE |
|
Programs
Updated by (8)
- LT101 HRM Receiver Update
- LT111 HRM Receiver Update
- PA100 Action Update
- PA120 Applicant Purge
- PA28.1 Applicant Ethnicity
- PA31.1 Applicant
- PA52.4 Hire an Applicant
- PA531 Applicant Conversion