SCC_DIVERS_QVW (SQL View)	Index Back
Diversity Query View

SCC_DIVERS_QVW

(SQL View)

Diversity Query View

SELECT A.EMPLID , A.WAIVE_DATA_PROTECT , A.CAN_ABORIGINAL , A.CAN_VISBL_MINORITY , A.BIRTHCNTRY_NLD , A.BIRTHCNTRYMOT_NLD , A.BIRTHCNTRYFAT_NLD , A.SAMEN_OBJECT_NLD , A.SAMEN_CATEGORY_NLD , A.SAMEN_CAT_MOT_NLD , A.SAMEN_CAT_FAT_NLD , A.SAMEN_IDENT_NLD , A.ETHNIC_GRP_CD_UK , A.NI_COMMUNITY_BG , A.NI_CB_DET_METHOD , A.NI_CB_DET_DATE FROM PS_DIVERSITY A

Parent Record Of SCC_DIV_ETH_QVW

# 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
1=Former Netherlands East Indies
2=Indonesia (after 27-12-1949)
3=Incl. Law Rietkerk-uitkering
Default Value: 1
Prompt Table: SAMEN_CATNLD_VW

10 SAMEN_CAT_MOT_NLD Character(1) VARCHAR2(1) NOT NULL Mothers Birth Category
Default Value: 1
Prompt Table: SAMEN_CATNLD_VW

11 SAMEN_CAT_FAT_NLD Character(1) VARCHAR2(1) NOT NULL Fathers Birth Category
Default Value: 1
Prompt Table: SAMEN_CATNLD_VW

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
0=Not Specified
1=White
2=Irish
3=African
4=Afro-Caribbean
5=Indian
6=Pakistani
7=Bangladeshi
8=Chinese
9=Other

14 NI_COMMUNITY_BG Character(2) VARCHAR2(2) NOT NULL Community Background (NI)
CA=Catholic
PR=Protestant
UD=Undetermined/Other

15 NI_CB_DET_METHOD Character(2) VARCHAR2(2) NOT NULL Determination Method
DQ=Direct Question
R1=Residual
R2=Residual 2nd School
RO=Residual Other

16 NI_CB_DET_DATE Date(10) DATE Determination Date

#	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 1=Former Netherlands East Indies 2=Indonesia (after 27-12-1949) 3=Incl. Law Rietkerk-uitkering Default Value: 1 Prompt Table: SAMEN_CATNLD_VW
10	SAMEN_CAT_MOT_NLD	Character(1)	VARCHAR2(1) NOT NULL	Mothers Birth Category Default Value: 1 Prompt Table: SAMEN_CATNLD_VW
11	SAMEN_CAT_FAT_NLD	Character(1)	VARCHAR2(1) NOT NULL	Fathers Birth Category Default Value: 1 Prompt Table: SAMEN_CATNLD_VW
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 0=Not Specified 1=White 2=Irish 3=African 4=Afro-Caribbean 5=Indian 6=Pakistani 7=Bangladeshi 8=Chinese 9=Other
14	NI_COMMUNITY_BG	Character(2)	VARCHAR2(2) NOT NULL	Community Background (NI) CA=Catholic PR=Protestant UD=Undetermined/Other
15	NI_CB_DET_METHOD	Character(2)	VARCHAR2(2) NOT NULL	Determination Method DQ=Direct Question R1=Residual R2=Residual 2nd School RO=Residual Other
16	NI_CB_DET_DATE	Date(10)	DATE	Determination Date