AMM_DETAIL_SRCH (SQL View)	Index Back
App Msg Monitor Pub View This view is used to list Publications in the Application Message Monitor.

AMM_DETAIL_SRCH

(SQL View)

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

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

2 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

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

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

5 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	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
3	QUEUENAME	Character(30)	VARCHAR2(30) NOT NULL	Channel Name (see PSQUEUEDEFN).
4	IBTRANSACTIONID	Character(36)	VARCHAR2(36) NOT NULL	Transaction ID
5	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.