LM_S4_SQSESSION(SQL Table) |
Index Back |
---|---|
Sequencing SessionSequencing Session |
# | 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_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
4 | LM_ENRLMT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Enrollment ID |
5 | LM_LC_ID | Number(10,0) | DECIMAL(10) NOT NULL | Learning Component ID - Blended Learning |
6 | LM_S4_SES_START_DT | DateTime(26) | TIMESTAMP | Sequencing and Navigation session Start Date and Time |
7 | LM_S4_SES_END_DT | DateTime(26) | TIMESTAMP | Sequencing and Navigation session End Date and Time |
8 | LM_S4_LST_NAV_RQST | Character(1) | VARCHAR2(1) NOT NULL |
Sequencing and Navigation - Last Navigation Request for sequencing session
A=Abandon C=Continue E=Exit H=Choice J=Jump L=Abandon All N=None P=Previous R=Resume All S=Suspend All T=Start U=ExitRoot W=ExitParent X=Exit All Y=Retry |
9 | LM_S4_NAV_TARGET | Number(10,0) | DECIMAL(10) NOT NULL | Objective Id |
10 | LM_S4_SES_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Sequencing and Navigation - Session Status, can be Sequencing session or Lerning session.
A=Active B=Abandoned C=Completed I=Inactive S=Suspended T=Initiated U=Unknown Default Value: U |
11 | LM_S4_SES_DEL_REQ | Character(50) | VARCHAR2(50) NOT NULL | Delivery Request |
12 | LM_S4_SES_SQ_REQ | Character(50) | VARCHAR2(50) NOT NULL | Sequencing Request |
13 | LM_S4_CUR_DEL_ACT | Number(10,0) | DECIMAL(10) NOT NULL | SCORM 2004 Activity Id |
14 | LM_S4_PRV_SUS_ACT | Number(10,0) | DECIMAL(10) NOT NULL | SCORM 2004 Activity Id |
15 | LM_S4_SUSPND_START | DateTime(26) | TIMESTAMP | Sequencing and Navigation session Start Date and Time |
16 | LM_S4_SUSPND_END | DateTime(26) | TIMESTAMP | Sequencing and Navigation session Start Date and Time |
17 | LM_ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | Datetime Added |
18 | LM_ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Added By |
19 | LM_ROW_MAINT_DTTM | DateTime(26) | TIMESTAMP | Row Maintainted DateTime |
20 | LM_ROW_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Maintained Oprid |