PSAPMSGSUBC2_VW

index back

SELECT A.IBTRANSACTIONID , A.IB_SEGMENTINDEX , A.IB_OPERATIONNAME , A.IBPUBTRANSACTID , A.ACTIONNAME , A.PUBNODE , A.QUEUENAME , A.QUEUESEQID , A.SUBQUEUE , A.TRXTYPE , A.VERSIONNAME , A.CREATEDTTM , A.PUBLISHTIMESTAMP , A.ACTIONOWNER , A.CONVERSATIONID , A.INREPLYTOID , A.ISREQUEST , A.ROUTINGDEFNNAME , A.SUBCONSTATUS , A.STATUSSTRING , A.LASTUPDDTTM , A.RETRYCOUNT , A.MACHINENAME , A.SLAVEPROCESSNAME , A.IB_SLAVEQUEUED , A.TUXDOMAIN , A.PROCESSID FROM PSAPMSGSUBCON A , PSAPMSGARCHTMP3 B WHERE A.IBPUBTRANSACTID = B.IBTRANSACTIONID AND B.SELECT_FLAG = 'Y'

PeopleSoft Field NameField TypeColumn TypeDescription
IBTRANSACTIONIDCharacter(36)VARCHAR2(36) NOT NULLTransaction ID
IB_SEGMENTINDEXNumber(4,0)SMALLINT NOT NULLIB Segment Index
IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
IBPUBTRANSACTIDCharacter(36)VARCHAR2(36) NOT NULLOrig Transaction ID
ACTIONNAMECharacter(30)VARCHAR2(30) NOT NULLAction Name
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).
QUEUESEQIDSigned Number(11,0)DECIMAL(10) NOT NULLQueue Sequence ID
SUBQUEUECharacter(60)VARCHAR2(60) NOT NULLSub Queue
TRXTYPECharacter(4)VARCHAR2(4) NOT NULLIntegration Broker Transaction Type
IA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous
VERSIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation Version
CREATEDTTMDateTime(26)TIMESTAMPDateTime of Query Creation
PUBLISHTIMESTAMPDateTime(26)TIMESTAMPPub/Sub Timestamp
ACTIONOWNERCharacter(30)VARCHAR2(30) NOT NULLAction Owner
CONVERSATIONIDCharacter(36)VARCHAR2(36) NOT NULLConversation ID
INREPLYTOIDCharacter(36)VARCHAR2(36) NOT NULLIn Reply To ID
ISREQUESTNumber(1,0)SMALLINT NOT NULLIs Request
ROUTINGDEFNNAMECharacter(30)VARCHAR2(30) NOT NULLRouting Name
SUBCONSTATUSNumber(2,0)SMALLINT NOT NULLSubscription Contract Status for Application Messaging
STATUSSTRINGCharacter(5)VARCHAR2(5) NOT NULLStatus String
LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
RETRYCOUNTNumber(10,0)DECIMAL(10) NOT NULLPub/Sub Retry Count
MACHINENAMECharacter(30)VARCHAR2(30) NOT NULLMachine Name
SLAVEPROCESSNAMECharacter(15)VARCHAR2(15) NOT NULLSlave Process Name
IB_SLAVEQUEUEDNumber(1,0)SMALLINT NOT NULLIB Slave Queued
TUXDOMAINCharacter(30)VARCHAR2(30) NOT NULLTuxedo Domain Name
PROCESSIDSigned Number(11,0)DECIMAL(10) NOT NULLProcess Identifier
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19