LM_EN_LCTBL_HST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	LM_ENRLMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Enrollment ID
4	LM_LC_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Component ID - Blended Learning
5	LM_ACT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Activity ID
6	LM_ACTIVE_LRN	Character(1)	VARCHAR2(1) NOT NULL	Learning Component - Active Learning N=No Y=Yes
7	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
8	LM_PASS_VAL_ID	Number(10,0)	DECIMAL(10) NOT NULL	Passing Scheme Value ID
9	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
10	LM_GRADE_VAL_ID	Number(10,0)	DECIMAL(10) NOT NULL	This will uniquely identify the combination of User Label / Grade value.
11	LM_SCORE	Character(30)	VARCHAR2(30) NOT NULL	Score for this Enrollment. Score will be passed by Content Vendor.
12	LM_ENRLMT_DESCR	Long Character(2000)	VARCHAR2(2000)	Comments
13	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
14	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
15	LM_ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	Datetime Added
16	LM_ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Added By
17	LM_ROW_MAINT_DTTM	DateTime(26)	TIMESTAMP	Row Maintainted DateTime
18	LM_ROW_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Maintained Oprid