LM_S4_SQ_DEF_VW(SQL View) |
Index Back |
---|---|
Sequencing DefinitionsScorm 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 |