LM_SRCH_PGRTGVW

(SQL View)
 Index Back

Ratings for Programs

This view will be used for SES. The ratings are aggregated per programs. The ratings value is the average ratings for the programs.

%Sql(LM_SRCH_AVE_RTG_SQL,LM_PRG_ID,LM_PRG)

  • Related Language Record: LM_SRCH_PGRTLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.
    2 HCSC_RTG_DESCR Character(254) VARCHAR2(254) NOT NULL Ratings Description