HRS_JO_SCOLV_VW

(SQL View)
 Index Back

Job Opening Screening Lvl Vw

Job opening screening level view for online apply

SELECT A.HRS_JOB_OPENING_ID , A.HRS_JO_RQMT_SEQ , A.HRS_JO_SCR_SUMM_ID , B.HRS_JO_SCR_SEQ , B.HRS_SCREENING_ID , C.HRS_ONLINE_SCR_FLG , D.HRS_JO_PRM_JCD_FLG FROM PS_HRS_JO_SCR_SUMM A , PS_HRS_JO_SCR_LVL B , PS_HRS_SCREEN_TBL C , PS_HRS_JO_RQMT D WHERE A.HRS_JO_SCR_SUMM_ID = B.HRS_JO_SCR_SUMM_ID AND C.HRS_SCREENING_ID = B.HRS_SCREENING_ID AND C.HRS_ONLINE_SCR_FLG = 'Y' AND D.HRS_JOB_OPENING_ID = A.HRS_JOB_OPENING_ID AND D.HRS_JO_RQMT_SEQ = A.HRS_JO_RQMT_SEQ AND D.HRS_JO_PRM_JCD_FLG = 'Y'

# 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_JOB_OPENING

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

Prompt Table: HRS_JO_RQMT

3 HRS_JO_SCR_SUMM_ID Number(15,0) DECIMAL(15) NOT NULL JO Screening Summary ID

Prompt Table: HRS_JO_SCR_SUMM

4 HRS_JO_SCR_SEQ Number(3,0) SMALLINT NOT NULL Job opening screening sequence
5 HRS_SCREENING_ID Number(15,0) DECIMAL(15) NOT NULL Screening ID
6 HRS_ONLINE_SCR_FLG Character(1) VARCHAR2(1) NOT NULL This field determines that a Screening Level definition is to be used for Online Screening.
7 HRS_JO_PRM_JCD_FLG Character(1) VARCHAR2(1) NOT NULL Primary job code for job opening