DIR_REPRTS_VW8B

(SQL View)
 Index Back

Direct Reports View 8B

Direct Reports View for access type "5" (Partial Position Management by Supervisor 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 , A.EFFSEQ , A.POSITION_NBR , A.SUPERVISOR_ID , 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') AND A.REPORTS_TO = ' '

# 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 Rcd Nbr
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
6 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID
7 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number
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