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

TL_DIRECTREP_4V

(SQL View)

Direct Reports Access Type 4

Access Type 4 - Reports To This view 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 ,EMPL_STATUS ,JOB_EFFDT ,POSITION_NBR ,POSITION_EFFDT ,REPORTS_TO ,POSITION_OVERRIDE ,SUPERVISOR_FLAG ,DRILL_DOWN_FLAG FROM PS_HR_DIRECT_REP_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.

6 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

7 JOB_EFFDT Date(10) DATE Job Effective Date

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

9 POSITION_EFFDT Date(10) DATE Report To Position Effective Date

10 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number

11 POSITION_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Override Position Data

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

13 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	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.
6	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
7	JOB_EFFDT	Date(10)	DATE	Job Effective Date
8	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
9	POSITION_EFFDT	Date(10)	DATE	Report To Position Effective Date
10	REPORTS_TO	Character(8)	VARCHAR2(8) NOT NULL	Reports To Position Number
11	POSITION_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Override Position Data
12	SUPERVISOR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Y/N field to determine if a employee is a supervisor on the direct reports tables.
13	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.