LM_OBJV_UI_LVW

(SQL View)
 Index Back

Catalog UI View

Prompt view used for searching on objectives

SELECT DISTINCT A.LM_OBJV_ID , B.LANGUAGE_CD , B.LM_OBJV_DESC FROM PS_LM_OBJV_VW A ,PS_LM_OBJV_LNG_VW B WHERE A.LM_OBJV_DISP='Y' AND A.LM_OBJV_ID = B.LM_OBJV_ID

  • Related Language Record for LM_OBJV_UIFL_VW LM_OBJV_UI_VW

    • # 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.

    Default Value: 0

    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 LM_OBJV_DESC Character(100) VARCHAR2(100) NOT NULL Objective description.