LM_CI_SRCH_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

LM_CI_SRCH_LNG

(SQL View)

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 CILNG.LM_CI_ID , CILNG.LANGUAGE_CD , CILNG.LM_CS_LONG_NM , CILNG.LM_CS_DESCR FROM PS_LM_CI_LANG CILNG , PS_LM_CI_TBL CI WHERE CILNG.LM_CI_ID=CI.LM_CI_ID AND CILNG.EFFDT=CI.EFFDT AND %CurrentDateIn BETWEEN CI.EFFDT AND CI.LM_END_EFFDT AND CI.LM_CI_STATUS='10'

Related Language Record for LM_SRCH_CI_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

#	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