PSIBNWPUBHD_VW

(SQL View)
 Index Back

SELECT IB_NWREMOTENODE , IBTRANSACTIONID , EXTOPERATIONNAME , EXTERNALMESSAGEID , PUBNODE , QUEUENAME , QUEUESEQID , SUBQUEUE , ORIGPUBNODE , PUBCLASS , PUBLISHER , PUBPROC , TRXTYPE , CREATEDTTM , PUBLISHTIMESTAMP , NRID , DESTPUBNODE , CONVERSATIONID , INREPLYTOID , ISREQUEST , PUBSTATUS , STATUSSTRING , LASTUPDDTTM , RETRYCOUNT , MACHINENAME , SLAVEPROCESSNAME , IB_SLAVEQUEUED , TUXDOMAIN , PROCESSID , IB_OPERATIONNAME , PUBROUTINGTRAIL FROM PSIBNWPUBHDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 IB_NWREMOTENODE Character(30) VARCHAR2(30) NOT NULL Ib Network Remote Node Name
2 IBPUBTRANSACTID Character(36) VARCHAR2(36) NOT NULL Orig Transaction ID
3 EXTOPERATIONNAME Character(254) VARCHAR2(254) NOT NULL External Service Name
4 EXTERNALMESSAGEID Character(70) VARCHAR2(70) NOT NULL External Message ID
5 PUBNODE Character(30) VARCHAR2(30) NOT NULL Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
6 QUEUENAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSQUEUEDEFN).
7 QUEUESEQID Signed Number(11,0) DECIMAL(10) NOT NULL Queue Sequence ID
8 SUBQUEUE Character(60) VARCHAR2(60) NOT NULL Sub Queue
9 ORIGPUBNODE Character(30) VARCHAR2(30) NOT NULL Original Publishing Node
10 PUBCLASS Character(30) VARCHAR2(30) NOT NULL Class of publication
11 PUBLISHER Character(30) VARCHAR2(30) NOT NULL PeopleSoft Operator ID
12 PUBPROC Character(30) VARCHAR2(30) NOT NULL Publication Process
13 TRXTYPE Character(4) VARCHAR2(4) NOT NULL Integration Broker Transaction Type
IA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous
14 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation
15 PUBLISHTIMESTAMP DateTime(26) TIMESTAMP Pub/Sub Timestamp
16 NRID Signed Number(11,0) DECIMAL(10) NOT NULL Non-Repudiation ID
17 DESTPUBNODE Character(248) VARCHAR2(248) NOT NULL Destination Publish Node
18 CONVERSATIONID Character(36) VARCHAR2(36) NOT NULL Conversation ID
19 INREPLYTOID Character(36) VARCHAR2(36) NOT NULL In Reply To ID
20 ISREQUEST Number(1,0) SMALLINT NOT NULL Is Request
21 PUBSTATUS Number(2,0) SMALLINT NOT NULL Publication Status
22 STATUSSTRING Character(5) VARCHAR2(5) NOT NULL Status String
23 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.
24 RETRYCOUNT Number(10,0) DECIMAL(10) NOT NULL Pub/Sub Retry Count
25 MACHINENAME Character(30) VARCHAR2(30) NOT NULL Machine Name
26 SLAVEPROCESSNAME Character(15) VARCHAR2(15) NOT NULL Secondary Process Name
27 IB_SLAVEQUEUED Number(1,0) SMALLINT NOT NULL IB Secondary Queued
28 TUXDOMAIN Character(30) VARCHAR2(30) NOT NULL Tuxedo Domain Name
29 PROCESSID Signed Number(11,0) DECIMAL(10) NOT NULL Process Identifier
30 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
31 PUBROUTINGTRAIL Character(248) VARCHAR2(248) NOT NULL Publication Routing Trail