SCC_ETH_GRP_VW

(SQL View)
 Index Back

Ethnic Diversity

Person DIVERS_ETHNIC joined with setup ETHNIC_GRP_TBL for resolution of the ETHNIC_GROUP value

SELECT A.EMPLID , A.REG_REGION , A.ETHNIC_GRP_CD , A.SETID , A.APS_EC_NDS_AUS , A.PRIMARY_INDICATOR , B.ETHNIC_GROUP , B.ETHNIC_CATEGORY , B.EFF_STATUS , B.DESCR50 , B.DESCRSHORT FROM PS_DIVERS_ETHNIC A , PS_HCR_ETHNC_GRP_I B WHERE A.SETID = B.SETID AND A.ETHNIC_GRP_CD = B.ETHNIC_GRP_CD AND %EffdtCheck( HCR_ETHNC_GRP_I B1, B, %CurrentDateIn)

  • Related Language Record: SCC_ETHGRPVW_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
    3 ETHNIC_GRP_CD Character(8) VARCHAR2(8) NOT NULL Ethnic group code

    Prompt Table: HCR_ETHNC_GRP_I

    4 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    5 APS_EC_NDS_AUS Character(1) VARCHAR2(1) NOT NULL Employees have the option of not wanting to provide their ethnicity information. This field is required for the purpose of APS reporting only.

    Y/N Table Edit

    Default Value: N

    6 PRIMARY_INDICATOR Character(1) VARCHAR2(1) NOT NULL Primary Indicator for Multiple

    Y/N Table Edit

    Default Value: N

    7 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
    8 ETHNIC_CATEGORY Character(1) VARCHAR2(1) NOT NULL Ethnic Category
    1=White
    2=Black
    3=Hispanic
    4=Asian/Pacific Islander
    5=American Indian/Alaskan Native
    6=Not Applicable
    7=Chinese
    9=Indian
    A=Aboriginal/Torres Strait Islnd
    B=Aboriginal Origin
    C=Torres Strait Islander Origin
    E=Eurasian
    I=Irianese
    M=Malay
    O=Maori
    P=Pacific Islander
    9 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    10 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    11 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description