LM_CURLRNG_GRID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	LM_MANAGER_ID	Number(15,0)	DECIMAL(15) NOT NULL	Manager ID
3	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
4	LM_REQ_LRNG_ICON	Image Reference(30)	VARCHAR2(30)	Required Learning Icon displayed on the Team Learning Pagelet for HR Manager Self Service.
5	LM_ALERT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Expired Status = Red Status Icon Warning Status = Yellow Status Icon Required Learning not in expired or warning status = Green Status Icon
6	LM_NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Name Display field
7	LM_PRG_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Program Long Name
8	LM_DM_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Long Name - the long name of a Delivery Method Type
9	LM_STTS	Character(4)	VARCHAR2(4) NOT NULL	Enrollment Status CANC=Dropped COMP=Completed DECL=Denied ENRL=Enrolled INCO=Not Completed INPO=In-Progress MACT=Moved to New Activity NOTS=Not Started PEAP=Pending Approval PEPA=Pending Payment PLAN=Planned PPYA=Payment Approval RQST=Learning Request WAIV=Waived WTLT=Waitlisted
10	LM_PRG_STTS	Character(4)	VARCHAR2(4) NOT NULL	Program Reg Status CANC=Dropped COMP=Completed DECL=Decline ENRL=Registered EXPR=Expired INCO=Not Completed INPO=In-Progress PEAP=Pending Approval PEPA=Pending Payment PLAN=Planned PPYA=Payment Approval REIS=Reissue REVK=Revoked WAIV=Waived WARN=Warning
11	LM_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Description
12	LM_ACTION_DT	Date(10)	DATE	Action/Reason Date
13	LM_START_DT	Date(10)	DATE	Start Date
14	LM_COMPL_DT	Date(10)	DATE	The date on which this Enrollment was marked Completed / InComplete
15	LM_ACT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Activity ID
16	LM_PRG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Program ID is a unique identifier for curriculum and certification Programs.
17	LM_CI_ID	Number(10,0)	DECIMAL(10) NOT NULL	Catalog Item ID - System Generated ID Number associated with each Catalog Item
18	LM_ENRLMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Enrollment ID
19	LM_PRG_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Program Type CE=Certification CU=Curriculum
20	LM_ACT_FEE	Number(19,3)	DECIMAL(18,3) NOT NULL	Activity Fee -- The cost to the learner of enrolling in a class
21	LM_LRN_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Id
22	LM_PRIMARY	Character(1)	VARCHAR2(1) NOT NULL	Primary Contact Method N=No Y=Yes
23	LM_SECONDARY	Number(2,0)	SMALLINT NOT NULL	Primary Contact Method