HRS_JO_EANS_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 EMPA.HRS_JOB_OPENING_ID , EMPA.HRS_JO_RQMT_SEQ , EMPA.HRS_QSTN_ID , EMPA.HRS_ANSWER_ID , QA.HRS_ANS_ORDER_NUM , EMPA.CORRECT_ANSWER , %subrec(HRS_AUDIT_SBR, EMPA) FROM PS_HRS_JO_EMP_ANS EMPA ,PS_HRS_QSTN_ANS QA WHERE EMPA.HRS_QSTN_ID =QA.HRS_QSTN_ID AND EMPA.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 HRS_ANS_ORDER_NUM Number(3,0) SMALLINT NOT NULL Answer Order
    6 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.
    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