LM_RTG_ALL_VW (SQL View)	Index Back
Learning Ratings View Use this view to select all activity and program ratings. The primary Learning Environment is selected for the activities and programs.

LM_RTG_ALL_VW

(SQL View)

Learning Ratings View

Use this view to select all activity and program ratings. The primary Learning Environment is selected for the activities and programs.

SELECT XF.HCSC_RTG_CD , AC.LM_ACT_ID , 0 , AC.LM_CI_ID , %NumToChar(AC.LM_DMTHD_TYPE_ID) , AC.LM_DMTHD_TYPE_ID , CASE WHEN FC.LM_FCLTY_ID > 0 THEN FC.LM_FCLTY_ID ELSE 0 END , IT.LM_INSTR_ID , LE.LM_LE_ID , ' ' , FC.LM_ROOM_ID , AC.LM_ACT_CD , AC.LM_CS_LONG_NM , FC.LM_SS_FCLTY_DISP FROM PS_LM_ACT_CI_VW AC LEFT OUTER JOIN PS_LM_RTG_LRN_XREF XF ON XF.LM_ACT_ID = AC.LM_ACT_ID LEFT OUTER JOIN PS_LM_ACT_ONEFC_VW FC ON FC.LM_ACT_ID = AC.LM_ACT_ID LEFT OUTER JOIN PS_LM_ACT_INSTR_VW IT ON AC.LM_ACT_ID = IT.LM_ACT_ID , PS_LM_ACT_LE LE WHERE AC.LM_ACT_ID = LE.LM_ACT_ID AND LE.LM_PRM_LE = 'Y' UNION SELECT XF.HCSC_RTG_CD , 0 , PG.LM_PRG_ID , 0 , PG.LM_PRG_TYPE , 0 , 0 , 0 , LE.LM_LE_ID , PG.LM_PRG_TYPE , 0 , PG.LM_PRG_CD , PG.LM_PRG_LONG_NM , ' ' FROM PS_LM_PRG PG LEFT OUTER JOIN PS_LM_RTG_LRN_XREF XF ON XF.LM_PRG_ID = PG.LM_PRG_ID , PS_LM_PRG_LE LE WHERE PG.LM_PRG_ID = LE.LM_PRG_ID AND LE.LM_PRM_LE = 'Y' AND PG.EFFDT = LE.EFFDT AND PG.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_LM_PRG X WHERE X.LM_PRG_ID = PG.LM_PRG_ID AND X.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HCSC_RTG_CD Character(30) VARCHAR2(30) NOT NULL Ratings Identification

2 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID

3 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.

4 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item

5 LM_ACTPRG_TYPE Character(15) VARCHAR2(15) NOT NULL Act/Program Type

6 LM_DMTHD_TYPE_ID Number(10,0) DECIMAL(10) NOT NULL Delivery Method Type ID - This is a unique identifier for each delivery method type

7 LM_FCLTY_ID Number(10,0) DECIMAL(10) NOT NULL Facility ID
Default Value: 0

8 LM_INSTR_ID Number(15,0) DECIMAL(15) NOT NULL Instructor ID

9 LM_LE_ID Number(10,0) DECIMAL(10) NOT NULL Learning Environment ID - System Generated number
Prompt Table: LM_LE_UI_VW

10 LM_PRG_TYPE Character(2) VARCHAR2(2) NOT NULL Program Type
CE=Certification
CU=Curriculum

11 LM_ROOM_ID Number(10,0) DECIMAL(10) NOT NULL Room ID

12 LM_RTG_ACT_PRG_CD Character(30) VARCHAR2(30) NOT NULL Code

13 LM_RTG_LRNG_TITLE Character(200) VARCHAR2(200) NOT NULL Title

14 LM_SS_FCLTY_DISP Character(1) VARCHAR2(1) NOT NULL Display facility through self service

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HCSC_RTG_CD	Character(30)	VARCHAR2(30) NOT NULL	Ratings Identification
2	LM_ACT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Activity ID
3	LM_PRG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Program ID is a unique identifier for curriculum and certification Programs.
4	LM_CI_ID	Number(10,0)	DECIMAL(10) NOT NULL	Catalog Item ID - System Generated ID Number associated with each Catalog Item
5	LM_ACTPRG_TYPE	Character(15)	VARCHAR2(15) NOT NULL	Act/Program Type
6	LM_DMTHD_TYPE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Delivery Method Type ID - This is a unique identifier for each delivery method type
7	LM_FCLTY_ID	Number(10,0)	DECIMAL(10) NOT NULL	Facility ID Default Value: 0
8	LM_INSTR_ID	Number(15,0)	DECIMAL(15) NOT NULL	Instructor ID
9	LM_LE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Environment ID - System Generated number Prompt Table: LM_LE_UI_VW
10	LM_PRG_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Program Type CE=Certification CU=Curriculum
11	LM_ROOM_ID	Number(10,0)	DECIMAL(10) NOT NULL	Room ID
12	LM_RTG_ACT_PRG_CD	Character(30)	VARCHAR2(30) NOT NULL	Code
13	LM_RTG_LRNG_TITLE	Character(200)	VARCHAR2(200) NOT NULL	Title
14	LM_SS_FCLTY_DISP	Character(1)	VARCHAR2(1) NOT NULL	Display facility through self service