LM_S4_SQ_SES_IDLM_S4_ORG_IDLM_S4_ACT_IDLM_S4_ATT_IDLM_S4_OBJV_IDPrompt Table: LM_PERSON
F=Failed
P=Passed
U=Unknown
C=Completed
I=Incomplete
N=Not Attempted
U=Unknown
LM_S4_TRACK_OBJ(SQL Table) |
Index Back |
|---|---|
Scorm2004 objective collectionused in SCORM 2004, for tracking objective collections for each attempt. It goes together with LM_S4_OBJ_PRGRS which tracks objective progress information for each attempt. |
| # | 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_OBJV_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Objective Id |
| 6 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL |
ELM Person ID
Prompt Table: LM_PERSON |
| 7 | LM_S4_OBJ_UID | Long Character(4000) | CLOB | Objective URI |
| 8 | LM_S4_OBJ_S_SCALED | Character(7) | VARCHAR2(7) NOT NULL | Score Raw |
| 9 | LM_S4_OBJ_SCOR_RAW | Character(7) | VARCHAR2(7) NOT NULL | Score Raw |
| 10 | LM_S4_OBJ_SCOR_MIN | Character(7) | VARCHAR2(7) NOT NULL | Score Min |
| 11 | LM_S4_OBJ_SCOR_MAX | Character(7) | VARCHAR2(7) NOT NULL | Objective Score Max |
| 12 | LM_S4_OBJ_SUCCSTAT | Character(1) | VARCHAR2(1) NOT NULL |
Objective Success Status
F=Failed P=Passed U=Unknown |
| 13 | LM_S4_OBJ_COMPSTAT | Character(1) | VARCHAR2(1) NOT NULL |
Lesson current Status. values:
C:completed
I:incomplete
U: unknown
N:not attempted
C=Completed I=Incomplete N=Not Attempted U=Unknown |
| 14 | LM_S4_OBJ_PRG_MEA | Character(20) | VARCHAR2(20) NOT NULL | Objective progress measure |
| 15 | LM_S4_OBJ_DESCR | Character(250) | VARCHAR2(250) NOT NULL | Objective descriptions |