DIR_REPORTS_VW6

(SQL View)
Index Back

Direct Reports View 6

Direct 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