AMM_PUBLIST

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

Prompt Table: PSMSGNODEDEFN

QUEUENAMECharacter(30)VARCHAR2(30) NOT NULLChannel Name (see PSQUEUEDEFN).
IBTRANSACTIONIDCharacter(36)VARCHAR2(36) NOT NULLTransaction ID
SUBQUEUECharacter(60)VARCHAR2(60) NOT NULLSub Queue
EXTOPERATIONNAMECharacter(254)VARCHAR2(254) NOT NULLExternal Service Name
PUBSTATUSNumber(2,0)SMALLINT NOT NULLPublication Status
STATUSSTRINGCharacter(5)VARCHAR2(5) NOT NULLStatus String
PUBLISHERCharacter(30)VARCHAR2(30) NOT NULLPeopleSoft Operator ID
PUBPROCCharacter(30)VARCHAR2(30) NOT NULLPublication Process
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.
NRIDSigned Number(11,0)DECIMAL(10) NOT NULLNon-Repudiation 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