ETHNIC_GRP_TBL

(SQL Table)
 Index Back

Ethnic Group Table

This table contains all Ethnic Groups used in Asia Pacific and USA regulatory regions.

  • Related Language Record: ETHNIC_GRP_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
    2 ETHNIC_GRP_CD Character(8) VARCHAR2(8) NOT NULL This field stores the ethnic group code of an individual.
    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 is being used in PersonBasicSync for HCM/CRM EIP.
    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