LM_CIOBJ_VW_LG

(SQL View)
Index Back

Learner Objectives

Learner Objectives table.

SELECT A.LM_CI_ID ,A.EFFDT , B.LANGUAGE_CD , B.DESCR FROM PS_LM_CI_OBJV_TBL 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_CI_OBJ_VW2
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description