LM_S4_ATT_PRGRS(SQL Table) |
Index Back |
|---|---|
Tracking Model Activity StateTracking Mode - Attempt Progress LM_S4_DEFAULT indicates the attempt is a dummy attempt created for the purpose of rollup process for evaluating precondition actions. |
| # | 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_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 6 | LM_S4_ATT_STS | Character(1) | VARCHAR2(1) NOT NULL |
Sequencing and Navigation - Attempt Status
A=Active B=Abandoned C=Completed I=Inactive S=Suspended U=unknown Default Value: U |
| 7 | LM_S4_ATT_PRG_STS | Character(1) | VARCHAR2(1) NOT NULL |
SCORM 2004: Attempt Progress Status
N=No Y=Yes Default Value: N |
| 8 | LM_S4_ATT_CMP_STS | Character(1) | VARCHAR2(1) NOT NULL |
SCORM 2004: Attempt Completion Status
N=No Y=Yes |
| 9 | LM_S4_ATT_CMPAMTST | Character(1) | VARCHAR2(1) NOT NULL |
SCORM 2004: Attempt Completion Amount Status
N=No Y=Yes |
| 10 | LM_S4_ATT_CMPL_AMT | Character(20) | VARCHAR2(20) NOT NULL | Attempt Completion Amount |
| 11 | LM_S4_ATT_ABS_DUR | DateTime(26) | TIMESTAMP |
SCORM 2004: Attempt Absolute Duration
Default Value: 0 |
| 12 | LM_S4_ATT_EXP_DUR | DateTime(26) | TIMESTAMP |
SCORM 2004: Attempt Experienced Duration
Default Value: 0 |
| 13 | LM_S4_ATT_START_DT | DateTime(26) | TIMESTAMP | Sequencing and Navigation session Start Date and Time |
| 14 | LM_S4_ATT_END_DT | DateTime(26) | TIMESTAMP | Sequencing and Navigation session Start Date and Time |
| 15 | LM_S4_DEFAULT | Character(1) | VARCHAR2(1) NOT NULL |
An indicator indicates wheather the attempt is created as default for the purpose of rollup precondition process.
Y/N Table Edit Default Value: N |
| 16 | LM_ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | Datetime Added |
| 17 | LM_ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Added By |
| 18 | LM_ROW_MAINT_DTTM | DateTime(26) | TIMESTAMP | Row Maintainted DateTime |
| 19 | LM_ROW_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Maintained Oprid |