PSAPMSGSCON_VW

index back

SELECT DISTINCT S.IBPUBTRANSACTID , S.IBTRANSACTIONID , S.PUBNODE , S.QUEUENAME , S.IB_OPERATIONNAME , S.ACTIONNAME , S.SUBCONSTATUS , S.STATUSSTRING FROM PSAPMSGSUBCON S WHERE S.IB_SEGMENTINDEX = ( SELECT MIN(T.IB_SEGMENTINDEX) FROM PSAPMSGSUBCON T WHERE T.IBTRANSACTIONID = S.IBTRANSACTIONID AND T.SUBCONSTATUS IN (0, 6))

PeopleSoft Field NameField TypeColumn TypeDescription
IBPUBTRANSACTIDCharacter(36)VARCHAR2(36) NOT NULLOrig Transaction ID
IBTRANSACTIONIDCharacter(36)VARCHAR2(36) NOT NULLTransaction ID
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).
ACTIONNAMECharacter(30)VARCHAR2(30) NOT NULLAction Name
SUBCONSTATUSNumber(2,0)SMALLINT NOT NULLSubscription Contract Status for Application Messaging
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