PTRS_DEL_QRYVW

 index back

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 Field Type Column Type Description
    PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    ENDDTTM DateTime(26) TIMESTAMP End Date/Time
    URL_LONG_CHAR Long Character CLOB URL
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20