LM_KWRD_VW (SQL View)	Index Back
Keyword Ext View Listing of Keywords associated with current, active Catalog Items

LM_KWRD_VW

(SQL View)

Keyword Ext View

Listing of Keywords associated with current, active Catalog Items

SELECT A.LM_CI_ID , A.LM_KWRD_ID , D.LM_KWRD FROM PS_LM_KWRD_CI_TBL A , PS_LM_KWRD_TBL D , PS_LM_CI_TBL C WHERE A.LM_KWRD_ID=D.LM_KWRD_ID AND A.LM_CI_ID=C.LM_CI_ID AND A.EFFDT=C.EFFDT AND %CurrentDateIn BETWEEN C.EFFDT AND C.LM_END_EFFDT AND C.LM_CI_STATUS='10'

Related Language Record: LM_KWRD_VW_LNG

# 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 LM_KWRD_ID Number(10,0) DECIMAL(10) NOT NULL Keyword ID - This is a system generated number used as a unique identifier for the keyword table.

3 LM_KWRD Character(30) VARCHAR2(30) NOT NULL Keyword - Used to store all keywords

#	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	LM_KWRD_ID	Number(10,0)	DECIMAL(10) NOT NULL	Keyword ID - This is a system generated number used as a unique identifier for the keyword table.
3	LM_KWRD	Character(30)	VARCHAR2(30) NOT NULL	Keyword - Used to store all keywords