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 Name Field Type Column Type Description
IBPUBTRANSACTID Character(36) VARCHAR2(36) NOT NULL Orig Transaction ID
IBTRANSACTIONID Character(36) VARCHAR2(36) NOT NULL Transaction ID
SUBNODE Character(30) VARCHAR2(30) NOT NULL Subscribing Node
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).
IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
PUBCONSTATUS Number(2,0) SMALLINT NOT NULL Publication Contract Status
STATUSSTRING Character(5) VARCHAR2(5) NOT NULL Status String
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19