PSAPMSGPCON_VW

index back

IB Pub Contracts View

Shows publication contracts while hiding the IB_SEGMENTINDEX key of the original table. Only shows the first four keys.
SELECT DISTINCT P.IBPUBTRANSACTID , P.IBTRANSACTIONID , P.SUBNODE , P.PUBNODE , P.QUEUENAME , P.IB_OPERATIONNAME , P.PUBCONSTATUS , P.STATUSSTRING FROM PSAPMSGPUBCON P WHERE P.IB_SEGMENTINDEX = ( SELECT MIN(T.IB_SEGMENTINDEX) FROM PSAPMSGPUBCON T WHERE T.IBTRANSACTIONID = P.IBTRANSACTIONID AND T.PUBCONSTATUS IN (0, 6))

PeopleSoft Field NameField TypeColumn TypeDescription
IBPUBTRANSACTIDCharacter(36)VARCHAR2(36) NOT NULLOrig Transaction ID
IBTRANSACTIONIDCharacter(36)VARCHAR2(36) NOT NULLTransaction ID
SUBNODECharacter(30)VARCHAR2(30) NOT NULLSubscribing Node
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).
IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
PUBCONSTATUSNumber(2,0)SMALLINT NOT NULLPublication Contract Status
STATUSSTRINGCharacter(5)VARCHAR2(5) NOT NULLStatus String
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19