LM_CI_SRCH_LANG

(SQL View)
Index Back

Catalog Item Search Language

Related Langauge for Search record

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

  • Related Language Record for LM_CI_SRCH
  • # 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

    Default Value: 1

    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

    Prompt Table: LM_CI_LA_SRCH
    Set Control Field: LM_CS_LONG_NM

    4 LM_CS_SHRT_NM Character(10) VARCHAR2(10) NOT NULL Short Name - Describes the short name of an object