PTRS_DEL_QRYVW (SQL View)	Index Back
Reporting search delete query

PTRS_DEL_QRYVW

(SQL View)

Reporting search delete query

SELECT A.PRCSINSTANCE , A.ENDDTTM , A.URL_LONG_CHAR FROM PS_PTRS_DELETE_TBL A WHERE NOT EXISTS ( SELECT 'X' FROM PSRF_RINFO_TBL B WHERE B.PRCSINSTANCE = A.PRCSINSTANCE)

Parent record: CDM_LIST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 ENDDTTM DateTime(26) TIMESTAMP End Date/Time

3 URL_LONG_CHAR Long Character CLOB URL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PRCSINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	ENDDTTM	DateTime(26)	TIMESTAMP	End Date/Time
3	URL_LONG_CHAR	Long Character	CLOB	URL