HRCD_DRTREE_TAO (SQL Table)	Index Back
Direct Reports for tree builde Table loaded during the company directory tree builder with the direct reports information needed to build the tree. Used for access types 4,5 and 6.

HRCD_DRTREE_TAO

(SQL Table)

Direct Reports for tree builde

Table loaded during the company directory tree builder with the direct reports information needed to build the tree. Used for access types 4,5 and 6.

# 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 TREE_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Parent tree level if this is a part of the PSTREEBRANCH record

7 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

8 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID

9 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

10 DEPT_EFFDT Date(10) DATE Department Table Effective Date

11 JOB_EFFDT Date(10) DATE Job Effective Date

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

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

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

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

16 JOB_INDICATOR Character(1) VARCHAR2(1) NOT NULL This Indicator is used on JOB to specify which employment record is considered to be the primary one for an employee. In case of Multiple Jobs per Employee, this property is being used to make a conscious decision in related features where only 1 Employment Record per Employee needs to be returned.
N=Not Applicable
P=Primary Job
S=Secondary Job

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

#	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	TREE_LEVEL_NUM	Number(3,0)	SMALLINT NOT NULL	Parent tree level if this is a part of the PSTREEBRANCH record
7	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
8	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID
9	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
10	DEPT_EFFDT	Date(10)	DATE	Department Table Effective Date
11	JOB_EFFDT	Date(10)	DATE	Job Effective Date
12	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
13	REPORTS_TO	Character(8)	VARCHAR2(8) NOT NULL	Reports To Position Number
14	SUPERVISOR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Y/N field to determine if a employee is a supervisor on the direct reports tables.
15	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.
16	JOB_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	This Indicator is used on JOB to specify which employment record is considered to be the primary one for an employee. In case of Multiple Jobs per Employee, this property is being used to make a conscious decision in related features where only 1 Employment Record per Employee needs to be returned. N=Not Applicable P=Primary Job S=Secondary Job
17	POSITION_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Override Position Data