PSAPMSGPUBC2_VW(SQL View) |
Index Back |
---|---|
IB Network Pub Con |
SELECT A.IBTRANSACTIONID , A.IB_SEGMENTINDEX , A.SUBNODE , A.IBPUBTRANSACTID , A.IB_SENDPUBID , A.PUBNODE , A.QUEUENAME , A.QUEUESEQID , A.SUBQUEUE , A.CREATEDTTM , A.PUBLISHTIMESTAMP , A.TRXTYPE , A.IB_OPERATIONNAME , A.VERSIONNAME , A.CONVERSATIONID , A.CANONICALTRSFRMID , A.INREPLYTOID , A.ISREQUEST , A.ROUTINGDEFNNAME , A.PUBCONSTATUS , A.STATUSSTRING , A.LASTUPDDTTM , A.RETRYCOUNT , A.MACHINENAME , A.SLAVEPROCESSNAME , A.IB_SLAVEQUEUED , A.TUXDOMAIN , A.PROCESSID , A.NRID FROM PSAPMSGPUBCON 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 | SUBNODE | Character(30) | VARCHAR2(30) NOT NULL | Subscribing Node |
4 | IBPUBTRANSACTID | Character(36) | VARCHAR2(36) NOT NULL | Orig Transaction ID |
5 | IB_SENDPUBID | Signed Number(11,0) | DECIMAL(10) NOT NULL | IB Send Publication ID |
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 Channel |
10 | CREATEDTTM | DateTime(26) | TIMESTAMP | DateTime of Query Creation |
11 | PUBLISHTIMESTAMP | DateTime(26) | TIMESTAMP | Pub/Sub Timestamp |
12 | TRXTYPE | Character(4) | VARCHAR2(4) NOT NULL |
Integration Broker Transaction Type
IA=Inbound Asynchronous IS=Inbound Synchronous OA=Outbound Asynchronous OS=Outbound Synchronous |
13 | IB_OPERATIONNAME | Character(30) | VARCHAR2(30) NOT NULL | Service Operation (see PSOPERATION). |
14 | VERSIONNAME | Character(30) | VARCHAR2(30) NOT NULL | Service Operation Version |
15 | CONVERSATIONID | Character(36) | VARCHAR2(36) NOT NULL | Conversation ID |
16 | CANONICALTRSFRMID | Character(36) | VARCHAR2(36) NOT NULL | Canonical Transform ID |
17 | INREPLYTOID | Character(36) | VARCHAR2(36) NOT NULL | In Reply To ID |
18 | ISREQUEST | Number(1,0) | SMALLINT NOT NULL | Is Request |
19 | ROUTINGDEFNNAME | Character(30) | VARCHAR2(30) NOT NULL | Routing Name |
20 | PUBCONSTATUS | Number(2,0) | SMALLINT NOT NULL | Publication Contract Status |
21 | STATUSSTRING | Character(5) | VARCHAR2(5) NOT NULL | Status String |
22 | 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. |
23 | RETRYCOUNT | Number(10,0) | DECIMAL(10) NOT NULL | Pub/Sub Retry Count |
24 | MACHINENAME | Character(30) | VARCHAR2(30) NOT NULL | Machine Name |
25 | SLAVEPROCESSNAME | Character(15) | VARCHAR2(15) NOT NULL | Secondary Process Name |
26 | IB_SLAVEQUEUED | Number(1,0) | SMALLINT NOT NULL | IB Secondary Queued |
27 | TUXDOMAIN | Character(30) | VARCHAR2(30) NOT NULL | Tuxedo Domain Name |
28 | PROCESSID | Signed Number(11,0) | DECIMAL(10) NOT NULL | Process Identifier |
29 | NRID | Signed Number(11,0) | DECIMAL(10) NOT NULL | Non-Repudiation ID |