DIR_REPORTS_VW8(SQL View) |
Index Back |
|---|---|
Direct Reports View 8Direct Reports View for access types "5" (Partial Position Management by Supervisor Id) and "6" (Partial Position Management by Manager Id.) These access types requires two passes to load direct reports, so this view works in conjunction with DIR_REPRTS_VW8B and DIR_REPORTS_VW6, respectively. |
| SELECT A.EMPLID , A.EFFDT , A.EFFSEQ , A.EMPL_RCD , A.POSITION_NBR , A.REPORTS_TO , B.NAME , B.LAST_NAME , B.FIRST_NAME FROM PS_JOB A , PS_PERSON_NAME B WHERE A.EMPLID = B.EMPLID AND A.EMPL_STATUS IN ('A', 'L', 'P', 'W') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 4 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 5 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 6 | REPORTS_TO | Character(8) | VARCHAR2(8) NOT NULL | Reports To Position Number |
| 7 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 8 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 9 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |