AMM_ARCH_SC

index back

App Msg Monitor Sub Con View

This view is used to list archived Subscription Contracts in the Application Message Monitor.
SELECT A.PUBNODE , A.QUEUENAME , A.IBTRANSACTIONID , A.IB_OPERATIONNAME , A.VERSIONNAME , A.ACTIONNAME , A.SUBCONSTATUS , A.STATUSSTRING , A.LASTUPDDTTM , A.RETRYCOUNT , A.PROCESSID , A.SUBPROCID , A.TUXDOMAIN FROM PSAPMSGARCHSC A

PeopleSoft Field Name Field Type Column Type Description
PUBNODE Character(30) VARCHAR2(30) NOT NULL Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
QUEUENAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSQUEUEDEFN).
IBTRANSACTIONID Character(36) VARCHAR2(36) NOT NULL Transaction ID
IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
VERSIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation Version
ACTIONNAME Character(30) VARCHAR2(30) NOT NULL Action Name
SUBCONSTATUS Number(2,0) SMALLINT NOT NULL Subscription Contract Status for Application Messaging
STATUSSTRING Character(5) VARCHAR2(5) NOT NULL Status String
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.
RETRYCOUNT Number(10,0) DECIMAL(10) NOT NULL Pub/Sub Retry Count
PROCESSID Signed Number(11,0) DECIMAL(10) NOT NULL Process Identifier
SUBPROCID Number(10,0) DECIMAL(10) NOT NULL Subscription Process ID
TUXDOMAIN Character(30) VARCHAR2(30) NOT NULL Tuxedo Domain Name
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19