LM_SD_LASTRUNVW (SQL View)	Index Back
Last Search Definitions Runs This view will select the last successful search definition build index process rundate time..

LM_SD_LASTRUNVW

(SQL View)

Last Search Definitions Runs

This view will select the last successful search definition build index process rundate time..

SELECT S.PTSF_SBO_NAME ,%DatePart(MAX(Q.RUNDTTM)) FROM PSPRCSRQST Q , PS_PTSF_SCHEDULE S WHERE Q.RUNSTATUS = '9' AND S.RUN_CNTL_ID = Q.RUNCNTLID GROUP BY S.PTSF_SBO_NAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PTSF_SBO_NAME Character(65) VARCHAR2(65) NOT NULL Search Definition (see PSPTSF_SD).

2 LM_RUNDATE Date(10) DATE Runtime date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTSF_SBO_NAME	Character(65)	VARCHAR2(65) NOT NULL	Search Definition (see PSPTSF_SD).
2	LM_RUNDATE	Date(10)	DATE	Runtime date