HRS_APP_DIV_ETH

(SQL Table)
 Index Back

Ethnic Diversity - Asia Pac

This table holds details of an applicant's ethnic background. Created as a child of DIVERSIT record to allow recording of multiple Ethnic Group codes for each applicant.

  • Parent record: HRS_APP_DIV_REL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    2 HRS_REG_REGION Character(5) VARCHAR2(5) NOT NULL Reg Region

    Default Value: OPR_DEF_TBL_HR.REG_REGION

    Prompt Table: HRS_REG_REGN_I

    3 HRS_ETHNIC_GRP_CD Character(8) VARCHAR2(8) NOT NULL Ethnic group code

    Prompt Table: %EDITTABLE

    4 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
    5 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    6 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    7 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    8 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    9 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id
    10 PRIMARY_INDICATOR Character(1) VARCHAR2(1) NOT NULL Primary Indicator

    Y/N Table Edit

    Default Value: N