PSIBRELMSGHDR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	IBTRANSACTIONID	Character(36)	VARCHAR2(36) NOT NULL	Transaction ID
2	IB_MSGNUMBER	Number(20,0)	DECIMAL(20) NOT NULL	Message Number
3	EXTOPERATIONNAME	Character(254)	VARCHAR2(254) NOT NULL	External Service Name
4	IB_OPERATIONNAME	Character(30)	VARCHAR2(30) NOT NULL	Service Operation (see PSOPERATION).
5	EXTERNALMESSAGEID	Character(70)	VARCHAR2(70) NOT NULL	External Message 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	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	NRID	Signed Number(11,0)	DECIMAL(10) NOT NULL	Non-Repudiation ID
16	DESTPUBNODE	Character(248)	VARCHAR2(248) NOT NULL	Destination Publish Node
17	ISREQUEST	Number(1,0)	SMALLINT NOT NULL	Is Request