HRRC_PEERS_VW

(SQL View)
 Index Back

Peers with Recognitions


SELECT DISTINCT A.RC_RECOG_ID ,DR1.EMPLID , DR2.EMPLID , DR2.EMPL_RCD , A.RC_VISIBILITY ,A.RC_RECOG_HIDDEN , P.NAME_DISPLAY , P.NAME_DISPLAY_SRCH FROM PS_HRRC_RECOG_HDR A , PS_HRRC_RECOG_RECP B , PS_HRRC_RECOG_JOB C , PS_HR_DIRECT_REP_2 DR1 , PS_HR_DIRECT_REP_2 DR2 , 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 DR1.HR_DR_LEVEL=1 AND DR2.SUPERVISOR_ID = DR1.SUPERVISOR_ID AND DR2.HR_DR_LEVEL=1 AND B.RC_RECOG_ID = A.RC_RECOG_ID AND C.RC_RECOG_ID = B.RC_RECOG_ID AND C.RC_EMPLID_RECEIVED = DR2.EMPLID AND C.EMPL_RCD = DR2.EMPL_RCD AND DR2.EMPLID = P.EMPLID UNION SELECT DISTINCT A.RC_RECOG_ID ,DR1.EMPLID , DR2.EMPLID , DR2.EMPL_RCD , A.RC_VISIBILITY ,A.RC_RECOG_HIDDEN , P.NAME_DISPLAY , P.NAME_DISPLAY_SRCH FROM PS_HRRC_RECOG_HDR A , PS_HRRC_RECOG_RECP B , PS_HRRC_RECOG_JOB C , PS_HR_DIRECT_REP_3 DR1 , PS_HR_DIRECT_REP_3 DR2 , 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 DR1.HR_DR_LEVEL=1 AND DR2.SUPERVISOR_ID = DR1.SUPERVISOR_ID AND DR2.HR_DR_LEVEL=1 AND B.RC_RECOG_ID = A.RC_RECOG_ID AND C.RC_RECOG_ID = B.RC_RECOG_ID AND C.RC_EMPLID_RECEIVED = DR2.EMPLID AND C.EMPL_RCD = DR2.EMPL_RCD AND DR2.EMPLID = P.EMPLID UNION SELECT DISTINCT A.RC_RECOG_ID ,DR1.EMPLID , DR2.EMPLID , DR2.EMPL_RCD , A.RC_VISIBILITY ,A.RC_RECOG_HIDDEN , P.NAME_DISPLAY , P.NAME_DISPLAY_SRCH FROM PS_HRRC_RECOG_HDR A , PS_HRRC_RECOG_RECP B , PS_HRRC_RECOG_JOB C , PS_HR_DIRECT_REP_4 DR1 , PS_HR_DIRECT_REP_4 DR2 , 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 DR1.HR_DR_LEVEL=1 AND DR2.SUPERVISOR_ID = DR1.SUPERVISOR_ID AND DR2.SUPERVIS_EMPL_RCD = DR1.SUPERVIS_EMPL_RCD AND DR2.HR_DR_LEVEL=1 AND B.RC_RECOG_ID = A.RC_RECOG_ID AND C.RC_RECOG_ID = B.RC_RECOG_ID AND C.RC_EMPLID_RECEIVED = DR2.EMPLID AND C.EMPL_RCD = DR2.EMPL_RCD AND DR2.EMPLID = P.EMPLID UNION SELECT DISTINCT A.RC_RECOG_ID ,DR1.EMPLID , DR2.EMPLID , DR2.EMPL_RCD , A.RC_VISIBILITY ,A.RC_RECOG_HIDDEN , P.NAME_DISPLAY , P.NAME_DISPLAY_SRCH FROM PS_HRRC_RECOG_HDR A , PS_HRRC_RECOG_RECP B , PS_HRRC_RECOG_JOB C , PS_HR_DIRECT_REP_5 DR1 , PS_HR_DIRECT_REP_5 DR2 , 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 DR1.HR_DR_LEVEL=1 AND DR2.SUPERVISOR_ID = DR1.SUPERVISOR_ID AND DR2.SUPERVIS_EMPL_RCD = DR1.SUPERVIS_EMPL_RCD AND DR2.HR_DR_LEVEL=1 AND B.RC_RECOG_ID = A.RC_RECOG_ID AND C.RC_RECOG_ID = B.RC_RECOG_ID AND C.RC_EMPLID_RECEIVED = DR2.EMPLID AND C.EMPL_RCD = DR2.EMPL_RCD AND DR2.EMPLID = P.EMPLID UNION SELECT DISTINCT A.RC_RECOG_ID ,DR1.EMPLID , DR2.EMPLID , DR2.EMPL_RCD , A.RC_VISIBILITY ,A.RC_RECOG_HIDDEN , P.NAME_DISPLAY , P.NAME_DISPLAY_SRCH FROM PS_HRRC_RECOG_HDR A , PS_HRRC_RECOG_RECP B , PS_HRRC_RECOG_JOB C , PS_HR_DIRECT_REP_6 DR1 , PS_HR_DIRECT_REP_6 DR2 , 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 DR1.HR_DR_LEVEL=1 AND DR2.SUPERVISOR_ID = DR1.SUPERVISOR_ID AND DR2.SUPERVIS_EMPL_RCD = DR1.SUPERVIS_EMPL_RCD AND DR2.HR_DR_LEVEL=1 AND B.RC_RECOG_ID = A.RC_RECOG_ID AND C.RC_RECOG_ID = B.RC_RECOG_ID AND C.RC_EMPLID_RECEIVED = DR2.EMPLID AND C.EMPL_RCD = DR2.EMPL_RCD AND DR2.EMPLID = P.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RC_RECOG_ID Number(8,0) INTEGER NOT NULL Recognition ID
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPLID2 Character(11) VARCHAR2(11) NOT NULL Field is referenced in state record used by Cobra Upgrade.
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
5 RC_VISIBILITY Character(1) VARCHAR2(1) NOT NULL Visibility
A=Everyone
E=Employee
M=Employee and Manager
6 RC_RECOG_HIDDEN Character(1) VARCHAR2(1) NOT NULL Recognition Hidden
7 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
8 NAME_DISPLAY_SRCH Character(50) VARCHAR2(50) NOT NULL Uppercase version of Name to improve performance on searches.