HRCD_TRLVL_TAO (SQL Table)	Index Back
CD Tree Level Incremented This table stores the list of nodes where the supervisor had a tree level higher than some direct report. The reports have their tree level increased by 1. This table allows that to happen only once to each supervisor involved to avoid an endless loop if the supervisor reports to themself.

HRCD_TRLVL_TAO

(SQL Table)

CD Tree Level Incremented

This table stores the list of nodes where the supervisor had a tree level higher than some direct report. The reports have their tree level increased by 1. This table allows that to happen only once to each supervisor involved to avoid an endless loop if the supervisor reports to themself.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID

3 SUPERVISOR_ERN Number(3,0) SMALLINT NOT NULL This is used to hold the Employment Record Number of a supervisor.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SUPERVISOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Supervisor ID
3	SUPERVISOR_ERN	Number(3,0)	SMALLINT NOT NULL	This is used to hold the Employment Record Number of a supervisor.