LM_SRCH_PGRTLVW (SQL View)	Index Back
Ratings for Programs Rel Lang This view will be used for SES. The ratings are aggregated per programs. This is the related language view.

LM_SRCH_PGRTLVW

(SQL View)

Ratings for Programs Rel Lang

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

%Sql(LM_SRCH_AVE_RTG_RLANG_SQL,LM_PRG_ID,LM_PRG)

Related Language Record for LM_SRCH_PGRTGVW

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 HCSC_RTG_DESCR Character(254) VARCHAR2(254) NOT NULL Ratings Description

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