LM_S4_SQ_DEF_VW

(SQL View)
Index Back

Sequencing Definitions

Scorm 2004 Sequencing Definitions.

SELECT A.LM_S4_ACT_ID , A.LM_S4_SEQ_ID , B.LM_S4_SEQ_COLL , B.LM_S4_CM_CHOICE , B.LM_S4_CM_CHOICE_EX , B.LM_S4_CM_FLOW , B.LM_S4_CM_FWD_ONLY , B.LM_S4_CM_ATT_OBJV , B.LM_S4_CM_ATT_PROG , B.LM_S4_ATT_LIM , B.LM_S4_ATT_DUR_LIM , B.LM_S4_RU_OBJV_SAT , B.LM_S4_RU_PROG_CMPL , B.LM_S4_OBJV_MEAS_WT , B.LM_S4_RAND_TIMING , B.LM_S4_RAND_SEL_CT , B.LM_S4_RAND_REORD , B.LM_S4_SEL_TIMING , B.LM_S4_DEL_TRACKED , B.LM_S4_DEL_CMPL_SET , B.LM_S4_DEL_OBJV_SET , B.LM_S4_PRVNT_ACTIV , B.LM_S4_CNSTR_CHOICE , B.LM_S4_RU_REQD_SAT , B.LM_S4_RU_REQD_NSAT , B.LM_S4_RU_REQD_CMPL , B.LM_S4_RU_REQD_INC , B.LM_S4_RU_MEA_ACT FROM PS_LM_S4_ACT_SEQ A , PS_LM_S4_SEQUENCE B WHERE A.LM_S4_SEQ_ID = B.LM_S4_SEQ_ID

# 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_SEQ_ID Number(10,0) DECIMAL(10) NOT NULL Sequencing Definition Id
3 LM_S4_SEQ_COLL Character(1) VARCHAR2(1) NOT NULL Sequencing Collection flag

Y/N Table Edit

Default Value: N

4 LM_S4_CM_CHOICE Character(1) VARCHAR2(1) NOT NULL Control mode: Choice

Y/N Table Edit

Default Value: Y

5 LM_S4_CM_CHOICE_EX Character(1) VARCHAR2(1) NOT NULL Control mode: Choice Exit

Y/N Table Edit

Default Value: Y

6 LM_S4_CM_FLOW Character(1) VARCHAR2(1) NOT NULL Control mode: Flow

Y/N Table Edit

Default Value: N

7 LM_S4_CM_FWD_ONLY Character(1) VARCHAR2(1) NOT NULL Control mode: Forward only

Y/N Table Edit

Default Value: N

8 LM_S4_CM_ATT_OBJV Character(1) VARCHAR2(1) NOT NULL Use Current Attempt Objective Info flag

Y/N Table Edit

Default Value: Y

9 LM_S4_CM_ATT_PROG Character(1) VARCHAR2(1) NOT NULL Current Attempt Progress Info

Y/N Table Edit

Default Value: Y

10 LM_S4_ATT_LIM Signed Number(11,0) DECIMAL(10) NOT NULL Attempt Limit
11 LM_S4_ATT_DUR_LIM Character(100) VARCHAR2(100) NOT NULL Attempt Duration Limit
12 LM_S4_RU_OBJV_SAT Character(1) VARCHAR2(1) NOT NULL Rollup Objective Satisfied flag

Y/N Table Edit

Default Value: Y

13 LM_S4_RU_PROG_CMPL Character(1) VARCHAR2(1) NOT NULL Rollup Progress Completion flag

Y/N Table Edit

Default Value: Y

14 LM_S4_OBJV_MEAS_WT Signed Number(7,4) DECIMAL(5,4) NOT NULL Rollup Objective Measure Weight

Default Value: 1

15 LM_S4_RAND_TIMING Character(2) VARCHAR2(2) NOT NULL Randomization Timing
10=never
20=once
30=onEachNewAttempt

Default Value: 10

16 LM_S4_RAND_SEL_CT Signed Number(11,0) DECIMAL(10) NOT NULL Randomization Select Count
17 LM_S4_RAND_REORD Character(1) VARCHAR2(1) NOT NULL Randomization Reorder Children flag

Y/N Table Edit

Default Value: N

18 LM_S4_SEL_TIMING Character(2) VARCHAR2(2) NOT NULL Select Timing (Randomization Controls)
10=never
20=once
30=onEachNewAttempt

Default Value: 10

19 LM_S4_DEL_TRACKED Character(1) VARCHAR2(1) NOT NULL Delivery Tracked flag

Y/N Table Edit

Default Value: Y

20 LM_S4_DEL_CMPL_SET Character(1) VARCHAR2(1) NOT NULL Is Completion Set flag (delivery options)

Y/N Table Edit

Default Value: N

21 LM_S4_DEL_OBJV_SET Character(1) VARCHAR2(1) NOT NULL Is Objective Set flag (delivery options)

Y/N Table Edit

Default Value: N

22 LM_S4_PRVNT_ACTIV Character(1) VARCHAR2(1) NOT NULL Prevent Activation flag

Y/N Table Edit

Default Value: N

23 LM_S4_CNSTR_CHOICE Character(1) VARCHAR2(1) NOT NULL Constrain Choice flag

Y/N Table Edit

Default Value: N

24 LM_S4_RU_REQD_SAT Character(2) VARCHAR2(2) NOT NULL Rollup Required for Satisfied flag
10=always
20=ifAttempted
30=ifNotSkipped
40=ifNotSuspended

Default Value: 10

25 LM_S4_RU_REQD_NSAT Character(2) VARCHAR2(2) NOT NULL Rollup Required for Not Satisfied flag
10=always
20=ifAttempted
30=ifNotSkipped
40=ifNotSuspended

Default Value: 10

26 LM_S4_RU_REQD_CMPL Character(2) VARCHAR2(2) NOT NULL Rollup Required for Completed flag
10=always
20=ifAttempted
30=ifNotSkipped
40=ifNotSuspended

Default Value: 10

27 LM_S4_RU_REQD_INC Character(2) VARCHAR2(2) NOT NULL Rollup Required for Incomplete flag
10=always
20=ifAttempted
30=ifNotSkipped
40=ifNotSuspended

Default Value: 10

28 LM_S4_RU_MEA_ACT Character(1) VARCHAR2(1) NOT NULL Measure Satisfied If Active flag

Y/N Table Edit

Default Value: Y