LM_S4_RU_RUL_VW

(SQL View)
 Index Back

Sequencing rules

Scorm 2004 Sequencing rollup rules

SELECT A.LM_S4_ACT_ID , A.LM_s4_SEQ_ID , B.LM_S4_RU_RULE_ID , C.LM_S4_RU_COND_ID , B.LM_S4_CHLD_ACT_SET , B.LM_S4_MIN_COUNT , B.LM_S4_MIN_PERCENT , B.LM_S4_COND_COMBO , B.LM_S4_RU_ACTION , C.LM_S4_RULE_OP , C.LM_S4_RULE_CND_TYP FROM PS_LM_S4_ACT_SEQ A , PS_LM_S4_RU_RULE B , PS_LM_S4_RU_COND C WHERE A.LM_s4_SEQ_ID = B.LM_s4_SEQ_ID AND B.LM_S4_RU_RULE_ID = C.LM_S4_RU_RULE_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_RU_RULE_ID Number(10,0) DECIMAL(10) NOT NULL Rollup Rule Id
4 LM_S4_RU_COND_ID Number(10,0) DECIMAL(10) NOT NULL Rollup Rule Condition Id
5 LM_S4_CHLD_ACT_SET Character(2) VARCHAR2(2) NOT NULL Child Activity Set option
10=all
20=any
30=none
40=atLeastCount
50=atLeastPercent

Default Value: 10

6 LM_S4_MIN_COUNT Number(10,0) DECIMAL(10) NOT NULL Minimum count

Default Value: 0

7 LM_S4_MIN_PERCENT Number(6,4) DECIMAL(5,4) NOT NULL Minimum percent

Default Value: 1

8 LM_S4_COND_COMBO Character(2) VARCHAR2(2) NOT NULL Rule condition combination
10=all
20=any

Default Value: 20

9 LM_S4_RU_ACTION Character(2) VARCHAR2(2) NOT NULL Rollup Rule Action type
10=satisfied
20=notSatisfied
30=completed
40=incomplete
10 LM_S4_RULE_OP Character(2) VARCHAR2(2) NOT NULL Sequencing/Rollup Rule operator
10=noOp
20=not

Default Value: 10

11 LM_S4_RULE_CND_TYP Character(2) VARCHAR2(2) NOT NULL Sequencing Rule Condition type
05=satisfied
10=objectiveStatusKnown
15=objectiveMeasureKnown
20=objectiveMeasureGreaterThan
25=objectiveMeasureLessThan
30=completed
35=activityProgressKnown
40=attempted
45=attemptedLimitExceeded
50=timeLimitExceeded
55=outsideAvailableTimeRange
60=always
65=never