RPM_TMPL_GOAL_V (SQL View)	Index Back
Template view With Goal Count This view shows how many goals/metrics for a template.

RPM_TMPL_GOAL_V

(SQL View)

Template view With Goal Count

This view shows how many goals/metrics for a template.

SELECT RSP_UID20 , COUNT(*) FROM PS_RSP_TP_GOAL WHERE RSP_GOAL_ID <> '0' AND RSP_GOAL_ID <> ' ' GROUP BY RSP_UID20

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RSP_UID20 Character(20) VARCHAR2(20) NOT NULL This field is used as a primary key in Strategic Planning header table (RSP_TP_HEADER)

2 TOTAL_COUNT Number(7,0) INTEGER NOT NULL Total Count

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RSP_UID20	Character(20)	VARCHAR2(20) NOT NULL	This field is used as a primary key in Strategic Planning header table (RSP_TP_HEADER)
2	TOTAL_COUNT	Number(7,0)	INTEGER NOT NULL	Total Count