DIVERSITY

(SQL Table)
Index Back

Diversity Data

Diversity Data

# 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 BIRTHCNTRY_NLD Character(3) VARCHAR2(3) NOT NULL Birth Country

Prompt Table: COUNTRY_TBL

6 BIRTHCNTRYMOT_NLD Character(3) VARCHAR2(3) NOT NULL Mother's Birth Country

Default Value: NLD

Prompt Table: COUNTRY_TBL

7 BIRTHCNTRYFAT_NLD Character(3) VARCHAR2(3) NOT NULL Father's Birth Country

Default Value: NLD

Prompt Table: COUNTRY_TBL

8 SAMEN_OBJECT_NLD Character(1) VARCHAR2(1) NOT NULL Objection Registration

Y/N Table Edit

Default Value: N

9 SAMEN_CATEGORY_NLD Character(1) VARCHAR2(1) NOT NULL Birth Category

Default Value: 1

10 SAMEN_CAT_MOT_NLD Character(1) VARCHAR2(1) NOT NULL Mothers Birth Category

Default Value: 1

11 SAMEN_CAT_FAT_NLD Character(1) VARCHAR2(1) NOT NULL Fathers Birth Category

Default Value: 1

12 SAMEN_IDENT_NLD Character(1) VARCHAR2(1) NOT NULL Included in Target Group

Y/N Table Edit

Default Value: N

13 ETHNIC_GRP_CD_UK Character(1) VARCHAR2(1) NOT NULL Ethnic Group
14 NI_COMMUNITY_BG Character(2) VARCHAR2(2) NOT NULL Community Background (NI)
15 NI_CB_DET_METHOD Character(2) VARCHAR2(2) NOT NULL Determination Method
16 NI_CB_DET_DATE Date(10) DATE Determination Date
17 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

Default Value: 1