HRS_PG_JO_SEC_I

(SQL View)
 Index Back

JO Security View for Pivots

This is the security view used for pivots in Recruiting Manager Summary pagelets

SELECT JO.HRS_JOB_OPENING_ID , TM.EMPLID , SEC.SUPERVISOR_ID , OPR.OPRID , (CASE WHEN JO.STATUS_CODE = ( SELECT B1.STATUS_CODE FROM PS_HRS_STS_TBL B1 WHERE B1.STATUS_AREA = '1' AND B1.OPEN_STS_IND = 'Y') THEN 'O' ELSE 'C' END) FROM PS_HRS_JOB_OPENING JO , PS_HRS_JO_TEAM TM , PS_HRS_EMPL_SEC_I SEC , PSOPRDEFN OPR WHERE TM.HRS_JOB_OPENING_ID = JO.HRS_JOB_OPENING_ID AND TM.HRS_JO_TM_TYPE = 'R' AND TM.HRS_JO_TM_PRIMARY = 'Y' AND JO.STATUS_CODE IN ( SELECT B.STATUS_CODE FROM PS_HRS_STS_TBL B WHERE B.STATUS_AREA = '1' AND (B.OPEN_STS_IND = 'Y' OR B.COMPLETE_STS_IND = 'Y')) AND TM.EMPLID = SEC.EMPLID AND SEC.ACCESS_TYPE = ( SELECT ATYPE.ACCESS_TYPE FROM PS_SS_LINK_TBL ATYPE WHERE ATYPE.PNLGRPNAME = 'HRS_PE_MGR_SUMM' AND ATYPE.MARKET = 'GBL') AND OPR.EMPLID = SEC.SUPERVISOR_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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID
4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
5 OPEN_STATUS Character(1) VARCHAR2(1) NOT NULL Open Flag