HRCD_DRCNT_VW (SQL View)	Index Back
Total direct reports count Count of all direct and indirect reports for each managers using access type 5

HRCD_DRCNT_VW

(SQL View)

Total direct reports count

Count of all direct and indirect reports for each managers using access type 5

SELECT PARENT_NODE_NAME , COUNT(*) FROM PS_HR_JTREE_TAO GROUP BY PARENT_NODE_NAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
2	DR_COUNT	Number(4,0)	SMALLINT NOT NULL	Direct Reports Count