LM_ENRLMT_IDLM_LC_IDN=No
Y=Yes
CANC=Dropped
COMP=Completed
INCO=Not Completed
INPO=In-Progress
NOAT=Not Attempted
10=None
20=AICC-API
30=AICC-HACP
40=SCORM11
50=SCORM12
60=SCORM2004
LM_SCO12_FLU_VW(SQL View) |
Index Back |
|---|---|
SCORM 1.2 search pageSCROM 1.2/ AICC Table of Content search record |
| SELECT A.LM_ENRLMT_ID ,A.LM_LC_ID ,A.LM_ACT_ID ,A.LM_ACTIVE_LRN ,A.LM_LC_COMP_STTS ,B.LM_CMPLNCE ,C.LM_PERSON_ID ,C.LM_CI_ID FROM PS_LM_ENR_LC_TBL A , PS_LM_LC B , PS_LM_ENRLMT C WHERE A.LM_ACT_ID=B.LM_ACT_ID AND A.LM_LC_ID=B.LM_LC_ID AND A.LM_ENRLMT_ID=C.LM_ENRLMT_ID |
| # | 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_CMPLNCE | Character(3) | VARCHAR2(3) NOT NULL |
Compliance - This field is used to comply with the Scorm and AICC regulations.
10=None 20=AICC-API 30=AICC-HACP 40=SCORM11 50=SCORM12 60=SCORM2004 |
| 7 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 8 | LM_CI_ID | Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |