LM_SRCH_DTTMVW5 (SQL View)	Index Back
Last update for Prog Ratings Use this view to get the last update date stamp for all the Program ratings

LM_SRCH_DTTMVW5

(SQL View)

Last update for Prog Ratings

Use this view to get the last update date stamp for all the Program ratings

SELECT LM_PRG_ID , MAX(HCSC_RTG_DATE_STMP) FROM PS_LM_RTG_LRN_XREF WHERE HCSC_RTG_CD = 'LEARNING_RATINGS' AND LM_PRG_ID > 0 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