PSAPMSGPCON_VW

Return to Index

Shows publication contracts while hiding the IB_SEGMENTINDEX key of the original table. Only shows the first four keys.

PlatformView Text
DefaultSELECT 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 NameDescription
IBPUBTRANSACTIDOrig Transaction ID
IBTRANSACTIONIDTransaction ID
SUBNODESubscribing Node
PUBNODEApplication Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
QUEUENAMEChannel Name
IB_OPERATIONNAMEService Operation
PUBCONSTATUSPublication Contract Status
STATUSSTRINGStatus String

Author: PeopleTools

Return to Index

© Go-Faster Consultancy Ltd.  Last updated 24 July 2010