HR_JTRCNT_TAO (SQL Table)	Index Back
Tree builder counts For supervisor and department reporting, the tree builder keeps counts of the direct reports for each manager in this table

HR_JTRCNT_TAO

(SQL Table)

Tree builder counts

For supervisor and department reporting, the tree builder keeps counts of the direct reports for each manager in this table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name

3 PARENT_NODE_NAME Character(20) VARCHAR2(20) NOT NULL Name of parent node

4 TREE_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Parent tree level if this is a part of the PSTREEBRANCH record

5 DR_COUNT Number(4,0) SMALLINT NOT NULL Direct Reports Count

6 INDR_COUNT Number(7,0) INTEGER NOT NULL Indirect Reports Count

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
3	PARENT_NODE_NAME	Character(20)	VARCHAR2(20) NOT NULL	Name of parent node
4	TREE_LEVEL_NUM	Number(3,0)	SMALLINT NOT NULL	Parent tree level if this is a part of the PSTREEBRANCH record
5	DR_COUNT	Number(4,0)	SMALLINT NOT NULL	Direct Reports Count
6	INDR_COUNT	Number(7,0)	INTEGER NOT NULL	Indirect Reports Count