HRS_DIV_ETH_HST

(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 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
    3 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    4 HRS_REG_REGION Character(5) VARCHAR2(5) NOT NULL Reg Region

    Default Value: OPR_DEF_TBL_HR.REG_REGION

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

    Y/N Table Edit

    Default Value: N