LM_S4_GLB_PRGRS

(SQL Table)
 Index Back

Tracking Global Objective Prog

Global objectives progress - LM_S4_OBJ_SAT_STS and LM_S4_OBJ_NORM_MSR are synced up to local objectvie progress table LM_S4_OBJ_PRGRS. Rest are synced up to local objective tracking table LM_S4_TRACK_OBJ.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
2 LM_S4_GLOB_OBJV_ID Number(10,0) DECIMAL(10) NOT NULL Global Objective Id
3 LM_S4_SQ_SES_ID Number(10,0) DECIMAL(10) NOT NULL Sequencing Session ID
4 LM_S4_OBJ_PRG_STS Character(1) VARCHAR2(1) NOT NULL SCORM 2004: Objective Progress Status
N=No
Y=Yes

Default Value: N

5 LM_S4_OBJ_SAT_STS Character(1) VARCHAR2(1) NOT NULL SCORM 2004: Objective Satisfied Status
N=No
Y=Yes
6 LM_S4_OBJ_MSR_STS Character(1) VARCHAR2(1) NOT NULL SCORM 2004: Objective Measure Status
N=No
Y=Yes

Default Value: N

7 LM_S4_OBJ_NORM_MEA Character(20) VARCHAR2(20) NOT NULL Objective Normalized Measure
8 LM_S4_OBJ_SCOR_RAW Character(7) VARCHAR2(7) NOT NULL Score Raw
9 LM_S4_OBJ_SCOR_MIN Character(7) VARCHAR2(7) NOT NULL Score Min
10 LM_S4_OBJ_SCOR_MAX Character(7) VARCHAR2(7) NOT NULL Objective Score Max
11 LM_S4_OBJ_COMPSTAT Character(1) VARCHAR2(1) NOT NULL Lesson current Status. values: C:completed I:incomplete U: unknown N:not attempted
C=Completed
I=Incomplete
N=Not Attempted
U=Unknown
12 LM_S4_OBJ_PRG_MEA Character(20) VARCHAR2(20) NOT NULL Objective progress measure
13 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
14 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
15 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
16 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid