LM_SRCHACTCILNG

(SQL View)
 Index Back

Search: Rel Lang View

Related Language View for Activity / Catalog Item search view. This view includes catalog items that does not have any activities.

SELECT LM_ACT_ID , LM_CI_ID , LANGUAGE_CD , LM_DM_LONG_NM , LM_DM_SHRT_NM , LM_CS_LONG_NM , LM_CS_DESCR FROM PS_LM_SRCHACTC1LNG UNION SELECT LM_ACT_ID , LM_CI_ID , LANGUAGE_CD , LM_DM_LONG_NM , LM_DM_SHRT_NM , LM_CS_LONG_NM , LM_CS_DESCR FROM PS_LM_SRCHACTC2LNG UNION SELECT LM_ACT_ID , LM_CI_ID , LANGUAGE_CD , LM_DM_LONG_NM , LM_DM_SHRT_NM , LM_CS_LONG_NM , LM_CS_DESCR FROM PS_LM_SRCHACTC3LNG

  • Related Language Record for LM_SRCH_ACFL_VW LM_SRCH_ACTCIVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    2 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 LM_DM_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - the long name of a Delivery Method Type
    5 LM_DM_SHRT_NM Character(10) VARCHAR2(10) NOT NULL Short Name - Short Name of a Delivery Method Type
    6 LM_SRCH_TITLE Character(200) VARCHAR2(200) NOT NULL Search Title
    7 LM_SRCH_DESCR Character(254) VARCHAR2(254) NOT NULL Search Description