HR_SRCH_DR_2VW (SQL View)	Index Back
SES:Direct Reports Type 2 Temp Temporary table for incremental build of Direct Reports for Access Type 2 by Supervisor Id This table contains is the direct reports reporting structure based on the "Supervisor Id" field on the Job record to determine reporting relationships. Note that this method does not differentiate between multiple concurrent jobs that the supervisor might hold.

HR_SRCH_DR_2VW

(SQL View)

SES:Direct Reports Type 2 Temp

Temporary table for incremental build of Direct Reports for Access Type 2 by Supervisor Id This table contains is the direct reports reporting structure based on the "Supervisor Id" field on the Job record to determine reporting relationships. Note that this method does not differentiate between multiple concurrent jobs that the supervisor might hold.

SELECT SUPERVISOR_ID ,EMPLID ,EMPL_RCD ,HR_DR_LEVEL FROM PS_HR_SRCH_DR_2

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