LM_S4_ACT_STATE

#	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_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
5	LM_S4_IS_ACTIVE	Character(1)	VARCHAR2(1) NOT NULL	SCORM 2004: Is activity active? N=No Y=Yes Default Value: N
6	LM_S4_IS_SUSPENDED	Character(1)	VARCHAR2(1) NOT NULL	SCORM 2004: Is activity suspended? N=No Y=Yes Default Value: N
7	LM_S4_HAS_CHILDREN	Character(1)	VARCHAR2(1) NOT NULL	SCORM 2004: Activity has children? N=No Y=Yes
8	LM_S4_ACT_STS	Character(1)	VARCHAR2(1) NOT NULL	Sequencing and Navigation - Activity Status A=Active B=Abandoned D=Disabled H=Hidden S=Suspended
9	LM_S4_ACT_PRG_STS	Character(1)	VARCHAR2(1) NOT NULL	SCORM 2004: Activity Progress Status Y/N Table Edit Default Value: N
10	LM_S4_ACT_ABS_DUR	DateTime(26)	TIMESTAMP	SCORM 2004: Activity Absolute Duration Default Value: 0
11	LM_S4_ACT_EXP_DUR	DateTime(26)	TIMESTAMP	SCORM 2004: Activity Absolute Duration Default Value: 0
12	LM_S4_ACT_SUS_DUR	DateTime(26)	TIMESTAMP	SCORM 2004: Activity Absolute Duration
13	LM_S4_ATT_COUNT	Number(10,0)	DECIMAL(10) NOT NULL	SCORM2004 Attempt Count Default Value: 0
14	LM_S4_AVL_CHILDREN	Long Character(4000)	CLOB	Ordered List of Available Children
15	LM_S4_SUS_START_DT	DateTime(26)	TIMESTAMP	Sequencing and Navigation session Start Date and Time
16	LM_S4_SUS_END_DT	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