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.
| 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
AEOSET1 | COMPANY, APPLICANT, RACE | Primary | HR170, HR70.1, LT101, LT111, PA100, PA120, PA228, PA28.1 +3 more | |
AEOSET2 | RACE, COMPANY, APPLICANT | — |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Applicant | APPLICANT | Required | AEO-COMPANY → APL-COMPANY (APLSET1), AEO-APPLICANT → APL-APPLICANT |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Ethnicity | HRCTRYCODE | "ET" → CTC-TYPE, AEO-RACE → CTC-HRCTRY-CODE, CTC-COUNTRY-CODE |
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