LM_OBJV_FL_LVW

(SQL View)
 Index Back

Lrnr Objective, Review Points

Learner Objective View with Review points

SELECT DISTINCT A.LM_OBJV_ID ,L.LANGUAGE_CD , B.LM_OBJV_CD , L.LM_OBJV_DESC , B.LM_RATING_MODEL FROM PS_LM_LRNR_OBJV A ,PS_LM_OBJV_TBL B ,PS_LM_OBJV_LNG L WHERE A.LM_OBJV_STATUS <> '40' AND A.LM_OBJV_STAT_DTTM <= %CurrentDateTimeIn AND A.LM_OBJV_ID = B.LM_OBJV_ID AND A.LM_OBJV_ID=L.LM_OBJV_ID

  • Related Language Record for LM_OBJV_FL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_OBJV_ID Number(10,0) DECIMAL(10) NOT NULL Objective ID. System Generated ID Number associated with each Objective.
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 LM_OBJV_CD Character(30) VARCHAR2(30) NOT NULL Objective code.
    4 LM_OBJV_DESC Character(100) VARCHAR2(100) NOT NULL Objective description.
    5 LM_RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Used in Competency Sync messages