LM_LRNROB_VW_LG

(SQL View)
Index Back

Learner Objectives

Learner Objectives table.

SELECT A.LM_LRNR_OBJV_ID , B.LANGUAGE_CD , B.DESCR FROM PS_LM_LRNR_OBJV A , PS_LM_RVW_RTNG_LNG B , PS_LM_RVW_RTNG_VW4 C , PS_LM_OBJV_TBL_VW1 D WHERE A.LM_OBJV_ID = D.LM_OBJV_ID AND C.LM_RATING_MODEL = B.LM_RATING_MODEL AND C.LM_REVIEW_RATING = A.LM_REVIEW_RATING AND C.EFFDT = B.EFFDT AND C.LM_REVIEW_RATING = B.LM_REVIEW_RATING AND C.LM_RATING_MODEL = D.LM_RATING_MODEL

  • Related Language Record for LM_LRNR_OBJ_VW2 LM_LRNR_OBJ_VW3
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_LRNR_OBJV_ID Number(10,0) DECIMAL(10) NOT NULL Learner Objective ID. System Generated ID Number associated with each Learner Objective.
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description