HRCD_TREE_COUNT (SQL Table)	Index Back
Tree Count This table contains all nodes in a tree built by job tree builder with counts of their direct reports, peers and total reporting. It is used to improve performance of company directory.

HRCD_TREE_COUNT

(SQL Table)

Tree Count

This table contains all nodes in a tree built by job tree builder with counts of their direct reports, peers and total reporting. It is used to improve performance of company directory.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

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

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

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

6 PEER_COUNT Number(4,0) SMALLINT NOT NULL Company Directory Peers Count

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
4	PARENT_NODE_NAME	Character(20)	VARCHAR2(20) NOT NULL	Name of parent node
5	DR_COUNT	Number(4,0)	SMALLINT NOT NULL	Direct Reports Count
6	PEER_COUNT	Number(4,0)	SMALLINT NOT NULL	Company Directory Peers Count
7	INDR_COUNT	Number(7,0)	INTEGER NOT NULL	Indirect Reports Count