AMM_SUBCONLIST

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 NameField TypeColumn TypeDescription
PUBNODECharacter(30)VARCHAR2(30) NOT NULLApplication Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
QUEUENAMECharacter(30)VARCHAR2(30) NOT NULLChannel Name (see PSQUEUEDEFN).
IBTRANSACTIONIDCharacter(36)VARCHAR2(36) NOT NULLTransaction ID
IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
VERSIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation Version
ACTIONNAMECharacter(30)VARCHAR2(30) NOT NULLAction Name
IB_SEGMENTINDEXNumber(4,0)SMALLINT NOT NULLIB Segment Index
SUBQUEUECharacter(60)VARCHAR2(60) NOT NULLSub Queue
SUBCONSTATUSNumber(2,0)SMALLINT NOT NULLSubscription Contract Status for Application Messaging
STATUSSTRINGCharacter(5)VARCHAR2(5) NOT NULLStatus String
LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
RETRYCOUNTNumber(10,0)DECIMAL(10) NOT NULLPub/Sub Retry Count
PROCESSIDSigned Number(11,0)DECIMAL(10) NOT NULLProcess Identifier
SUBPROCIDNumber(10,0)DECIMAL(10) NOT NULLSubscription Process ID
TRXTYPECharacter(4)VARCHAR2(4) NOT NULLIntegration Broker Transaction Type
IA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19