| LM_S4_SQSESSION(SQL Table) | Index Back | 
|---|---|
| Sequencing SessionSequencing Session | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Number(10,0) | DECIMAL(10) NOT NULL | Sequencing Session ID | |
| 2 | 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 |