LM_S4GLBPGR_HST

(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. - History Table

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

Default Value: N

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

Default Value: N

9 LM_S4_OBJ_NORM_MEA Character(20) VARCHAR2(20) NOT NULL Objective Normalized Measure
10 LM_S4_OBJ_SCOR_RAW Character(7) VARCHAR2(7) NOT NULL Score Raw
11 LM_S4_OBJ_SCOR_MIN Character(7) VARCHAR2(7) NOT NULL Score Min
12 LM_S4_OBJ_SCOR_MAX Character(7) VARCHAR2(7) NOT NULL Objective Score Max
13 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
14 LM_S4_OBJ_PRG_MEA Character(20) VARCHAR2(20) NOT NULL Objective progress measure
15 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
16 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
17 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
18 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid