LM_S4_SQSESSION

(SQL Table)
Index Back

Sequencing Session

Sequencing 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