HR_OBD_MGR_SEC

(SQL View)
 Index Back

OnBoarding Managers

Security view for OnBoarding 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='HR_OBD_STATUS_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='HR_OBD_STATUS_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='HR_OBD_STATUS_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='HR_OBD_STATUS_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='HR_OBD_STATUS_FL') AND DRILL_DOWN_FLAG = 'Y'

# 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 HR_OBD_SRCH_MGR_ID Character(11) VARCHAR2(11) NOT NULL Manager Id
4 HR_OBD_SRCH_NAME Character(50) VARCHAR2(50) NOT NULL Manager All Reports