HRS_ETHNC_NNS_I

(SQL View)
 Index Back

Ethnic Group Table

This table contains all Ethnic Groups used in Asia Pacific and USA regulatory regions excluding the value 'Not Specified'

SELECT A.SETID , A.ETHNIC_GRP_CD , A.EFFDT , A.EFF_STATUS , A.DESCR50 , A.DESCRSHORT , A.ETHNIC_CATEGORY , A.ETHNIC_GROUP FROM PS_HCR_ETHNC_GRP_I A WHERE A.ETHNIC_GRP_CD <> 'NSPEC'

  • Related Language Record: HRS_ETH_GRP_LNI

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_HR.SETID

    Prompt Table: SET_VLD_HR_11

    2 ETHNIC_GRP_CD Character(8) VARCHAR2(8) NOT NULL Ethnic group code
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 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
    8 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