LM_ACT_CI_LVW

(SQL View)
 Index Back

Activity CI Lang View

Activity and Catalog Item Language View for Enrollment

SELECT A.LM_ACT_ID , B.LANGUAGE_CD , B.LM_CS_LONG_NM , B.LM_CS_SHRT_NM , B.LM_CS_DESCR , C.LM_DM_LONG_NM FROM PS_LM_ACT A , PS_LM_CI_LANG B , PS_LM_DMTH_TYP_LNG C WHERE A.LM_CI_ID = B.LM_CI_ID AND A.LM_DMTHD_TYPE_ID = C.LM_DMTHD_TYPE_ID AND B.LANGUAGE_CD = C.LANGUAGE_CD UNION SELECT A.LM_ACT_ID , C.LANGUAGE_CD , B.LM_CS_LONG_NM , B.LM_CS_SHRT_NM , B.LM_CS_DESCR , C.LM_DM_LONG_NM FROM PS_LM_ACT A , PS_LM_CI_TBL B , PS_LM_DMTH_TYP_LNG C WHERE A.LM_CI_ID = B.LM_CI_ID AND A.LM_DMTHD_TYPE_ID = C.LM_DMTHD_TYPE_ID AND NOT EXISTS ( SELECT 'X' FROM PS_LM_CI_LANG D WHERE D.LM_CI_ID = B.LM_CI_ID AND D.LANGUAGE_CD = C.LANGUAGE_CD) UNION SELECT A.LM_ACT_ID , B.LANGUAGE_CD , B.LM_CS_LONG_NM , B.LM_CS_SHRT_NM , B.LM_CS_DESCR , C.LM_DM_LONG_NM FROM PS_LM_ACT A , PS_LM_CI_LANG B , PS_LM_DMTH_TYP_TBL C WHERE A.LM_CI_ID = B.LM_CI_ID AND A.LM_DMTHD_TYPE_ID = C.LM_DMTHD_TYPE_ID AND NOT EXISTS ( SELECT 'X' FROM PS_LM_DMTH_TYP_LNG D WHERE D.LM_DMTHD_TYPE_ID = C.LM_DMTHD_TYPE_ID AND D.LANGUAGE_CD = B.LANGUAGE_CD)

  • Related Language Record for LM_ACT_CI_VW LM_ACT_CI_VW2 LM_ACT_CI_VW3 LM_ACT_CI_VW5

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object
    4 LM_CS_SHRT_NM Character(10) VARCHAR2(10) NOT NULL Short Name - Describes the short name of an object
    5 LM_CS_DESCR Character(254) VARCHAR2(254) NOT NULL Description - Describes an object with further detail
    6 LM_DM_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - the long name of a Delivery Method Type