AMM_ARCH_DETAIL - App Msg Monitor Pub View - PeopleTools Table Reference

AMM_ARCH_DETAIL	index back
App Msg Monitor Pub View

This view is used to list Publications in the Application Message Monitor.

SELECT DISTINCT C.OPRID , A.PUBNODE , A.QUEUENAME , A.IBTRANSACTIONID FROM PSAPMSGARCHPH A , PSAUTHQUEUEMON B , PSOPRCLS C WHERE A.QUEUENAME = B.QUEUENAME AND B.CLASSID = C.OPRCLASS

PeopleSoft Field Name Field Type Column Type Description

OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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

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 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20

PeopleSoft Field Name	Field Type	Column Type	Description
OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
PUBNODE	Character(30)	VARCHAR2(30) NOT NULL	Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from. Prompt Table: PSMSGNODEDEFN
QUEUENAME	Character(30)	VARCHAR2(30) NOT NULL	Channel Name (see PSQUEUEDEFN).
IBTRANSACTIONID	Character(36)	VARCHAR2(36) NOT NULL	Transaction ID