LM_OB_PR_CNT_VW (SQL View)	Index Back
Objectives Programs Count Objectives Programs Count

LM_OB_PR_CNT_VW

(SQL View)

Objectives Programs Count

SELECT LM_OBJV_ID ,COUNT(*) FROM PS_LM_OBJV_PRG_VW3 GROUP BY LM_OBJV_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_OBJV_ID Number(10,0) DECIMAL(10) NOT NULL Objective ID. System Generated ID Number associated with each Objective.

2 COUNTER Number(10,0) DECIMAL(10) NOT NULL Counter

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_OBJV_ID	Number(10,0)	DECIMAL(10) NOT NULL	Objective ID. System Generated ID Number associated with each Objective.
2	COUNTER	Number(10,0)	DECIMAL(10) NOT NULL	Counter