LM_RTGRPT_STG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	HCSC_RTG_CD	Character(30)	VARCHAR2(30) NOT NULL	Ratings Identification
3	LM_ACT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Activity ID
4	LM_PRG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Program ID is a unique identifier for curriculum and certification Programs.
5	LM_CI_ID	Number(10,0)	DECIMAL(10) NOT NULL	Catalog Item ID - System Generated ID Number associated with each Catalog Item
6	LM_ACTPRG_TYPE	Character(15)	VARCHAR2(15) NOT NULL	Act/Program Type
7	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
8	LM_FCLTY_ID	Number(10,0)	DECIMAL(10) NOT NULL	Facility ID
9	LM_INSTR_ID	Number(15,0)	DECIMAL(15) NOT NULL	Instructor ID
10	LM_LE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Environment ID - System Generated number
11	LM_PRG_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Program Type CE=Certification CU=Curriculum
12	LM_ROOM_ID	Number(10,0)	DECIMAL(10) NOT NULL	Room ID
13	LM_RTG_ACT_PRG_CD	Character(30)	VARCHAR2(30) NOT NULL	Code
14	LM_SS_FCLTY_DISP	Character(1)	VARCHAR2(1) NOT NULL	Display facility through self service
15	LM_RTG_LRNG_TITLE	Character(200)	VARCHAR2(200) NOT NULL	Title
16	LM_DM_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Long Name - the long name of a Delivery Method Type
17	LM_LE_LONG_NM	Character(60)	VARCHAR2(60) NOT NULL	Learning Environment Long Name
18	LM_RTG_TOT_RATINGS	Number(15,0)	DECIMAL(15) NOT NULL	Total Ratings
19	LM_EP_RATING	Number(6,2)	DECIMAL(5,2) NOT NULL	Rating
20	LM_FCLTY	Character(50)	VARCHAR2(50) NOT NULL	Facility Description
21	LM_NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Name Display field