PSAPMSGARCHVW

index back

App Message Archive View

This is a view used by the App Messaging Archive process. It lists all publications that have been processed completely and can be archived, that is messages that have status of "Done". It does not archive messages with status of "Cancelled." See PSAPMSGMNARCHVW also, which is used by the App Message Monitor. The App Message Monitor can be used to archive "Cancelled" messages.
SELECT A.PUBNODE , A.QUEUENAME , A.IBTRANSACTIONID FROM PSAPMSGPUBHDR A

PeopleSoft Field NameField TypeColumn TypeDescription
PUBNODECharacter(30)VARCHAR2(30) NOT NULLApplication Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
QUEUENAMECharacter(30)VARCHAR2(30) NOT NULLChannel Name (see PSQUEUEDEFN).
IBTRANSACTIONIDCharacter(36)VARCHAR2(36) NOT NULLTransaction ID
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19