LM_S4_OBJ_PRGRS

(SQL Table)
 Index Back

Tracking Model Objective Prog

Tracking Mode - Objective Progress

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_S4_SQ_SES_ID Number(10,0) DECIMAL(10) NOT NULL Sequencing Session ID
2 LM_S4_ORG_ID Number(10,0) DECIMAL(10) NOT NULL Content Organization Id
3 LM_S4_ACT_ID Number(10,0) DECIMAL(10) NOT NULL SCORM 2004 Activity Id
4 LM_S4_ATT_ID Number(10,0) DECIMAL(10) NOT NULL Sequencing Session ID
5 LM_S4_OBJV_ID Number(10,0) DECIMAL(10) NOT NULL Objective Id
6 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
7 LM_S4_OBJ_PRG_STS Character(1) VARCHAR2(1) NOT NULL SCORM 2004: Objective Progress Status
N=No
Y=Yes

Default Value: N

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

Default Value: N

9 LM_S4_OBJ_MSR_STS Character(1) VARCHAR2(1) NOT NULL SCORM 2004: Objective Measure Status
N=No
Y=Yes

Default Value: N

10 LM_S4_OBJ_NORM_MEA Character(20) VARCHAR2(20) NOT NULL Objective Normalized Measure
11 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
12 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
13 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
14 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid