PSAPMSGMNARCHVW

index back

App Msg Monitor Archive View

This is a view used by the App Messaging Monitor Archive process. It lists all publications that have been processed completely and can be archived from the Message Monitor. These are messages that have status of "Done" or "Cancelled." See PSAPMSGARCHVW also, which is used by the AE process APPMSGARCH.
SELECT A.PUBNODE , A.QUEUENAME , A.IBTRANSACTIONID FROM PSAPMSGPUBHDR A

PeopleSoft Field Name Field Type Column Type Description
PUBNODE Character(30) VARCHAR2(30) NOT NULL Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
QUEUENAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSQUEUEDEFN).
IBTRANSACTIONID Character(36) VARCHAR2(36) NOT NULL Transaction ID
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19