HR_SRCH_DR_3VW (SQL View)	Index Back
SES:DirectReports AccessType 3 Access Type 3 - Department Manager Id In this table the relationship between an employee/job and a supervisor is defined by the Department table. The "Manager Id" defined on the Department table for the employee/job's department id is considered to be the employee/job's supervisor. When determining the supervisor for an employee/job, if there is no Manager Id associated with the employee's department, then we walk up the Department Tree to get the next highest department in the department hierarchy that has a Manager Id

HR_SRCH_DR_3VW

(SQL View)

SES:DirectReports AccessType 3

Access Type 3 - Department Manager Id In this table the relationship between an employee/job and a supervisor is defined by the Department table. The "Manager Id" defined on the Department table for the employee/job's department id is considered to be the employee/job's supervisor. When determining the supervisor for an employee/job, if there is no Manager Id associated with the employee's department, then we walk up the Department Tree to get the next highest department in the department hierarchy that has a Manager Id

SELECT SUPERVISOR_ID ,EMPLID ,EMPL_RCD ,HR_DR_LEVEL FROM PS_HR_SRCH_DR_3

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

4 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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	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.