SSR_CSIDX_TR1VW (SQL View)	Index Back
Class Search Index Stats Class Search Index Stats by Term

SSR_CSIDX_TR1VW

(SQL View)

Class Search Index Stats

Class Search Index Stats by Term

SELECT DISTINCT A.STRM , A.LAST_UPDATE_DTTM FROM PS_SSR_CLS_TBL_ES A WHERE A.LAST_UPDATE_DTTM = ( SELECT MAX(A2.LAST_UPDATE_DTTM) FROM PS_SSR_CLS_TBL_ES A2 WHERE A2.STRM = A.STRM)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 STRM Character(4) VARCHAR2(4) NOT NULL Term

2 SSR_LAST_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date & Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	STRM	Character(4)	VARCHAR2(4) NOT NULL	Term
2	SSR_LAST_UPD_DTTM	DateTime(26)	TIMESTAMP	Last Update Date & Time