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 JOA.HRS_JOB_OPENING_ID , JOA.HRS_JO_RQMT_SEQ , JOA.HRS_QSTN_ID , JOA.HRS_ANSWER_ID , QA.CORRECT_ANSWER , %subrec(HRS_AUDIT_SBR, JOA) FROM PS_HRS_JO_ANS_I JOA , PS_HRS_QSTN_ANS_I QA WHERE JOA.HRS_QSTN_ID = QA.HRS_QSTN_ID AND JOA.HRS_ANSWER_ID = QA.HRS_ANSWER_ID

  • 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 CORRECT_ANSWER Character(1) VARCHAR2(1) NOT NULL Indicates which answer in a set associated to a question is the correct answer and is also used to indicate which answer an applicant has provided to a question. Used in the online questionairre transaction as part of the apply online process.
    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