LM_SRCH_DTTMV0 (SQL View)	Index Back
Last update for Catg and Act Last update datestamp for Catalog Items and Activities Use this view to get the last update date stamp for all the catalog item and activity related tables.

LM_SRCH_DTTMV0

(SQL View)

Last update for Catg and Act

Last update datestamp for Catalog Items and Activities Use this view to get the last update date stamp for all the catalog item and activity related tables.

SELECT LM_CI_ID , MAX(LM_ROW_MAINT_DTTM) FROM PS_LM_SRCH_DTTMV5 GROUP BY LM_CI_ID

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

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