LM_RTG_AVGCNTVW (SQL View)	Index Back
Ratings Average/Total Count This views selects the average ratings values for Courses and Programs. Also, it gives the total number of reviews for each Courses and Programs.

LM_RTG_AVGCNTVW

(SQL View)

Ratings Average/Total Count

This views selects the average ratings values for Courses and Programs. Also, it gives the total number of reviews for each Courses and Programs.

SELECT V2.LM_CI_ID , V2.LM_PRG_ID , V2.LM_RTG_AVERAGE_VAL , COUNT(*) FROM PS_LM_RTG_LRN_VW1 V1 , PS_LM_RTG_LRN_VW2 V2 WHERE V1.HCSC_RTG_CD = V2.HCSC_RTG_CD AND V1.LM_CI_ID = V2.LM_CI_ID AND V1.LM_PRG_ID = V2.LM_PRG_ID GROUP BY V2.LM_CI_ID, V2.LM_PRG_ID, V2.LM_RTG_AVERAGE_VAL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item

2 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.

3 LM_RTG_AVERAGE_VAL Number(18,2) DECIMAL(17,2) NOT NULL Learning Ratings Average Value

4 LM_RTG_TOT_RATINGS Number(15,0) DECIMAL(15) NOT NULL Total Ratings

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_CI_ID	Number(10,0)	DECIMAL(10) NOT NULL	Catalog Item ID - System Generated ID Number associated with each Catalog Item
2	LM_PRG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Program ID is a unique identifier for curriculum and certification Programs.
3	LM_RTG_AVERAGE_VAL	Number(18,2)	DECIMAL(17,2) NOT NULL	Learning Ratings Average Value
4	LM_RTG_TOT_RATINGS	Number(15,0)	DECIMAL(15) NOT NULL	Total Ratings