LM_CI_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

LM_CI_VW_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_SHRT_NM , CILNG.LM_CS_DESCR , CILNG.LM_CI_ABST 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_ALL_CI_VW LM_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_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.

#	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.