PSAPMSGARCHVW (SQL View)	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.

PSAPMSGARCHVW

(SQL View)

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 Name PeopleSoft Field Type Database Column Type Description

1 PUBNODE Character(30) VARCHAR2(30) NOT NULL Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.

2 QUEUENAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSQUEUEDEFN).

3 IBTRANSACTIONID Character(36) VARCHAR2(36) NOT NULL Transaction ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PUBNODE	Character(30)	VARCHAR2(30) NOT NULL	Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
2	QUEUENAME	Character(30)	VARCHAR2(30) NOT NULL	Channel Name (see PSQUEUEDEFN).
3	IBTRANSACTIONID	Character(36)	VARCHAR2(36) NOT NULL	Transaction ID