LM_ENR_LC_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_ENRLMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Enrollment ID
2	LM_LC_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Component ID - Blended Learning
3	LM_ACT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Activity ID
4	LM_ACTIVE_LRN	Character(1)	VARCHAR2(1) NOT NULL	Learning Component - Active Learning N=No Y=Yes
5	LM_LC_COMP_STTS	Character(4)	VARCHAR2(4) NOT NULL	Learning Component - Completion Status CANC=Dropped COMP=Completed INCO=Not Completed INPO=In-Progress NOAT=Not Attempted
6	LM_PASS_VAL_ID	Number(10,0)	DECIMAL(10) NOT NULL	Passing Scheme Value ID
7	LM_ATT_VAL_ID	Number(10,0)	DECIMAL(10) NOT NULL	Attendance Scheme Value Id. This will identify the combination of User Label / Attendance uniquely
8	LM_GRADE_VAL_ID	Number(10,0)	DECIMAL(10) NOT NULL	This will uniquely identify the combination of User Label / Grade value.
9	LM_SCORE	Character(30)	VARCHAR2(30) NOT NULL	Score for this Enrollment. Score will be passed by Content Vendor.
10	LM_ENRLMT_DESCR	Long Character(2000)	VARCHAR2(2000)	Comments
11	LM_HRS_TRACK_STTS	Character(1)	VARCHAR2(1) NOT NULL	Hour Tracking Status 1=Pending Review from ELM Admin. 2=Approved by ELM Administrator 3=Pending Review from Payroll 4=Cancelled 5=Publish Error 6=Rejected by Payroll Admin 7=Finalized Default Value: 1
12	LM_CST_TRACK_STTS	Character(1)	VARCHAR2(1) NOT NULL	Student Cost Status 1=Ready to Sent to HR/TA 2=Sent to HR/TA successfully 3=Canceled 4=Publish Error 5=Processed by HR/TA 6=Processed by HR/TA with Errors 9=New Default Value: 9
13	LM_ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	Datetime Added
14	LM_ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Added By
15	LM_ROW_MAINT_DTTM	DateTime(26)	TIMESTAMP	Row Maintainted DateTime
16	LM_ROW_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Maintained Oprid