HRS_APP_DIVET_I

(SQL View)
 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.

SELECT HRS_PERSON_ID ,HRS_REG_REGION ,HRS_ETHNIC_GRP_CD ,SETID ,%subrec(HRS_AUDIT_SBR,A) ,PRIMARY_INDICATOR FROM PS_HRS_APP_DIV_ETH A

  • 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

    3 HRS_ETHNIC_GRP_CD Character(8) VARCHAR2(8) NOT NULL Ethnic group code
    4 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    5 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    6 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    7 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    8 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id
    9 PRIMARY_INDICATOR Character(1) VARCHAR2(1) NOT NULL Primary Indicator for Multiple