AMM_SUBCONLIST

(SQL View)
 Index Back

App Msg Monitor Sub Con View

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

SELECT A.PUBNODE , A.QUEUENAME , A.IBTRANSACTIONID , A.IB_OPERATIONNAME , A.VERSIONNAME , A.ACTIONNAME , A.IB_SEGMENTINDEX , A.SUBQUEUE , A.SUBCONSTATUS , A.STATUSSTRING , A.LASTUPDDTTM , A.RETRYCOUNT , A.PROCESSID , A.SUBPROCID , A.TRXTYPE FROM PSAPMSGSUBCON 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
4 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
5 VERSIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation Version
6 ACTIONNAME Character(30) VARCHAR2(30) NOT NULL Action Name
7 IB_SEGMENTINDEX Number(4,0) SMALLINT NOT NULL IB Segment Index
8 SUBQUEUE Character(60) VARCHAR2(60) NOT NULL Sub Queue
9 SUBCONSTATUS Number(2,0) SMALLINT NOT NULL Subscription Contract Status for Application Messaging
10 STATUSSTRING Character(5) VARCHAR2(5) NOT NULL Status String
11 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.
12 RETRYCOUNT Number(10,0) DECIMAL(10) NOT NULL Pub/Sub Retry Count
13 PROCESSID Signed Number(11,0) DECIMAL(10) NOT NULL Process Identifier
14 SUBPROCID Number(10,0) DECIMAL(10) NOT NULL Subscription Process ID
15 TRXTYPE Character(4) VARCHAR2(4) NOT NULL Integration Broker Transaction Type
IA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous