LM_S4_ACTIVITY(SQL Table) |
Index Back |
|---|---|
SCORM 2004 Activity |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  LM_S4_ACT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | SCORM 2004 Activity Id |
| 2 | LM_S4_ORG_ID | Number(10,0) | DECIMAL(10) NOT NULL | Content Organization Id |
| 3 | LM_S4_NAME | Character(254) | VARCHAR2(254) NOT NULL | SCORM identifier string |
| 4 | LM_S4_NODE_START | Number(10,0) | DECIMAL(10) NOT NULL | Activity node range start index |
| 5 | LM_S4_NODE_END | Number(10,0) | DECIMAL(10) NOT NULL | Activity node range end index |
| 6 | LM_S4_PAR_ACT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Parent Activity Id |
| 7 | LM_S4_IS_LEAF | Character(1) | VARCHAR2(1) NOT NULL |
Is the activity a leaf activity?
Y/N Table Edit Default Value: N |
| 8 | LM_S4_TREE_LEVEL | Number(10,0) | DECIMAL(10) NOT NULL | Activity Tree Level |
| 9 | LM_S4_ACT_VISIBLE | Character(1) | VARCHAR2(1) NOT NULL |
Activity Visible Flag
Y/N Table Edit Default Value: Y |
| 10 | LM_S4_TITLE | Character(200) | VARCHAR2(200) NOT NULL | Title |
| 11 | LM_S4_CMPLTD_MEAS | Character(1) | VARCHAR2(1) NOT NULL |
Completed by measure
Y/N Table Edit Default Value: N |
| 12 | LM_S4_MIN_PROG_MEA | Number(6,4) | DECIMAL(5,4) NOT NULL |
Minimum progress measure
Default Value: 1 |
| 13 | LM_S4_PROG_WEIGHT | Number(6,4) | DECIMAL(5,4) NOT NULL |
Progress Weight
Default Value: 1 |
| 14 | LM_S4_PARAMETERS | Long Character(1000) | VARCHAR2(1000) | SCORM Resource Parameters |
| 15 | LM_S4_TIME_LIM_ACT | Character(2) | VARCHAR2(2) NOT NULL |
Time Limit Action
10=exit,message 20=exit,no message 30=continue,message 40=continue,no message |
| 16 | LM_S4_DATA_FRM_LMS | Long Character(4000) | CLOB | Data from LMS |
| 17 | LM_S4_HIDE_PREV | Character(1) | VARCHAR2(1) NOT NULL |
Hide Previous flag
Y/N Table Edit Default Value: N |
| 18 | LM_S4_HIDE_CONT | Character(1) | VARCHAR2(1) NOT NULL |
Hide Continue flag
Y/N Table Edit Default Value: N |
| 19 | LM_S4_HIDE_EXIT | Character(1) | VARCHAR2(1) NOT NULL |
Hide Exit flag
Y/N Table Edit Default Value: N |
| 20 | LM_S4_HIDE_EXITALL | Character(1) | VARCHAR2(1) NOT NULL |
Hide Exit All flag
Y/N Table Edit Default Value: N |
| 21 | LM_S4_HIDE_ABDN | Character(1) | VARCHAR2(1) NOT NULL |
Hide Abandon flag
Y/N Table Edit Default Value: N |
| 22 | LM_S4_HIDE_ABDNALL | Character(1) | VARCHAR2(1) NOT NULL |
Hide Abandon All flag
Y/N Table Edit Default Value: N |
| 23 | LM_S4_HIDE_SUSPALL | Character(1) | VARCHAR2(1) NOT NULL |
Hide Suspend All flag
Y/N Table Edit Default Value: N |
| 24 | LM_ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | Datetime Added |
| 25 | LM_ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Added By |
| 26 | LM_ROW_MAINT_DTTM | DateTime(26) | TIMESTAMP | Row Maintainted DateTime |
| 27 | LM_ROW_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Maintained Oprid |