PAAEEORACE

UPDATED BY
PA31.1 PA531

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


PAAEEORACE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AEOSET1 COMPANY
APPLICANT
RACE
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: Wed Jun 08 20:50:22 2016

Home
Contact Us



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