DIVERSITY(SQL Table) |
Index Back |
---|---|
Diversity DataDiversity 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 |