PAAEEORACE

Personnel Applicant Equal Employment Opportunity Race

REFERENCED BY
HR170 HR70.1 PA228


UPDATED BY
LT101 LT111 PA100 PA28.1 PA31.1 PA52.4
PA531 PA120

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AEO-COMPANY
Element: Company		Numeric 4
LT101 LT111
PA100 PA28.1
PA31.1 PA52.4
PA531
AEO-APPLICANT
Element: Applicant		Numeric 9
LT101 LT111
PA100 PA28.1
PA31.1 PA52.4
PA531
AEO-RACE
Element: Hrctry Code		Alpha 4 (Lower Case)
LT101 LT111
PA100 PA28.1
PA31.1 PA52.4
PA531
AEO-UPDATE-DATE
Element: Date Stamp		Numeric 8 (yyyymmdd)
LT101 LT111
PA100 PA28.1
PA31.1 PA52.4
PA531
AEO-UPDATE-USER-ID
Element: User Id		Alpha 10 (Lower Case)
LT101 LT111
PA100 PA28.1
PA31.1 PA52.4
PA531


PAAEEORACE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AEOSET1 COMPANY
APPLICANT
RACE
HR170 HR70.1
LT101 LT111
PA100 PA120
PA228 PA28.1
PA31.1 PA52.4
PA531
AEOSET2 RACE
COMPANY
APPLICANT


PAAEEORACE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Applicant APPLICANT Required
AEO-COMPANY->APL-COMPANY (APLSET1)
AEO-APPLICANT->APL-APPLICANT


PAAEEORACE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Ethnicity HRCTRYCODE
"ET"->CTC-TYPE
AEO-RACE->CTC-HRCTRY-CODE
  CTC-COUNTRY-CODE

File created: Thu Jun 09 02:24:51 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.