DIV_ETH_USA_VW

(SQL View)
 Index Back

Ethnic Diversity View USA

JOins employee's ethnic group data with USA ethnic group values.

SELECT A.EMPLID , A.REG_REGION , A.ETHNIC_GRP_CD , A.SETID , A.PRIMARY_INDICATOR , B.ETHNIC_GROUP FROM PS_DIVERS_ETHNIC A , PS_ETHNIC_GRP_TBL B WHERE B.SETID = A.SETID AND B.ETHNIC_GRP_CD = A.ETHNIC_GRP_CD AND %EffdtCheck(ETHNIC_GRP_TBL B1, B, %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

Default Value: OPR_DEF_TBL_HR.REG_REGION

Prompt Table: REG_REGION_TBL

3 ETHNIC_GRP_CD Character(8) VARCHAR2(8) NOT NULL Ethnic group code

Prompt Table: ETHNIC_GRP_TBL

4 SETID Character(5) VARCHAR2(5) NOT NULL SetID
5 PRIMARY_INDICATOR Character(1) VARCHAR2(1) NOT NULL Primary Indicator
6 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 Applicable
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