PSAPMSGSUBC2_VW

(SQL View)
 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 Name PeopleSoft Field Type Database Column Type Description
1 IBTRANSACTIONID Character(36) VARCHAR2(36) NOT NULL Transaction ID
2 IB_SEGMENTINDEX Number(4,0) SMALLINT NOT NULL IB Segment Index
3 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
4 IBPUBTRANSACTID Character(36) VARCHAR2(36) NOT NULL Orig Transaction ID
5 ACTIONNAME Character(30) VARCHAR2(30) NOT NULL Action Name
6 PUBNODE Character(30) VARCHAR2(30) NOT NULL Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
7 QUEUENAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSQUEUEDEFN).
8 QUEUESEQID Signed Number(11,0) DECIMAL(10) NOT NULL Queue Sequence ID
9 SUBQUEUE Character(60) VARCHAR2(60) NOT NULL Sub Queue
10 TRXTYPE Character(4) VARCHAR2(4) NOT NULL Integration Broker Transaction Type
IA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous
11 VERSIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation Version
12 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation
13 PUBLISHTIMESTAMP DateTime(26) TIMESTAMP Pub/Sub Timestamp
14 ACTIONOWNER Character(30) VARCHAR2(30) NOT NULL Action Owner
15 CONVERSATIONID Character(36) VARCHAR2(36) NOT NULL Conversation ID
16 INREPLYTOID Character(36) VARCHAR2(36) NOT NULL In Reply To ID
17 ISREQUEST Number(1,0) SMALLINT NOT NULL Is Request
18 ROUTINGDEFNNAME Character(30) VARCHAR2(30) NOT NULL Routing Name
19 SUBCONSTATUS Number(2,0) SMALLINT NOT NULL Subscription Contract Status for Application Messaging
20 STATUSSTRING Character(5) VARCHAR2(5) NOT NULL Status String
21 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies 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.
22 RETRYCOUNT Number(10,0) DECIMAL(10) NOT NULL Pub/Sub Retry Count
23 MACHINENAME Character(30) VARCHAR2(30) NOT NULL Machine Name
24 SLAVEPROCESSNAME Character(15) VARCHAR2(15) NOT NULL Secondary Process Name
25 IB_SLAVEQUEUED Number(1,0) SMALLINT NOT NULL IB Secondary Queued
26 TUXDOMAIN Character(30) VARCHAR2(30) NOT NULL Tuxedo Domain Name
27 PROCESSID Signed Number(11,0) DECIMAL(10) NOT NULL Process Identifier