PSAPMSGARCHPH

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	IBTRANSACTIONID	Character(36)	VARCHAR2(36) NOT NULL	Transaction ID
2	EXTOPERATIONNAME	Character(254)	VARCHAR2(254) NOT NULL	External Service Name
3	IB_OPERATIONNAME	Character(30)	VARCHAR2(30) NOT NULL	Service Operation (see PSOPERATION).
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	CANONICALTRSFRMID	Character(36)	VARCHAR2(36) NOT NULL	Canonical Transform ID
22	PUBSTATUS	Number(2,0)	SMALLINT NOT NULL	Publication Status
23	STATUSSTRING	Character(5)	VARCHAR2(5) NOT NULL	Status String
24	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.
25	RETRYCOUNT	Number(10,0)	DECIMAL(10) NOT NULL	Pub/Sub Retry Count
26	MACHINENAME	Character(30)	VARCHAR2(30) NOT NULL	Machine Name
27	SLAVEPROCESSNAME	Character(15)	VARCHAR2(15) NOT NULL	Secondary Process Name
28	IB_SLAVEQUEUED	Number(1,0)	SMALLINT NOT NULL	IB Secondary Queued
29	TUXDOMAIN	Character(30)	VARCHAR2(30) NOT NULL	Tuxedo Domain Name
30	PROCESSID	Signed Number(11,0)	DECIMAL(10) NOT NULL	Process Identifier
31	PUBROUTINGTRAIL	Character(248)	VARCHAR2(248) NOT NULL	Publication Routing Trail