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 J.HRS_JOB_OPENING_ID , OPR.OPRID , OPR.EMPLID FROM PS_HRS_JOB_OPENING J , PSOPRDEFN OPR , PS_HRS_SJT_JO JO WHERE J.HRS_JOB_OPENING_ID = JO.HRS_JOB_OPENING_ID AND JO.EMPLID = OPR.EMPLID AND JO.EMPLID <> ' ' UNION SELECT J.HRS_JOB_OPENING_ID , OPR.OPRID , OPR.EMPLID FROM PS_HRS_JOB_OPENING J , PSOPRDEFN OPR , PS_HRS_SJT_JO JO , PS_SJT_CLASS_ALL CLS , PS_SJT_OPR_CLS RSC WHERE J.HRS_JOB_OPENING_ID = JO.HRS_JOB_OPENING_ID AND RSC.CLASSID = CLS.CLASSID AND RSC.OPRID = OPR.OPRID AND CLS.SCRTY_SET_CD = 'RSOPN' AND CLS.SCRTY_TYPE_CD = JO.SCRTY_TYPE_CD AND CLS.SCRTY_KEY1 = JO.SCRTY_KEY1 AND CLS.SCRTY_KEY2 = JO.SCRTY_KEY2 AND CLS.SCRTY_KEY3 = JO.SCRTY_KEY3 AND JO.EMPLID = ' ' AND EXISTS( SELECT 'Y' FROM PS_HRS_ROLE_DEFN A , PSROLEUSER R WHERE A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(T.EFFDT) FROM PS_HRS_ROLE_DEFN T WHERE T.HRS_ROLE_TYPE = A.HRS_ROLE_TYPE AND T.EFFDT <=%CurrentDateIn ) AND A.HRS_APPCNT_SEC = 'N' AND A.ROLENAME = R.ROLENAME AND OPR.OPRID = R.ROLEUSER ) UNION SELECT J.HRS_JOB_OPENING_ID , OPR.OPRID , OPR.EMPLID FROM PS_HRS_JOB_OPENING J , PSOPRDEFN OPR , PS_HRS_SJT_JO JO , PS_SJT_CLASS_ALL CLS , PS_SJT_OPR_CLS RSC WHERE J.HRS_JOB_OPENING_ID = JO.HRS_JOB_OPENING_ID AND RSC.CLASSID = CLS.CLASSID AND RSC.OPRID = OPR.OPRID AND CLS.SCRTY_SET_CD = 'PPLJOB' AND CLS.SCRTY_TYPE_CD = '001' AND JO.SCRTY_TYPE_CD = '012' AND CLS.SCRTY_KEY1 = JO.SCRTY_KEY1 AND CLS.SCRTY_KEY2 = JO.SCRTY_KEY2 AND CLS.SCRTY_KEY3 = JO.SCRTY_KEY3 AND JO.EMPLID = ' ' AND EXISTS ( SELECT 'Y' FROM PS_HRS_ROLE_DEFN A , PSROLEUSER R WHERE A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(T.EFFDT) FROM PS_HRS_ROLE_DEFN T WHERE T.HRS_ROLE_TYPE = A.HRS_ROLE_TYPE AND T.EFFDT <=%CurrentDateIn ) AND A.HRS_APPCNT_SEC = 'N' AND A.ROLENAME = R.ROLENAME AND OPR.OPRID = R.ROLEUSER )

# 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