HRS_DIV_REL_HST

(SQL Table)
 Index Back

Religion Diversity - Asia Pac

This table holds details of an applicant's religion. Created as a child of DIVERSITY record to allow recording of multiple Religion codes in different Reg Regions.

  • Parent record: HRS_APP_DIV

    • # 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 RELIGION_CD Character(3) VARCHAR2(3) NOT NULL Religion Code

    Prompt Table: RELIGION_TBL

    6 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    7 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    8 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    9 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    10 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id