LM_CS_OBJV_VW

(SQL View)
 Index Back

Learning Objective View

Prompt view used for adding Objectives to the Catalog

SELECT A.LM_OBJV_ID , A.LM_OBJV_CD , A.LM_OBJV_DESC , B.LM_EXT_SRC_CD , B.LM_EXT_CD , A.LM_RATING_MODEL , A.LM_GLOBAL_OBJV , 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 AND B.LM_EXT_SRC_CD <> 'PM' UNION SELECT A.LM_OBJV_ID , A.LM_OBJV_CD , A.LM_OBJV_DESC , B.LM_EXT_SRC_CD , B.LM_EXT_CD , A.LM_RATING_MODEL , A.LM_GLOBAL_OBJV , 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 AND B.LM_EXT_SRC_CD = 'PM' AND EXISTS ( SELECT 'X' FROM PS_LM_CAT_ITEMS C WHERE A.LM_OBJV_CD = C.LM_CAT_ITEM_ID AND C.EFF_STATUS = 'A' AND C.LM_CAT_TYPE = B.LM_CAT_TYPE AND C.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_LM_CAT_ITEMS D WHERE C.LM_CAT_TYPE = D.LM_CAT_TYPE AND C.LM_CAT_ITEM_ID = D.LM_CAT_ITEM_ID AND D.EFFDT <= %CurrentDateIn) )

  • Related Language Record: LM_CS_OBJV_LNG

    • # 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_SRC_CD Character(10) VARCHAR2(10) NOT NULL External Source Code

    Prompt Table: LM_OBJV_EXT_STP

    5 LM_EXT_CD Character(30) VARCHAR2(30) NOT NULL External objective code

    Prompt Table: LM_EXT_SRC_VW2

    6 LM_RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Used in Competency Sync messages
    7 LM_GLOBAL_OBJV Character(1) VARCHAR2(1) NOT NULL Flag to indicate if the objective is of type global (used for french reports)

    Y/N Table Edit

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