LM_SRCH_DTTMV1 (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_DTTMV1

(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 V3.LM_ACT_ID , V3.LM_CI_ID , MAX(V3.LM_ROW_MAINT_DTTM) FROM PS_LM_SRCH_DTTMV3 V3 GROUP BY V3.LM_ACT_ID , V3.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