PAEEEORACE – Personnel Administration Equal Opportunity Race
- System
- Personnel (PA)
- Prefix
EER- Primary key
COMPANY,EMPLOYEE,RACE- Fields
- 5
- Updated by
- 32 programs
- Referenced by
- 6 programs
PAEEEORACE is the Personnel Administration Equal Opportunity Race table in Lawson Personnel (prefix EER). It is indexed by COMPANY, EMPLOYEE, RACE (EERSET1); alternate indexes: EERSET2. It is related 1:1 to EMPLOYEE, HRCTRYCODE and PAEMPLOYEE. It is updated by BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 and 24 more and referenced by HR170, HR228, HR70.1, PA391, PA392 and PA495. The table has 5 fields, 2 indexes and 3 documented relations.
About PAEEEORACE
Personnel Administration Equal Opportunity Race
Fields (5)
Column = COBOL field name without the EER- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
EER-COMPANY PKCOMPANY | Numeric 4 | — | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
EER-EMPLOYEE PKEMPLOYEE | Numeric 9 | — | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
EER-RACE PKRACE | Alpha 4 (Lower Case) | — | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
EER-UPDATE-DATEUPDATE_DATE | Numeric 8 (yyyymmdd) | — | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
EER-UPDATE-USER-IDUPDATE_USER_ID | Alpha 10 (Lower Case) | — | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
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 |
|---|---|---|---|---|
EERSET1 | COMPANY, EMPLOYEE, RACE | Primary | BN305, HR11.1, HR11.2, HR11.4, HR170, HR228, HR28.1, HR511 +22 more (list truncated in source) | |
EERSET2 | RACE, COMPANY, EMPLOYEE | — |
Relations
One to one (3) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Employee | EMPLOYEE | Required | EER-COMPANY → EMP-COMPANY (EMPSET1), EER-EMPLOYEE → EMP-EMPLOYEE | |
| Ethnicity | HRCTRYCODE | Not Required | "ET" → CTC-TYPE, EMP-WORK-COUNTRY → CTC-COUNTRY-CODE, EER-RACE → CTC-HRCTRY-CODE | |
| Paemployee | PAEMPLOYEE | Required | EER-COMPANY → PEM-COMPANY, EER-EMPLOYEE → PEM-EMPLOYEE |
Programs
Updated by (32)
- BN305 Highly Compensated Employees
- HR11.1 Employee
- HR11.2 Compensation Analysis
- HR11.4 Employee Assignment Inquiry
- HR28.1 Employee Ethnicity
- HR511 Employee Conversion
- LT101 HRM Receiver Update
- LT111 HRM Receiver Update
- PA02.1 Position
- PA100 Action Update
- PA102 Position Update
- PA115 Employee Purge
- PA13.1 Multiple Positions and Jobs
- PA13.2 Multiple Position and Job History
- PA502 Position Conversion
- PA513 Position and Job Conversion
- PA52.1 Individual Action
- PA52.3 Mass Action
- PA52.4 Hire an Applicant
- PA52.5 Position and Job Action
- PR110 Step And Grade Audit
- PR113 United States Tax Deduction Update
- PR12.6 Employee Automatic Deposit
- PR120 Mass Pay Update
- PR13.1 Employee United States Taxes
- PR13.5 Employee Canada Taxes
- PR13.6 Employee Canada Taxes
- PR13.8 U.S. Tax Deduction Errors
- PR13.9 Employee Additional Tax Details
- PR30.2 Employee Automatic Time Record
- PR512 Employee ACH Distribution Interface
- ZH510 Update PCP from ZPENDPCP