LM_SRCH_DTTMVW2 (SQL View)	Index Back
Last update for Programs Use this view to get the last update date stamp for all the program related tables. This view selects the maximum last update time stamp. Also, this view is used on Query LM_SRCH_PRG_PRNT

LM_SRCH_DTTMVW2

(SQL View)

Last update for Programs

Use this view to get the last update date stamp for all the program related tables. This view selects the maximum last update time stamp. Also, this view is used on Query LM_SRCH_PRG_PRNT

SELECT LM_PRG_ID ,MAX(LM_ROW_MAINT_DTTM) FROM PS_LM_SRCH_DTTMVW3 GROUP BY LM_PRG_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.

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_PRG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Program ID is a unique identifier for curriculum and certification Programs.
2	LM_ROW_MAINT_DTTM	DateTime(26)	TIMESTAMP NOT NULL	Row Maintainted DateTime