LM_SRCH_DTM5_VW (SQL View)	Index Back
Last update for CI Categories This has the last update date time for catalog items with categories.

LM_SRCH_DTM5_VW

(SQL View)

Last update for CI Categories

This has the last update date time for catalog items with categories.

SELECT %Coalesce(X.LM_ACT_ID ,0) , A.LM_CI_ID , MAX(LV.LM_ROW_MAINT_DTTM) FROM PS_LM_CI_TBL A LEFT OUTER JOIN PS_LM_ACT X ON X.LM_CI_ID = A.LM_CI_ID , PS_LM_CATG_CI_TBL AG , PS_LM_SRCH_DT5_TBL LV WHERE %CurrentDateIn BETWEEN A.EFFDT AND A.LM_END_EFFDT AND A.LM_CI_ID = AG.LM_CI_ID AND A.EFFDT = AG.EFFDT AND AG.LM_CATG_ID = LV.LM_CATG_ID GROUP BY X.LM_ACT_ID,A.LM_CI_ID

# 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 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP NOT NULL Row Maintainted DateTime

#	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	LM_ROW_MAINT_DTTM	DateTime(26)	TIMESTAMP NOT NULL	Row Maintainted DateTime