HRS_JOQ_APPL_VW

(SQL View)
 Index Back

Job Opening Quest with appl

Job Openings with Screening Questions and associated applicants

SELECT RCMT.HRS_PERSON_ID , RCMT.HRS_RCMNT_ID , RCMT.HRS_JOB_OPENING_ID , QSTJ.HRS_JO_RQMT_SEQ , QSTJ.HRS_QSTN_ID , RCMT.HRS_PROFILE_SEQ FROM PS_HRS_RCMNT_I RCMT , PS_HRS_JO_QSTN QSTJ , PS_HRS_QSTN_I QST WHERE RCMT.HRS_JOB_OPENING_ID = QSTJ.HRS_JOB_OPENING_ID AND QSTJ.HRS_QSTN_ID = QST.HRS_QSTN_ID AND QST.HRS_OPN_ENDED_QSTN = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
2 HRS_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID
3 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone

Prompt Table: HRS_JOB_OPENING

4 HRS_JO_RQMT_SEQ Number(3,0) SMALLINT NOT NULL Job opening requirement sequence

Prompt Table: HRS_JO_RQMT

5 HRS_QSTN_ID Number(15,0) DECIMAL(15) NOT NULL Question ID

Prompt Table: HRS_QSTN_TBL_VW

6 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece

Prompt Table: HRS_APP_PROF_I