PAEEEORACE

Personnel Administration Equal Opportunity Race

REFERENCED BY
HR170 HR228 HR70.1 PA391 PA392 PA495


UPDATED BY
BN305 HR11.1 HR11.2 HR11.4 HR28.1 HR511
LT101 LT111 ZH510 PA02.1 PA100 PA102
PA115 PA13.1 PA13.2 PA502 PA513 PA52.1
PA52.3 PA52.4 PA52.5 PR110 PR113 PR12.6
PR120 PR13.1 PR13.5 PR13.6 PR13.8 PR13.9
PR30.2 PR512

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EER-COMPANY
Element: Company		Numeric 4
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EER-EMPLOYEE
Element: Employee		Numeric 9
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EER-RACE
Element: Hrctry Code		Alpha 4 (Lower Case)
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EER-UPDATE-DATE
Element: Date Stamp		Numeric 8 (yyyymmdd)
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
EER-UPDATE-USER-ID
Element: User Id		Alpha 10 (Lower Case)
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510


PAEEEORACE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EERSET1 COMPANY
EMPLOYEE
RACE
...
BN305 HR11.1
HR11.2 HR11.4
HR170 HR228
HR28.1 HR511
HR70.1 LT101
LT111 ZH510
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA391 PA392
PA495 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
EERSET2 RACE
COMPANY
EMPLOYEE


PAEEEORACE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
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

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

Home
Contact Us



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