LM_OBJV_TBL_VW5

(SQL View)
 Index Back

Objectives Search View

Setup page for objectives search dialog view.

SELECT A.LM_OBJV_ID ,A.LM_OBJV_CD , A.LM_OBJV_DESC , B.LM_EXT_CD , B.LM_EXT_SRC_CD ,CASE WHEN (EXISTS ( SELECT 'X' FROM PS_LM_CAT_RLAT C WHERE B.LM_EXT_CD = C.LM_CAT_ITEM_ID AND C.LM_CAT_RLAT_CD='P' AND B.LM_EXT_SRC_CD='PM') ) THEN ( SELECT MESSAGE_TEXT FROM PSMSGCATDEFN WHERE MESSAGE_SET_NBR = 18095 AND MESSAGE_NBR = 3) ELSE ( SELECT MESSAGE_TEXT FROM PSMSGCATDEFN WHERE MESSAGE_SET_NBR = 18095 AND MESSAGE_NBR = 4) END FROM PS_LM_OBJV_TBL A , PS_LM_OBJV_DTL B WHERE A.LM_OBJV_ID = B.LM_OBJV_ID

  • Related Language Record: LM_OBJV_VW5_LVW

    • # 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_CD Character(30) VARCHAR2(30) NOT NULL Objective code.
    3 LM_OBJV_DESC Character(100) VARCHAR2(100) NOT NULL Objective description.
    4 LM_EXT_CD Character(30) VARCHAR2(30) NOT NULL External objective code

    Prompt Table: LM_EXT_SRC_VW2

    5 LM_EXT_SRC_CD Character(10) VARCHAR2(10) NOT NULL External Source Code

    Prompt Table: LM_OBJV_EXT_STP

    6 LM_HAS_REL_OBJV Character(10) VARCHAR2(10) NOT NULL Objective with sub items