LM_S4_OBJMAP_VW

(SQL View)
 Index Back

Objective Maps


SELECT A.LM_S4_ACT_ID , B.LM_S4_OBJV_ID , C.LM_S4_GLOB_OBJV_ID , B.LM_S4_PRIMARY , B.LM_S4_SAT_BY_MEAS , B.LM_S4_MIN_NORM_MEA , B.LM_S4_NAME , C.LM_S4_R_SAT_STAT , C.LM_S4_R_NORM_MEAS , C.LM_S4_W_SAT_STAT , C.LM_S4_W_NORM_MEAS , C.LM_S4_R_RAW_SCORE , C.LM_S4_R_MIN_SCORE , C.LM_S4_R_MAX_SCORE , C.LM_S4_R_CMPL_STAT , C.LM_S4_R_PROG_MEAS , C.LM_S4_W_RAW_SCORE , C.LM_S4_W_MIN_SCORE , C.LM_S4_W_MAX_SCORE , C.LM_S4_W_CMPL_STAT , C.LM_S4_W_PROG_MEAS FROM PS_LM_S4_ACT_SEQ A , PS_LM_S4_OBJECTIVE B , PS_LM_S4_OBJV_MAP C WHERE A.LM_s4_SEQ_ID = B.LM_s4_SEQ_ID AND B.LM_S4_OBJV_ID = C.LM_S4_OBJV_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_OBJV_ID Number(10,0) DECIMAL(10) NOT NULL Objective Id
3 LM_S4_GLOB_OBJV_ID Number(10,0) DECIMAL(10) NOT NULL Global Objective Id
4 LM_S4_PRIMARY Character(1) VARCHAR2(1) NOT NULL Primary Objective flag

Y/N Table Edit

5 LM_S4_SAT_BY_MEAS Character(1) VARCHAR2(1) NOT NULL Satisfied By Measure flag

Y/N Table Edit

6 LM_S4_MIN_NORM_MEA Signed Number(19,7) DECIMAL(17,7) NOT NULL Minimum normalized measure
7 LM_S4_NAME Character(254) VARCHAR2(254) NOT NULL SCORM identifier string
8 LM_S4_R_SAT_STAT Character(1) VARCHAR2(1) NOT NULL Read Satisfied Status flag

Y/N Table Edit

9 LM_S4_R_NORM_MEAS Character(1) VARCHAR2(1) NOT NULL Read Normalized Measure flag

Y/N Table Edit

10 LM_S4_W_SAT_STAT Character(1) VARCHAR2(1) NOT NULL Write Satisfied Status flag

Y/N Table Edit

11 LM_S4_W_NORM_MEAS Character(1) VARCHAR2(1) NOT NULL Write Normalized Measure flag

Y/N Table Edit

12 LM_S4_R_RAW_SCORE Character(1) VARCHAR2(1) NOT NULL Read Raw Score flag

Y/N Table Edit

13 LM_S4_R_MIN_SCORE Character(1) VARCHAR2(1) NOT NULL Read Minimum Score flag

Y/N Table Edit

14 LM_S4_R_MAX_SCORE Character(1) VARCHAR2(1) NOT NULL Read Maximum Score flag

Y/N Table Edit

15 LM_S4_R_CMPL_STAT Character(1) VARCHAR2(1) NOT NULL Read Completion Status flag

Y/N Table Edit

16 LM_S4_R_PROG_MEAS Character(1) VARCHAR2(1) NOT NULL Read Progress Measure flag

Y/N Table Edit

17 LM_S4_W_RAW_SCORE Character(1) VARCHAR2(1) NOT NULL Write Raw Score flag

Y/N Table Edit

18 LM_S4_W_MIN_SCORE Character(1) VARCHAR2(1) NOT NULL Write Minimum Score flag

Y/N Table Edit

19 LM_S4_W_MAX_SCORE Character(1) VARCHAR2(1) NOT NULL Write Maximum Score flag

Y/N Table Edit

20 LM_S4_W_CMPL_STAT Character(1) VARCHAR2(1) NOT NULL Write Completion Status flag

Y/N Table Edit

21 LM_S4_W_PROG_MEAS Character(1) VARCHAR2(1) NOT NULL Write Progress Measure flag

Y/N Table Edit