LM_OBJV_FL_VW

(SQL View)
 Index Back

Lrnr Objective, Review Points

Learner Objective View with Review points

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

  • Related Language Record: LM_OBJV_FL_LVW

    • # 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 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    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