HR_SRCH_DR_6VW (SQL View)	Index Back
SES:DirectReports AccessType 6 Access Type 6 - Partial Position Management / Department Manager Id This table contains a combination of "Reports To" and "Department Manager Id". First, the "Reports To" method is executed, and then the "Department Manager Id" method is executed. The results of these two methods are combined, giving preference to the "Reports To" method. This method should be used only when Partial Position Management has been implemented.

HR_SRCH_DR_6VW

(SQL View)

SES:DirectReports AccessType 6

Access Type 6 - Partial Position Management / Department Manager Id This table contains a combination of "Reports To" and "Department Manager Id". First, the "Reports To" method is executed, and then the "Department Manager Id" method is executed. The results of these two methods are combined, giving preference to the "Reports To" method. This method should be used only when Partial Position Management has been implemented.

SELECT SUPERVISOR_ID ,SUPERVIS_EMPL_RCD ,EMPLID ,EMPL_RCD ,HR_DR_LEVEL FROM PS_HR_SRCH_DR_6

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID

2 SUPERVIS_EMPL_RCD Number(3,0) SMALLINT NOT NULL Supervisor employee record.

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

5 HR_DR_LEVEL Number(3,0) SMALLINT NOT NULL Number denoting how many levels down the organizational chart the employee is from the supervisor. Direct reports are always level 1.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SUPERVISOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Supervisor ID
2	SUPERVIS_EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Supervisor employee record.
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
5	HR_DR_LEVEL	Number(3,0)	SMALLINT NOT NULL	Number denoting how many levels down the organizational chart the employee is from the supervisor. Direct reports are always level 1.