PSIBRELMSGHDR

index back

IB Transactions


PeopleSoft Field Name Field Type Column Type Description
IBTRANSACTIONID Character(36) VARCHAR2(36) NOT NULL Transaction ID
IB_MSGNUMBER Number(20,0) DECIMAL(20) NOT NULL Message Number
EXTOPERATIONNAME Character(254) VARCHAR2(254) NOT NULL External Service Name
IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
EXTERNALMESSAGEID Character(70) VARCHAR2(70) NOT NULL External Message ID
PUBNODE Character(30) VARCHAR2(30) NOT NULL Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
QUEUENAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSQUEUEDEFN).
SUBQUEUE Character(60) VARCHAR2(60) NOT NULL Sub Queue
ORIGPUBNODE Character(30) VARCHAR2(30) NOT NULL Original Publishing Node
PUBCLASS Character(30) VARCHAR2(30) NOT NULL Class of publication
PUBLISHER Character(30) VARCHAR2(30) NOT NULL PeopleSoft Operator ID
PUBPROC Character(30) VARCHAR2(30) NOT NULL Publication Process
TRXTYPE Character(4) VARCHAR2(4) NOT NULL Integration Broker Transaction Type
IA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous
CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation
NRID Signed Number(11,0) DECIMAL(10) NOT NULL Non-Repudiation ID
DESTPUBNODE Character(248) VARCHAR2(248) NOT NULL Destination Publish Node
ISREQUEST Number(1,0) SMALLINT NOT NULL Is Request
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20