PAAEEORACE

UPDATED BY
LT101 PA120 PA228 PA28.1 PA31.1 PA531

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


PAAEEORACE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AEOSET1 COMPANY
APPLICANT
RACE
LT101 PA120
PA228 PA28.1
PA31.1 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 11:22:07 2016

Home
Contact Us



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