AMM_ARCH_PC

index back

Archived Publication Contracts

This view is used to list archived Publication Contracts in the Integration Broker (Application Message) Monitor.
SELECT A.PUBNODE , A.QUEUENAME , A.IBTRANSACTIONID , A.SUBNODE , A.IB_OPERATIONNAME , A.VERSIONNAME , A.PUBCONSTATUS , A.STATUSSTRING , A.LASTUPDDTTM , A.RETRYCOUNT , A.MACHINENAME , A.TUXDOMAIN , A.PROCESSID FROM PSAPMSGARCHPC 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
SUBNODECharacter(30)VARCHAR2(30) NOT NULLSubscribing Node
IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
VERSIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation Version
PUBCONSTATUSNumber(2,0)SMALLINT NOT NULLPublication Contract Status
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
MACHINENAMECharacter(30)VARCHAR2(30) NOT NULLMachine Name
TUXDOMAINCharacter(30)VARCHAR2(30) NOT NULLTuxedo Domain Name
PROCESSIDSigned Number(11,0)DECIMAL(10) NOT NULLProcess Identifier
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19