LM_SRCHCIRT_LVW

(SQL View)
 Index Back

Ratings for Catg Rel Lang

This view will be used for SES. The ratings are aggregated per catalog item. This is the related language table.

%Sql(LM_SRCH_AVE_RTG_RLANG_SQL,LM_CI_ID,LM_CI_TBL)

  • Related Language Record for LM_SRCH_CIRTGVW

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