HR_SRCH_DR_4VW (SQL View)	Index Back
SES:DirectReports AccessType 4 Access Type 4 - Reports To This table uses Full Position Management. The relationship between an employee/job and a supervisor is defined by the "Reports To" position on the Job record.

HR_SRCH_DR_4VW

(SQL View)

SES:DirectReports AccessType 4

Access Type 4 - Reports To This table uses Full Position Management. The relationship between an employee/job and a supervisor is defined by the "Reports To" position on the Job record.

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

# 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.