AMM_PUBLIST

(SQL View)
 Index Back

App Msg Monitor Pub View

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

SELECT A.PUBNODE , A.QUEUENAME , A.IBTRANSACTIONID , A.SUBQUEUE , A.EXTOPERATIONNAME , A.PUBSTATUS , A.STATUSSTRING , A.PUBLISHER , A.PUBPROC , A.LASTUPDDTTM , A.NRID , A.TRXTYPE 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.

Prompt Table: PSMSGNODEDEFN

2 QUEUENAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSQUEUEDEFN).
3 IBTRANSACTIONID Character(36) VARCHAR2(36) NOT NULL Transaction ID
4 SUBQUEUE Character(60) VARCHAR2(60) NOT NULL Sub Queue
5 EXTOPERATIONNAME Character(254) VARCHAR2(254) NOT NULL External Service Name
6 PUBSTATUS Number(2,0) SMALLINT NOT NULL Publication Status
7 STATUSSTRING Character(5) VARCHAR2(5) NOT NULL Status String
8 PUBLISHER Character(30) VARCHAR2(30) NOT NULL PeopleSoft Operator ID
9 PUBPROC Character(30) VARCHAR2(30) NOT NULL Publication Process
10 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.
11 NRID Signed Number(11,0) DECIMAL(10) NOT NULL Non-Repudiation ID
12 TRXTYPE Character(4) VARCHAR2(4) NOT NULL Integration Broker Transaction Type
IA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous