PTRS_DEL_QRYVW

index back

Reporting search delete query


SELECT A.PRCSINSTANCE , A.ENDDTTM , A.URL 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 Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19