LM_ENR_LC_AET

(SQL Table)
Index Back

Learning Component - Enrlmt

Learning Component - Enrollment

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID
3 LM_LC_ID Number(10,0) DECIMAL(10) NOT NULL Learning Component ID - Blended Learning
4 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
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.