HRS_CE_JO_ANS_I

(SQL View)
 Index Back

JO Answers to Scr Qstns Intfc

Candidate Experience version of job opening answers to screening question requirements interface. Used for panel processor to eliminate required fields errors.

SELECT A.HRS_JOB_OPENING_ID ,A.HRS_JO_RQMT_SEQ , A.HRS_QSTN_ID , A.HRS_ANSWER_ID , %subrec(HRS_AUDIT_SBR, A) FROM PS_HRS_JO_ANS_I A

  • Parent record: HRS_JO_SCR_QSTN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone

    Prompt Table: HRS_JO_I

    2 HRS_JO_RQMT_SEQ Number(3,0) SMALLINT NOT NULL Job opening requirement sequence
    3 HRS_QSTN_ID Number(15,0) DECIMAL(15) NOT NULL Question ID
    4 HRS_ANSWER_ID Number(15,0) DECIMAL(15) NOT NULL Answer ID

    Prompt Table: HRS_ANS_TBL

    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