SCC_DIVERS_VW (SQL View)	Index Back
Ethnic Group Primary View HR Core Rules. USA controlled Reg Regions require one and only one Primary Ethnic Group. This view will search for that DIVERS_ETHNIC record for a Person.

SCC_DIVERS_VW

(SQL View)

Ethnic Group Primary View

HR Core Rules. USA controlled Reg Regions require one and only one Primary Ethnic Group. This view will search for that DIVERS_ETHNIC record for a Person.

SELECT A.EMPLID ,C.WAIVE_DATA_PROTECT , C.CAN_ABORIGINAL , C.CAN_VISBL_MINORITY , B.ETHNIC_GROUP FROM PS_HCR_DIV_ETHNC_I A , PS_HCR_ETHNC_GRP_I B ,PS_DIVERSITY C WHERE A.SETID = B.SETID AND A.ETHNIC_GRP_CD = B.ETHNIC_GRP_CD AND A.PRIMARY_INDICATOR='Y' AND A.EMPLID = C.EMPLID AND %EffdtCheck( HCR_ETHNC_GRP_I B1, B, %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 WAIVE_DATA_PROTECT Character(1) VARCHAR2(1) NOT NULL Protecting Employee Personal Data Privacy European Community employment and personal privacy legislation specifies that personnel information cannot be passed across countries in the European Union without authorization from the employee. If you have obtained the employee's consent in compliance with this EU legislation, check Waive Data Protection to indicate that the employee's personal data can be shared with users in other European Union member nations.
Y/N Table Edit
Default Value: N

3 CAN_ABORIGINAL Character(1) VARCHAR2(1) NOT NULL Aboriginal Person
Y/N Table Edit
Default Value: N

4 CAN_VISBL_MINORITY Character(1) VARCHAR2(1) NOT NULL Visible Minority
B=Black
C=Chinese
F=Filipino
I=Indo-Pakistani
J=Japanese
K=Korean
N=Not a Visible Minority
O=Other
S=Southeast Asian
W=West Asian, Arab
Default Value: N

5 ETHNIC_GROUP Character(1) VARCHAR2(1) NOT NULL Ethnic Group
1=White
2=Black/African American
3=Hispanic/Latino
4=Asian
5=American Indian/Alaska Native
6=Not Specified
7=Native Hawaiian/Oth Pac Island
A=American Indian/Alaskan Native
B=Asian or Pacific Islander
C=Black, not of Hispanic origin
D=Hispanic
E=White, not of Hispanic origin
F=Asian Indian
G=Chinese
H=Filipino
J=Guamanian
K=Hawaiian
L=Japanese
M=Korean
N=Samoan
P=Vietnamese
Q=All Other Asian o Pacific Is
Y=Not Hispanic in Puerto Rico

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	WAIVE_DATA_PROTECT	Character(1)	VARCHAR2(1) NOT NULL	Protecting Employee Personal Data Privacy European Community employment and personal privacy legislation specifies that personnel information cannot be passed across countries in the European Union without authorization from the employee. If you have obtained the employee's consent in compliance with this EU legislation, check Waive Data Protection to indicate that the employee's personal data can be shared with users in other European Union member nations. Y/N Table Edit Default Value: N
3	CAN_ABORIGINAL	Character(1)	VARCHAR2(1) NOT NULL	Aboriginal Person Y/N Table Edit Default Value: N
4	CAN_VISBL_MINORITY	Character(1)	VARCHAR2(1) NOT NULL	Visible Minority B=Black C=Chinese F=Filipino I=Indo-Pakistani J=Japanese K=Korean N=Not a Visible Minority O=Other S=Southeast Asian W=West Asian, Arab Default Value: N
5	ETHNIC_GROUP	Character(1)	VARCHAR2(1) NOT NULL	Ethnic Group 1=White 2=Black/African American 3=Hispanic/Latino 4=Asian 5=American Indian/Alaska Native 6=Not Specified 7=Native Hawaiian/Oth Pac Island A=American Indian/Alaskan Native B=Asian or Pacific Islander C=Black, not of Hispanic origin D=Hispanic E=White, not of Hispanic origin F=Asian Indian G=Chinese H=Filipino J=Guamanian K=Hawaiian L=Japanese M=Korean N=Samoan P=Vietnamese Q=All Other Asian o Pacific Is Y=Not Hispanic in Puerto Rico