LM_SRCH_CIRTGVW

(SQL View)
 Index Back

Ratings for Catalog Items

This view will be used for SES. The ratings average for catalog items are aggregated. The ratings value is the average ratings for the courses.

%Sql(LM_SRCH_AVE_RTG_SQL,LM_CI_ID,LM_CI_TBL)

  • Related Language Record: LM_SRCHCIRT_LVW

    • # 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 HCSC_RTG_DESCR Character(254) VARCHAR2(254) NOT NULL Ratings Description