| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 LM_S4_SEQ_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Sequencing Definition Id
|
| 2 |
LM_S4_NAME |
Character(254) |
VARCHAR2(254) NOT NULL |
SCORM identifier string
|
| 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
|
| 29 |
LM_S4_SN_ADL_CCC |
Character(1) |
VARCHAR2(1) NOT NULL |
node present flag
Y/N Table Edit
Default Value: N
|
| 30 |
LM_S4_SN_ADL_OBJV |
Character(1) |
VARCHAR2(1) NOT NULL |
node present flag
Y/N Table Edit
Default Value: N
|
| 31 |
LM_S4_SN_ADL_RC |
Character(1) |
VARCHAR2(1) NOT NULL |
node present flag
Y/N Table Edit
Default Value: N
|
| 32 |
LM_S4_SN_CM |
Character(1) |
VARCHAR2(1) NOT NULL |
node present flag
Y/N Table Edit
Default Value: N
|
| 33 |
LM_S4_SN_DC |
Character(1) |
VARCHAR2(1) NOT NULL |
node present flag
Y/N Table Edit
Default Value: N
|
| 34 |
LM_S4_SN_IMS_OBJV |
Character(1) |
VARCHAR2(1) NOT NULL |
node present flag
Y/N Table Edit
Default Value: N
|
| 35 |
LM_S4_SN_LC |
Character(1) |
VARCHAR2(1) NOT NULL |
node present flag
Y/N Table Edit
Default Value: N
|
| 36 |
LM_S4_SN_RC |
Character(1) |
VARCHAR2(1) NOT NULL |
node present flag
Y/N Table Edit
Default Value: N
|
| 37 |
LM_S4_SN_RR |
Character(1) |
VARCHAR2(1) NOT NULL |
node present flag
Y/N Table Edit
Default Value: N
|
| 38 |
LM_S4_SN_SR |
Character(1) |
VARCHAR2(1) NOT NULL |
node present flag
Y/N Table Edit
Default Value: N
|
| 39 |
LM_ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
Datetime Added
|
| 40 |
LM_ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Added By
|
| 41 |
LM_ROW_MAINT_DTTM |
DateTime(26) |
TIMESTAMP |
Row Maintainted DateTime
|
| 42 |
LM_ROW_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Maintained Oprid
|