DIR_REPORTS_VW6(SQL View) |
Index Back |
---|---|
Direct Reports View 6Direct Reports View for access type "6" (Partial Position Management by Manager Id.) This access type requires two passes to load direct reports, so this view works in conjunction with DIR_REPORTS_VW8. |
SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , B2.EFFDT , C.EFFDT , A.EFFSEQ , C.MANAGER_ID , B.NAME , B.LAST_NAME , B.FIRST_NAME , B2.EMPLID , C.DEPTID , C.SETID , A.SETID_DEPT FROM PS_JOB A , PS_PERSON_NAME B , PS_DEPT_TBL C , PS_PERS_DATA_EFFDT B2 WHERE A.EMPLID = B.EMPLID AND A.EMPL_STATUS IN ('A', 'L', 'P', 'W') AND B2.EMPLID = B.EMPLID AND C.DEPTID = A.DEPTID AND (A.REPORTS_TO = ' ' OR A.POSITION_OVERRIDE = 'Y') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
2 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
3 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
4 | EFFDT_OTH | Date(10) | DATE | Other Effective Date |
5 | EFFDT_DEPT | Date(10) | DATE | Dept Effective Date |
6 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
7 | MANAGER_ID | Character(11) | VARCHAR2(11) NOT NULL | Manager ID |
8 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
9 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
10 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
11 | EMPLID_TO1 | Character(11) | VARCHAR2(11) NOT NULL | Used in SS Framework |
12 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
13 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
14 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department Set ID |