TL_DIRECTREP_2V (SQL View)	Index Back
Direct Reports Access Type 2 Access Type 2 - Supervisor Id This view 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.

TL_DIRECTREP_2V

(SQL View)

Direct Reports Access Type 2

Access Type 2 - Supervisor Id This view 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 ,EMPL_STATUS ,POSITION_NBR ,JOB_EFFDT ,SUPERVISOR_FLAG ,DRILL_DOWN_FLAG FROM PS_HR_DIRECT_REP_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.

5 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Status
A=Active
D=Deceased
L=Leave of Absence
P=Leave With Pay
Q=Retired With Pay
R=Retired
S=Suspended
T=Terminated
U=Terminated With Pay
V=Terminated Pension Pay Out
W=Short Work Break
X=Retired-Pension Administration

6 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

7 JOB_EFFDT Date(10) DATE Job Effective Date

8 SUPERVISOR_FLAG Character(1) VARCHAR2(1) NOT NULL Y/N field to determine if a employee is a supervisor on the direct reports tables.

9 DRILL_DOWN_FLAG Character(1) VARCHAR2(1) NOT NULL Y/N field to determine if the row will appear in the dynamic drill down query. These rows appear in the getsupervisor query.

#	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.
5	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payroll Status A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration
6	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
7	JOB_EFFDT	Date(10)	DATE	Job Effective Date
8	SUPERVISOR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Y/N field to determine if a employee is a supervisor on the direct reports tables.
9	DRILL_DOWN_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Y/N field to determine if the row will appear in the dynamic drill down query. These rows appear in the getsupervisor query.