LM_CI_UI_VW_LNG

(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 LM_CI_ID , LANGUAGE_CD , LM_CS_LONG_NM , LM_CS_DESCR FROM PS_LM_CI_VW_LNG

  • Related Language Record for LM_CI_UI_VW LM_ENR_CI_UI_VW
  • # 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_DESCR Character(254) VARCHAR2(254) NOT NULL Description - Describes an object with further detail