HRS_JO_SEC_VW

(SQL View)
 Index Back

RS Job Opening Security View

This view is used by Recruiting Solutions to implement row level security for Job Openings. This view determines what Job Openings a user has access to based on the configuration present.

SELECT DISTINCT J.HRS_JOB_OPENING_ID ,OPR.OPRID ,OPR.EMPLID FROM PS_HRS_JOB_OPENING J , PSOPRDEFN OPR WHERE J.HRS_JOB_OPENING_ID IN ( SELECT JO.HRS_JOB_OPENING_ID FROM PS_HRS_SJT_JO JO WHERE (JO.EMPLID = OPR.EMPLID AND JO.EMPLID <> ' ' ) OR EXISTS ( SELECT 'X' FROM PS_SJT_CLASS_ALL CLS , PS_SJT_OPR_CLS RSC WHERE RSC.CLASSID = CLS.CLASSID AND RSC.OPRID = OPR.OPRID AND ((CLS.SCRTY_SET_CD = 'RSOPN' AND CLS.SCRTY_TYPE_CD = JO.SCRTY_TYPE_CD) OR (CLS.SCRTY_SET_CD = 'PPLJOB' AND CLS.SCRTY_TYPE_CD = '001')) AND CLS.SCRTY_KEY1 = JO.SCRTY_KEY1 AND CLS.SCRTY_KEY2 = JO.SCRTY_KEY2 AND CLS.SCRTY_KEY3 = JO.SCRTY_KEY3 AND JO.EMPLID = ' '))

# 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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID