LM_RTG_LRN_VW2

(SQL View)
 Index Back

Learning Ratings Average Value

This view calculates to the ratings average value

SELECT HCSC_RTG_CD , LM_CI_ID , 0 , %Round(%DecDiv(sum(LM_RTG_WEIGHT_VAL), sum(LM_RTG_TOT_RATINGS)), 1) FROM PS_LM_RTG_LRN_VW1 WHERE LM_CI_ID > 0 GROUP BY HCSC_RTG_CD, LM_CI_ID UNION SELECT HCSC_RTG_CD , 0 , LM_PRG_ID , %Round(%DecDiv(sum(LM_RTG_WEIGHT_VAL), sum(LM_RTG_TOT_RATINGS)), 1) FROM PS_LM_RTG_LRN_VW1 WHERE LM_PRG_ID > 0 GROUP BY HCSC_RTG_CD, LM_PRG_ID

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