SAD_CRM_FLT_DIV

(SQL View)
Index Back

Mapping for DIVERSITY

Mapping for DIVERSITY.

SELECT EMPLID , WAIVE_DATA_PROTECT , CAN_ABORIGINAL , CAN_VISBL_MINORITY , ETHNIC_GROUP FROM PS_SCC_DIVERS_VW WHERE EMPLID IN ( SELECT EMPLID FROM PS_SAD_CRM_EMPLIDS)

# 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.
3 CAN_ABORIGINAL Character(1) VARCHAR2(1) NOT NULL Aboriginal Person
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
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