EP_SRCH_MGR_SEC

(SQL View)
 Index Back

ePerformance Managers

Security view for ePerformance manager index.

SELECT DISTINCT A.EMPLID , A.EMPL_RCD , A.SUPERVISOR_ID , B.NAME_DISPLAY FROM PS_HR_DIRECT_REP_2 A , PS_PERSON_NAME B WHERE B.EMPLID = A.SUPERVISOR_ID AND 2 = ( SELECT CFG.ACCESS_TYPE FROM PS_HR_DR_UI_CFG CFG WHERE CFG.PNLGRPNAME='EP_APPR_SRCH_FL') AND DRILL_DOWN_FLAG = 'Y' UNION SELECT DISTINCT A.EMPLID , A.EMPL_RCD , A.SUPERVISOR_ID , B.NAME_DISPLAY FROM PS_HR_DIRECT_REP_3 A , PS_PERSON_NAME B WHERE B.EMPLID = A.SUPERVISOR_ID AND 3 = ( SELECT CFG.ACCESS_TYPE FROM PS_HR_DR_UI_CFG CFG WHERE CFG.PNLGRPNAME='EP_APPR_SRCH_FL') AND DRILL_DOWN_FLAG = 'Y' UNION SELECT DISTINCT A.EMPLID , A.EMPL_RCD , A.SUPERVISOR_ID , B.NAME_DISPLAY FROM PS_HR_DIRECT_REP_4 A , PS_PERSON_NAME B WHERE B.EMPLID = A.SUPERVISOR_ID AND 4 = ( SELECT CFG.ACCESS_TYPE FROM PS_HR_DR_UI_CFG CFG WHERE CFG.PNLGRPNAME='EP_APPR_SRCH_FL') AND DRILL_DOWN_FLAG = 'Y' UNION SELECT DISTINCT A.EMPLID , A.EMPL_RCD , A.SUPERVISOR_ID , B.NAME_DISPLAY FROM PS_HR_DIRECT_REP_5 A , PS_PERSON_NAME B WHERE B.EMPLID = A.SUPERVISOR_ID AND 5 = ( SELECT CFG.ACCESS_TYPE FROM PS_HR_DR_UI_CFG CFG WHERE CFG.PNLGRPNAME='EP_APPR_SRCH_FL') AND DRILL_DOWN_FLAG = 'Y' UNION SELECT DISTINCT A.EMPLID , A.EMPL_RCD , A.SUPERVISOR_ID , B.NAME_DISPLAY FROM PS_HR_DIRECT_REP_6 A , PS_PERSON_NAME B WHERE B.EMPLID = A.SUPERVISOR_ID AND 6 = ( SELECT CFG.ACCESS_TYPE FROM PS_HR_DR_UI_CFG CFG WHERE CFG.PNLGRPNAME='EP_APPR_SRCH_FL') AND DRILL_DOWN_FLAG = 'Y' UNION SELECT DISTINCT A.EMPLID , A.EMPL_RCD , A.EP_MANAGER_ID , B.NAME_DISPLAY FROM PS_EP_APPR A , PS_PERSON_NAME B WHERE B.EMPLID = A.EP_MANAGER_ID AND A.EP_MANAGER_ID = ( SELECT A1.EP_MANAGER_ID FROM PS_EP_APPR A1 WHERE A1.EP_APPRAISAL_ID = A.EP_APPRAISAL_ID AND A1.EMPLID = A.EMPLID AND A1.EMPL_RCD = A.EMPL_RCD)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID
4 SUPERVISOR_NAME Character(50) VARCHAR2(50) NOT NULL Supervisor Name