LM_S4_TRACK_INT(SQL Table) |
Index Back |
|---|---|
Student Tracking in e-Learningused in AICC/SCORM, for tracking student progress for online classes |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  LM_S4_SQ_SES_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Sequencing Session ID |
| 2 | LM_S4_ORG_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Content Organization Id |
| 3 | LM_S4_ACT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | SCORM 2004 Activity Id |
| 4 | LM_S4_ATT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Sequencing Session ID |
| 5 | LM_S4_INT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Scorm 2004 interaction ID |
| 6 | LM_S4_INT_UID | Long Character(4000) | CLOB NOT NULL | Scorm 2004 - cmi.interactions.n.id |
| 7 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL |
ELM Person ID
Prompt Table: LM_PERSON |
| 8 | LM_S4_INT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Interaction Type
F=fill_in G=matching K=likert L=long_fill_in M=multiple_choice N=numeric O=other P=performance S=sequencing T=true_false |
| 9 | LM_S4_TMSTAMP | Character(50) | VARCHAR2(50) NOT NULL | scorm 2004 timestamp - time(second,10,0) RTE-4-16 YYYY[-MM[-DD[Thh[:mm[:ss[.s[TZD]]]]]]] |
| 10 | LM_S4_INT_WEIGHTIN | Character(20) | VARCHAR2(20) NOT NULL | Score Raw |
| 11 | LM_S4_INT_RESULT | Character(20) | VARCHAR2(20) NOT NULL |
Interaction Result
C=correct I=incorrect N=neutral R=real U=unanticipated |
| 12 | LM_S4_LATENCY | Character(100) | VARCHAR2(100) NOT NULL | cmi.interactions.n.latency |
| 13 | LM_S4_INT_DESCR_LN | Character(100) | VARCHAR2(100) NOT NULL | Scorm 2004 - cmi.interactions.n.description to store language part of the description. |
| 14 | LM_S4_INT_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Comment text |
| 15 | LM_S4_INT_LRNR_RES | Long Character(4000) | CLOB | Learner Response |