LM_EXT_SRC_LNV

(SQL View)
 Index Back

External Source View

Used as a prompt to return external code in Objective Detail Setup

SELECT A.LM_EXT_SRC_CD , A.LM_EXT_CD , B.LANGUAGE_CD , B.LM_EXT_CD_DESC FROM PS_LM_OBJV_EXT_SRC A ,PS_LM_OBJV_EXT_SLN B WHERE A.LM_EXT_SRC_CD = B.LM_EXT_SRC_CD AND A.LM_EXT_CD = B.LM_EXT_CD

  • Related Language Record for LM_EXT_SRC_VW LM_EXT_SRC_VW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_EXT_SRC_CD Character(10) VARCHAR2(10) NOT NULL External Source Code
    2 LM_EXT_CD Character(30) VARCHAR2(30) NOT NULL External objective code
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 LM_EXT_CD_DESC Character(50) VARCHAR2(50) NOT NULL External objective code description