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 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
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).
ACTIONNAME Character(30) VARCHAR2(30) NOT NULL Action Name
SUBCONSTATUS Number(2,0) SMALLINT NOT NULL Subscription Contract Status for Application Messaging
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