LM_S4_OBJV_MAP

(SQL Table)
 Index Back

Objective Maps

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_S4_OBJV_ID Number(10,0) DECIMAL(10) NOT NULL Objective Id
2 LM_S4_GLOB_OBJV_ID Number(10,0) DECIMAL(10) NOT NULL Global Objective Id
3 LM_S4_R_SAT_STAT Character(1) VARCHAR2(1) NOT NULL Read Satisfied Status flag

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

17 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
18 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
19 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
20 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid