HRS_BIP_AEQS_VW

(SQL View)
 Index Back

Job Opening Questions

Defines the questions associated to the screening levels defined for a Job Opening

( SELECT A.HRS_JOB_OPENING_ID , A.HRS_JO_RQMT_SEQ ,LVL.HRS_SCREENING_ID , TBL.DESCR , A.HRS_QSTN_ID , B.DESCRLONG , B.HRS_OPN_ENDED_QSTN , A.HRS_QSTN_ORDER_NBR , B.HRS_QUES_TYPE , 'EMP' FROM PS_HRS_JO_EMP_QSTN A , PS_HRS_QSTN_TBL B , PS_HRS_JO_SCR_SUMM SUMM , PS_HRS_JO_SCR_LVL LVL , PS_HRS_JO_SCR_QSTN SCR_QST , PS_HRS_SCREEN_TBL TBL WHERE A.HRS_QSTN_ID=B.HRS_QSTN_ID AND A.HRS_JOB_OPENING_ID = SUMM.HRS_JOB_OPENING_ID AND A.HRS_JO_RQMT_SEQ =SUMM.HRS_JO_RQMT_SEQ AND SCR_QST.HRS_QSTN_ID =B.HRS_QSTN_ID AND SUMM.HRS_JO_SCR_SUMM_ID = LVL.HRS_JO_SCR_SUMM_ID AND SCR_QST.HRS_JO_SCR_SUMM_ID = LVL.HRS_JO_SCR_SUMM_ID AND SCR_QST.HRS_JO_SCR_SEQ = LVL.HRS_JO_SCR_SEQ AND LVL.HRS_SCREENING_ID = TBL.HRS_SCREENING_ID AND (TBL.HRS_PRE_APP_SCR <> 'Y' AND TBL.HRS_SCR_AFT_SUB <> 'Y') ) UNION ALL ( SELECT A.HRS_JOB_OPENING_ID , A.HRS_JO_RQMT_SEQ ,999999999999998 ,COALESCE(E.MESSAGE_TEXT ,'Online Screening') , A.HRS_QSTN_ID , B.DESCRLONG , B.HRS_OPN_ENDED_QSTN ,A.HRS_QSTN_ORDER_NBR , B.HRS_QUES_TYPE , 'EMP' FROM PS_HRS_JO_EMP_QSTN A , PS_HRS_QSTN_TBL B , PS_HRS_JO_SCR_SUMM SUMM , PS_HRS_JO_SCR_LVL LVL , PS_HRS_JO_SCR_QSTN SCR_QST , PS_HRS_SCREEN_TBL TBL LEFT OUTER JOIN PSMSGCATDEFN E ON 1=1 AND E.MESSAGE_SET_NBR=18178 AND E.MESSAGE_NBR=1333 WHERE A.HRS_QSTN_ID=B.HRS_QSTN_ID AND A.HRS_JOB_OPENING_ID = SUMM.HRS_JOB_OPENING_ID AND A.HRS_JO_RQMT_SEQ =SUMM.HRS_JO_RQMT_SEQ AND SCR_QST.HRS_QSTN_ID =B.HRS_QSTN_ID AND SUMM.HRS_JO_SCR_SUMM_ID = LVL.HRS_JO_SCR_SUMM_ID AND SCR_QST.HRS_JO_SCR_SUMM_ID = LVL.HRS_JO_SCR_SUMM_ID AND SCR_QST.HRS_JO_SCR_SEQ = LVL.HRS_JO_SCR_SEQ AND LVL.HRS_SCREENING_ID = TBL.HRS_SCREENING_ID AND (TBL.HRS_PRE_APP_SCR = 'N' AND TBL.HRS_SCR_AFT_SUB = 'Y') ) UNION ALL ( SELECT A.HRS_JOB_OPENING_ID , A.HRS_JO_RQMT_SEQ ,999999999999997 ,COALESCE(E.MESSAGE_TEXT ,'Pre Screening') , A.HRS_QSTN_ID , B.DESCRLONG , B.HRS_OPN_ENDED_QSTN ,A.HRS_QSTN_ORDER_NBR , B.HRS_QUES_TYPE , 'EMP' FROM PS_HRS_JO_EMP_QSTN A , PS_HRS_QSTN_TBL B , PS_HRS_JO_SCR_SUMM SUMM , PS_HRS_JO_SCR_LVL LVL , PS_HRS_JO_SCR_QSTN SCR_QST , PS_HRS_SCREEN_TBL TBL LEFT OUTER JOIN PSMSGCATDEFN E ON 1=1 AND E.MESSAGE_SET_NBR=18178 AND E.MESSAGE_NBR=1332 WHERE A.HRS_QSTN_ID=B.HRS_QSTN_ID AND A.HRS_JOB_OPENING_ID = SUMM.HRS_JOB_OPENING_ID AND A.HRS_JO_RQMT_SEQ =SUMM.HRS_JO_RQMT_SEQ AND SCR_QST.HRS_QSTN_ID =B.HRS_QSTN_ID AND SUMM.HRS_JO_SCR_SUMM_ID = LVL.HRS_JO_SCR_SUMM_ID AND SCR_QST.HRS_JO_SCR_SUMM_ID = LVL.HRS_JO_SCR_SUMM_ID AND SCR_QST.HRS_JO_SCR_SEQ = LVL.HRS_JO_SCR_SEQ AND LVL.HRS_SCREENING_ID = TBL.HRS_SCREENING_ID AND (TBL.HRS_PRE_APP_SCR = 'Y' AND TBL.HRS_SCR_AFT_SUB = 'N') ) UNION ALL ( SELECT A.HRS_JOB_OPENING_ID , A.HRS_JO_RQMT_SEQ ,999999999999999 ,COALESCE(E.MESSAGE_TEXT ,'Additional Questions') , A.HRS_QSTN_ID , B.DESCRLONG , B.HRS_OPN_ENDED_QSTN ,A.HRS_QSTN_ORDER_NBR , B.HRS_QUES_TYPE , 'EMP' FROM PS_HRS_JO_EMP_QSTN A , PS_HRS_QSTN_TBL B , PS_HRS_JO_SCR_SUMM SUMM LEFT OUTER JOIN PSMSGCATDEFN E ON 1=1 AND E.MESSAGE_SET_NBR=18178 AND E.MESSAGE_NBR=1334 WHERE A.HRS_QSTN_ID=B.HRS_QSTN_ID AND A.HRS_JOB_OPENING_ID = SUMM.HRS_JOB_OPENING_ID AND A.HRS_JO_RQMT_SEQ =SUMM.HRS_JO_RQMT_SEQ AND NOT EXISTS ( SELECT SCR_QST.HRS_QSTN_ID , SUMM.HRS_JO_SCR_SUMM_ID FROM PS_HRS_JO_SCR_QSTN SCR_QST WHERE SCR_QST.HRS_JO_SCR_SUMM_ID = SUMM.HRS_JO_SCR_SUMM_ID AND SCR_QST.HRS_QSTN_ID=B.HRS_QSTN_ID ) )

# 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
2 HRS_JO_RQMT_SEQ Number(3,0) SMALLINT NOT NULL Job opening requirement sequence
3 HRS_SCREENING_ID Number(15,0) DECIMAL(15) NOT NULL Screening ID
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 HRS_QSTN_ID Number(15,0) DECIMAL(15) NOT NULL Question ID
6 DESCRLONG Long Character CLOB Long Description
7 HRS_OPN_ENDED_QSTN Character(1) VARCHAR2(1) NOT NULL Open Ended Questions
8 HRS_QSTN_ORDER_NBR Number(3,0) SMALLINT NOT NULL Question ID
9 HRS_QUES_TYPE Character(1) VARCHAR2(1) NOT NULL Question Type
D=Date
M=Multiple Choice
N=Numeric
O=Open Ended
S=Single Choice
10 HRS_QSTNR_TYPE Character(3) VARCHAR2(3) NOT NULL Questionnaire Type
EMP=Employment Questions
SKL=Skills Questions