LM_OBJV_VW2

(SQL View)
 Index Back

Learning Objective View

Prompt view used for Catalog Search Objective field.

SELECT LM_OBJV_ID , LM_OBJV_DESC , LM_OBJV_SDESC , LM_OBJV_CD FROM PS_LM_OBJV_TBL

  • Related Language Record: LM_OBJV_LNG_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 LM_OBJV_DESC Character(100) VARCHAR2(100) NOT NULL Objective description.
    3 LM_OBJV_SDESC Character(10) VARCHAR2(10) NOT NULL Objective short description.
    4 LM_OBJV_CD Character(30) VARCHAR2(30) NOT NULL Objective code.

    Prompt Table: LM_OBJV_TBL