AMM_ARCH_PUB

index back

App Msg Monitor Pub View

This view is used to list archived Publications in the Application Message Monitor.
SELECT A.PUBNODE , A.QUEUENAME , A.IBTRANSACTIONID , A.EXTOPERATIONNAME , A.PUBSTATUS , A.STATUSSTRING , A.PUBLISHER , A.PUBPROC , A.LASTUPDDTTM FROM PSAPMSGARCHPH 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
EXTOPERATIONNAME Character(254) VARCHAR2(254) NOT NULL External Service Name
PUBSTATUS Number(2,0) SMALLINT NOT NULL Publication Status
STATUSSTRING Character(5) VARCHAR2(5) NOT NULL Status String
PUBLISHER Character(30) VARCHAR2(30) NOT NULL PeopleSoft Operator ID
PUBPROC Character(30) VARCHAR2(30) NOT NULL Publication Process
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.
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19