REPORTS_TOTL_RPTS_TO_VW(SQL View) |
Index Back |
|---|---|
Search Vw - T&L Empl DataSearch Vw - T&L Empl Data. EMPLID is the only search key. |
| SELECT DISTINCT A.REPORTS_TO FROM PS_JOB A WHERE A.REPORTS_TO <> ' ' AND A.EFFDT = ( SELECT MAX(Z.EFFDT) FROM PS_JOB Z WHERE A.EMPLID = Z.EMPLID AND A.EMPL_RCD = Z.EMPL_RCD AND Z.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(Z1.EFFSEQ) FROM PS_JOB Z1 WHERE A.EMPLID = Z1.EMPLID AND A.EMPL_RCD = Z1.EMPL_RCD AND Z1.EFFDT = A.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REPORTS_TO |
Character(8) | VARCHAR2(8) NOT NULL | Reports To Position Number |