LM_ENR_LC_AET(SQL Table) |
Index Back |
|---|---|
Learning Component - EnrlmtLearning Component - Enrollment |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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. |