LM_PERSON_IDPrompt Table: LM_PERSON
LM_ENRLMT_IDLM_SCO_IDB=Browsed
C=Completed
F=Failed
I=Incomplete
N=Not Attempted
P=Passed
Default Value: N
LM_TRK_STDNT_VW(SQL View) |
Index Back |
|---|---|
LM_TRACK_STDNT_VWSCO Progress view |
| SELECT A.LM_PERSON_ID ,A.LM_ENRLMT_ID ,A.LM_SCO_ID ,A.LM_ACT_ID ,A.LM_LC_ID , B.LM_SCO_TITLE , A.LM_LSN_STAT , A.LM_SCORE_RAW , B.LM_SCO_TYPE , B.LM_WEB_LNCH , B.LM_SCO_URL , B.LM_ELRN_SEQ_ID FROM PS_LM_TRACK_STUDNT A , PS_LM_SCO_DETAIL B WHERE A.LM_ACT_ID=B.LM_ACT_ID AND A.LM_SCO_ID=B.LM_SCO_ID AND A.LM_LC_ID = B.LM_LC_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
ELM Person ID
Prompt Table: LM_PERSON |
| 2 | LM_ENRLMT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Enrollment ID |
| 3 | LM_SCO_ID |
Character(200) | VARCHAR2(200) NOT NULL | A system id for the launchable SCOs or AUs, determined by the content provider |
| 4 | LM_ACT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
| 5 | LM_LC_ID | Number(10,0) | DECIMAL(10) NOT NULL | Learning Component ID - Blended Learning |
| 6 | LM_SCO_TITLE | Character(254) | VARCHAR2(254) NOT NULL | SCO Title |
| 7 | LM_LSN_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Lesson current Status. values:
P:passed
C:completed
F:failed
I:incomplete
B:browsed
N:not attempted
B=Browsed C=Completed F=Failed I=Incomplete N=Not Attempted P=Passed Default Value: N |
| 8 | LM_SCORE_RAW | Character(7) | VARCHAR2(7) NOT NULL | Score Raw |
| 9 | LM_SCO_TYPE | Character(30) | VARCHAR2(30) NOT NULL | A User defined category |
| 10 | LM_WEB_LNCH | Long Character(2000) | VARCHAR2(2000) | Additional params required for launch |
| 11 | LM_SCO_URL | Long Character(2000) | VARCHAR2(2000) | SCO URL |
| 12 | LM_ELRN_SEQ_ID | Number(3,0) | SMALLINT NOT NULL | Seq number |