LM_OBJV_LNG_VW2

(SQL View)
 Index Back

Learning Objv Rel Lang View

Prompt view used for Catalog Search Objective field.

SELECT A.LM_OBJV_ID , B.LANGUAGE_CD , B.LM_OBJV_DESC , B.LM_OBJV_SDESC FROM PS_LM_OBJV_TBL A , PS_LM_OBJV_LNG B WHERE A.LM_OBJV_ID = B.LM_OBJV_ID

  • Related Language Record for LM_OBJV_VW2

    • # 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_DESC Character(100) VARCHAR2(100) NOT NULL Objective description.
    4 LM_OBJV_SDESC Character(10) VARCHAR2(10) NOT NULL Objective short description.