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

HRCD_INDRCNT_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 , SUM(indr_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 INDR_COUNT Number(7,0) INTEGER NOT NULL Indirect Reports Count

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
2	INDR_COUNT	Number(7,0)	INTEGER NOT NULL	Indirect Reports Count