HRS_HIRE_AP_DIV

(SQL View)
Index Back

Diversity Data

Diversity Data

SELECT A.HRS_PERSON_ID ,A.WAIVE_DATA_PROTECT ,%subrec(DIVERS_CAN_SBR,A) ,%subrec(DIVERS_NLD_SBR,A) ,%subrec(HRS_DIV_UK_SBR,A) ,%subrec(DIVERS_USA_SBR,A) ,INFO_RCVD_DT FROM PS_HRS_APP_DIV A

  • Parent record: HRS_APPLICANT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person 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

    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 This field holds the birth country of the employee, tracked as part of the employee diversity data.

    Prompt Table: COUNTRY_TBL

    6 BIRTHCNTRYMOT_NLD Character(3) VARCHAR2(3) NOT NULL This field holds the birth country of the employees mother, tracked as part of the employee diversity data.

    Default Value: NLD

    Prompt Table: COUNTRY_TBL

    7 BIRTHCNTRYFAT_NLD Character(3) VARCHAR2(3) NOT NULL This field holds the birth country of the employees father, tracked as part of the employee diversity data.

    Default Value: NLD

    Prompt Table: COUNTRY_TBL

    8 SAMEN_OBJECT_NLD Character(1) VARCHAR2(1) NOT NULL This field indicates whether the employee objects to the registration of the birth country information as part of the diversity data.

    Y/N Table Edit

    Default Value: N

    9 SAMEN_CATEGORY_NLD Character(1) VARCHAR2(1) NOT NULL This field can be used to track a specific category in case a person was born in Indonesia.
    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 This field can be used to track a specific category in case a person was born in Indonesia.

    Default Value: 1

    Prompt Table: SAMEN_CATNLD_VW

    11 SAMEN_CAT_FAT_NLD Character(1) VARCHAR2(1) NOT NULL This field can be used to track a specific category in case a person was born in Indonesia.

    Default Value: 1

    Prompt Table: SAMEN_CATNLD_VW

    12 SAMEN_IDENT_NLD Character(1) VARCHAR2(1) NOT NULL This field indicates whether the employee belongs to a minority group based on the birthcountry.

    Y/N Table Edit

    Default Value: N

    13 ETHNIC_GRP_CD_UK Character(1) VARCHAR2(1) NOT NULL ETHNIC_GRP_CD_UK
    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
    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
    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 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

    Default Value: 6

    18 INFO_RCVD_DT Date(10) DATE Information Recieved Date