HCSC_RTG_CDLM_CI_IDLM_PRG_IDHCSC_RTG_RATINGLM_RTG_LRN_VW1(SQL View) |
Index Back |
|---|---|
Learning Ratings Weighted ValThis view calculates the total ratings weighted value for each rating. |
| SELECT X1.HCSC_RTG_CD , X1.LM_CI_ID , 0 , X1.HCSC_RTG_RATING , COUNT(X1.HCSC_RTG_RATING) , %Round(%DecMult(X1.HCSC_RTG_RATING, COUNT(X1.HCSC_RTG_RATING)),1) FROM PS_LM_RTG_LRN_XREF X1 WHERE X1.LM_CI_ID > 0 AND X1.HCSC_RTG_CD = 'LEARNING_RATINGS' GROUP BY X1.HCSC_RTG_CD, X1.LM_CI_ID , X1.HCSC_RTG_RATING UNION SELECT X2.HCSC_RTG_CD , 0 , X2.LM_PRG_ID , X2.HCSC_RTG_RATING , COUNT(X2.HCSC_RTG_RATING) , %Round(%DecMult(X2.HCSC_RTG_RATING, COUNT(X2.HCSC_RTG_RATING)),1) FROM PS_LM_RTG_LRN_XREF X2 WHERE X2.LM_PRG_ID > 0 AND X2.HCSC_RTG_CD = 'LEARNING_RATINGS' GROUP BY X2.HCSC_RTG_CD, X2.LM_PRG_ID , X2.HCSC_RTG_RATING |
| # | 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 | HCSC_RTG_RATING |
Number(3,0) | SMALLINT NOT NULL | Ratings value |
| 5 | LM_RTG_TOT_RATINGS | Number(15,0) | DECIMAL(15) NOT NULL | Total Ratings |
| 6 | LM_RTG_WEIGHT_VAL | Number(18,2) | DECIMAL(17,2) NOT NULL | Ratings Weighted Value |