PSIBTTLOGHDR_VW

(SQL View)
 Index Back

PS Integration Network


SELECT IB_NWREMOTENODE , GUID , IB_OPERATIONNAME , VERSIONNAME , TRXTYPE , PUBNODE , PUBLISHER , PUBLISHTIMESTAMP , LASTUPDDTTM , NRID , DESTPUBNODE , FINALDESTNODE , STATUSSTRING , PUBROUTINGTRAIL FROM PSIBTTLOGHDR

# 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 GUID Character(36) VARCHAR2(36) NOT NULL Unique Identifier
3 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
4 VERSIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation Version
5 TRXTYPE Character(4) VARCHAR2(4) NOT NULL Integration Broker Transaction Type
IA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous
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 PUBLISHER Character(30) VARCHAR2(30) NOT NULL PeopleSoft Operator ID
8 PUBLISHTIMESTAMP DateTime(26) TIMESTAMP Pub/Sub Timestamp
9 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.
10 NRID Signed Number(11,0) DECIMAL(10) NOT NULL Non-Repudiation ID
11 DESTPUBNODE Character(248) VARCHAR2(248) NOT NULL Destination Publish Node
12 FINALDESTNODE Character(30) VARCHAR2(30) NOT NULL Final Destination Node
13 STATUSSTRING Character(5) VARCHAR2(5) NOT NULL Status String
14 PUBROUTINGTRAIL Character(248) VARCHAR2(248) NOT NULL Publication Routing Trail