AMM_DETAIL_SRCH - App Msg Monitor Pub View - PeopleTools Table Reference

AMM_DETAIL_SRCH	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 , A.LASTUPDDTTM FROM PSAPMSGPUBHDR 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

LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

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
LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.