SCC_ETH_PRI_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.

SELECT A.EMPLID , A.ETHNIC_GRP_CD , A.SETID , A.PRIMARY_INDICATOR , B.ETHNIC_GROUP FROM PS_HCR_DIV_ETHNC_I A , PS_HCR_ETHNC_GRP_I B WHERE A.SETID = B.SETID AND A.ETHNIC_GRP_CD = B.ETHNIC_GRP_CD AND A.PRIMARY_INDICATOR='Y' 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 ETHNIC_GRP_CD Character(8) VARCHAR2(8) NOT NULL Ethnic group code

Prompt Table: HCR_ETHNC_GRP_I

3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
4 PRIMARY_INDICATOR Character(1) VARCHAR2(1) NOT NULL Primary Indicator for Multiple

Y/N Table Edit

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