HRRC_TM_SENT_VW

(SQL View)
 Index Back

Employee Recognition Jobs


SELECT DISTINCT D.SUPERVISOR_ID , D.EMPLID , D.EMPL_RCD , D.HR_DR_LEVEL , P.NAME_DISPLAY , P.NAME_DISPLAY_SRCH FROM PS_HR_DIRECT_REP_2 D , PS_PERSON_NAME P WHERE 2 = ( SELECT CFG.ACCESS_TYPE FROM PS_HR_DR_UI_CFG CFG WHERE CFG.PNLGRPNAME='HRRC_MSS_RECOG_FL') AND D.EMPLID = P.EMPLID AND EXISTS ( SELECT 'Y' FROM PS_HRRC_RECOG_HDR A , PS_HRRC_RECOG_RECP B , PS_HRRC_RECOG_JOB C WHERE A.RC_RECOG_HIDDEN = 'N' AND A.RC_EMPLID_SENT = D.SUPERVISOR_ID AND B.RC_RECOG_ID = A.RC_RECOG_ID AND C.RC_RECOG_ID = B.RC_RECOG_ID AND C.RC_EMPLID_RECEIVED = B.RC_EMPLID_RECEIVED AND C.RC_EMPLID_RECEIVED = D.EMPLID AND C.EMPL_RCD = D.EMPL_RCD) UNION SELECT DISTINCT D.SUPERVISOR_ID , D.EMPLID , D.EMPL_RCD , D.HR_DR_LEVEL , P.NAME_DISPLAY , P.NAME_DISPLAY_SRCH FROM PS_HR_DIRECT_REP_3 D , PS_PERSON_NAME P WHERE 3 = ( SELECT CFG.ACCESS_TYPE FROM PS_HR_DR_UI_CFG CFG WHERE CFG.PNLGRPNAME='HRRC_MSS_RECOG_FL') AND D.EMPLID = P.EMPLID AND EXISTS ( SELECT 'Y' FROM PS_HRRC_RECOG_HDR A , PS_HRRC_RECOG_RECP B , PS_HRRC_RECOG_JOB C WHERE A.RC_RECOG_HIDDEN = 'N' AND A.RC_EMPLID_SENT = D.SUPERVISOR_ID AND B.RC_RECOG_ID = A.RC_RECOG_ID AND C.RC_RECOG_ID = B.RC_RECOG_ID AND C.RC_EMPLID_RECEIVED = B.RC_EMPLID_RECEIVED AND C.RC_EMPLID_RECEIVED = D.EMPLID AND C.EMPL_RCD = D.EMPL_RCD) UNION SELECT DISTINCT D.SUPERVISOR_ID , D.EMPLID , D.EMPL_RCD , D.HR_DR_LEVEL , P.NAME_DISPLAY , P.NAME_DISPLAY_SRCH FROM PS_HR_DIRECT_REP_4 D , PS_PERSON_NAME P WHERE 4 = ( SELECT CFG.ACCESS_TYPE FROM PS_HR_DR_UI_CFG CFG WHERE CFG.PNLGRPNAME='HRRC_MSS_RECOG_FL') AND D.EMPLID = P.EMPLID AND EXISTS ( SELECT 'Y' FROM PS_HRRC_RECOG_HDR A , PS_HRRC_RECOG_RECP B , PS_HRRC_RECOG_JOB C WHERE A.RC_RECOG_HIDDEN = 'N' AND A.RC_EMPLID_SENT = D.SUPERVISOR_ID AND B.RC_RECOG_ID = A.RC_RECOG_ID AND C.RC_RECOG_ID = B.RC_RECOG_ID AND C.RC_EMPLID_RECEIVED = B.RC_EMPLID_RECEIVED AND C.RC_EMPLID_RECEIVED = D.EMPLID AND C.EMPL_RCD = D.EMPL_RCD) UNION SELECT DISTINCT D.SUPERVISOR_ID , D.EMPLID , D.EMPL_RCD , D.HR_DR_LEVEL , P.NAME_DISPLAY , P.NAME_DISPLAY_SRCH FROM PS_HR_DIRECT_REP_5 D , PS_PERSON_NAME P WHERE 5 = ( SELECT CFG.ACCESS_TYPE FROM PS_HR_DR_UI_CFG CFG WHERE CFG.PNLGRPNAME='HRRC_MSS_RECOG_FL') AND D.EMPLID = P.EMPLID AND EXISTS ( SELECT 'Y' FROM PS_HRRC_RECOG_HDR A , PS_HRRC_RECOG_RECP B , PS_HRRC_RECOG_JOB C WHERE A.RC_RECOG_HIDDEN = 'N' AND A.RC_EMPLID_SENT = D.SUPERVISOR_ID AND B.RC_RECOG_ID = A.RC_RECOG_ID AND C.RC_RECOG_ID = B.RC_RECOG_ID AND C.RC_EMPLID_RECEIVED = B.RC_EMPLID_RECEIVED AND C.RC_EMPLID_RECEIVED = D.EMPLID AND C.EMPL_RCD = D.EMPL_RCD) UNION SELECT DISTINCT D.SUPERVISOR_ID , D.EMPLID , D.EMPL_RCD , D.HR_DR_LEVEL , P.NAME_DISPLAY , P.NAME_DISPLAY_SRCH FROM PS_HR_DIRECT_REP_6 D , PS_PERSON_NAME P WHERE 6 = ( SELECT CFG.ACCESS_TYPE FROM PS_HR_DR_UI_CFG CFG WHERE CFG.PNLGRPNAME='HRRC_MSS_RECOG_FL') AND D.EMPLID = P.EMPLID AND EXISTS ( SELECT 'Y' FROM PS_HRRC_RECOG_HDR A , PS_HRRC_RECOG_RECP B , PS_HRRC_RECOG_JOB C WHERE A.RC_RECOG_HIDDEN = 'N' AND A.RC_EMPLID_SENT = D.SUPERVISOR_ID AND B.RC_RECOG_ID = A.RC_RECOG_ID AND C.RC_RECOG_ID = B.RC_RECOG_ID AND C.RC_EMPLID_RECEIVED = B.RC_EMPLID_RECEIVED AND C.RC_EMPLID_RECEIVED = D.EMPLID AND C.EMPL_RCD = D.EMPL_RCD)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
4 HR_DR_LEVEL Number(3,0) SMALLINT NOT NULL Number denoting how many levels down the organizational chart the employee is from the supervisor. Direct reports are always level 1.
5 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
6 NAME_DISPLAY_SRCH Character(50) VARCHAR2(50) NOT NULL Uppercase version of Name to improve performance on searches.