LM_ENR_LC_AET(SQL Table) |
Index Back |
---|---|
Learning Component - EnrlmtLearning 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. |