LM_CI_VW_LNG2

(SQL View)
Index Back

Catalog Item Ext View Language

External View of Related Langauge of Catalog Item External View, filtered to only show the active, current effective dated rows

SELECT A.LM_CI_ID , A.LANGUAGE_CD , A.LM_CS_LONG_NM , A.LM_CS_SHRT_NM , A.LM_CS_DESCR , A.LM_CI_ABST FROM PS_LM_CI_LANG A , PS_LM_CI_TBL C WHERE A.LM_CI_ID=C.LM_CI_ID AND A.EFFDT=C.EFFDT AND %CurrentDateIn BETWEEN C.EFFDT AND C.LM_END_EFFDT

  • Related Language Record for LM_CI_VW2
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
    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_CI_ABST Long Character CLOB Catalog Item Abstract - In addition to the description this field allows for a very long text field for an abstract of the learning activity.