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 NameField TypeColumn TypeDescription
    PRCSINSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
    ENDDTTMDateTime(26)TIMESTAMPEnd Date/Time
    URLCharacter(254)VARCHAR2(254) NOT NULLInternet URL (Universal Resource Locator)
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19