LM_S4_SQ_RUL_VW (SQL View)	Index Back
Sequencing rules Scorm 2004 Sequencing rules

LM_S4_SQ_RUL_VW

(SQL View)

Sequencing rules

Scorm 2004 Sequencing rules

SELECT A.LM_S4_ACT_ID , A.LM_s4_SEQ_ID , D.LM_S4_SEQ_COLL , B.LM_S4_SEQ_RULE_ID , B.LM_S4_EVAL_ORDER , B.LM_S4_COND_COMBO , B.LM_S4_RULE_TYPE , B.LM_S4_RULE_ACTION , C.LM_S4_RULE_COND_ID , C.LM_S4_OBJV_ID , C.LM_S4_MEAS_THOLD , C.LM_S4_RULE_OP , C.LM_S4_RULE_CND_TYP FROM PS_LM_S4_ACT_SEQ A , PS_LM_S4_SEQ_RULE B , PS_LM_S4_RULE_COND C , PS_LM_S4_SEQUENCE D WHERE A.LM_s4_SEQ_ID = B.LM_s4_SEQ_ID AND B.LM_S4_SEQ_RULE_ID = C.LM_S4_SEQ_RULE_ID AND A.LM_S4_SEQ_ID = D.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_SEQ_RULE_ID Number(10,0) DECIMAL(10) NOT NULL Sequencing Rule Id

5 LM_S4_EVAL_ORDER Number(10,0) DECIMAL(10) NOT NULL Sequencing rule evaluation order

6 LM_S4_COND_COMBO Character(2) VARCHAR2(2) NOT NULL Rule condition combination
10=all
20=any
Default Value: 10

7 LM_S4_RULE_TYPE Character(2) VARCHAR2(2) NOT NULL Sequencing Rule type
10=preConditionRule
20=postConditionRule
30=exitConditionRule

8 LM_S4_RULE_ACTION Character(2) VARCHAR2(2) NOT NULL Sequencing Rule Action
05=skip
10=disabled
15=hiddenFromChoice
20=stopForwardTraversal
25=exitParent
30=exitAll
35=retry
40=retryAll
45=continue
50=previous
55=exit

9 LM_S4_RULE_COND_ID Number(10,0) DECIMAL(10) NOT NULL Sequencing Rule Condition Id

10 LM_S4_OBJV_ID Number(10,0) DECIMAL(10) NOT NULL Objective Id

11 LM_S4_MEAS_THOLD Signed Number(7,4) DECIMAL(5,4) NOT NULL Sequencing rule measure threshold

12 LM_S4_RULE_OP Character(2) VARCHAR2(2) NOT NULL Sequencing/Rollup Rule operator
10=noOp
20=not
Default Value: 10

13 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

#	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_SEQ_RULE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Sequencing Rule Id
5	LM_S4_EVAL_ORDER	Number(10,0)	DECIMAL(10) NOT NULL	Sequencing rule evaluation order
6	LM_S4_COND_COMBO	Character(2)	VARCHAR2(2) NOT NULL	Rule condition combination 10=all 20=any Default Value: 10
7	LM_S4_RULE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Sequencing Rule type 10=preConditionRule 20=postConditionRule 30=exitConditionRule
8	LM_S4_RULE_ACTION	Character(2)	VARCHAR2(2) NOT NULL	Sequencing Rule Action 05=skip 10=disabled 15=hiddenFromChoice 20=stopForwardTraversal 25=exitParent 30=exitAll 35=retry 40=retryAll 45=continue 50=previous 55=exit
9	LM_S4_RULE_COND_ID	Number(10,0)	DECIMAL(10) NOT NULL	Sequencing Rule Condition Id
10	LM_S4_OBJV_ID	Number(10,0)	DECIMAL(10) NOT NULL	Objective Id
11	LM_S4_MEAS_THOLD	Signed Number(7,4)	DECIMAL(5,4) NOT NULL	Sequencing rule measure threshold
12	LM_S4_RULE_OP	Character(2)	VARCHAR2(2) NOT NULL	Sequencing/Rollup Rule operator 10=noOp 20=not Default Value: 10
13	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