SUPERVISOR_IDHRRC_TEAM_VW6(SQL View) |
Index Back |
|---|---|
Team Received RecognitionsAccess Type = 6 |
| 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_VISIBILITY IN ('A','M') 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. |