PSAPMSGARCHPC

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	IBTRANSACTIONID	Character(36)	VARCHAR2(36) NOT NULL	Transaction ID
2	IB_SEGMENTINDEX	Number(4,0)	SMALLINT NOT NULL	IB Segment Index
3	SUBNODE	Character(30)	VARCHAR2(30) NOT NULL	Subscribing Node
4	IB_SENDPUBID	Signed Number(11,0)	DECIMAL(10) NOT NULL	IB Send Publication 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	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation
10	PUBLISHTIMESTAMP	DateTime(26)	TIMESTAMP	Pub/Sub Timestamp
11	TRXTYPE	Character(4)	VARCHAR2(4) NOT NULL	Integration Broker Transaction Type IA=Inbound Asynchronous IS=Inbound Synchronous OA=Outbound Asynchronous OS=Outbound Synchronous
12	IB_OPERATIONNAME	Character(30)	VARCHAR2(30) NOT NULL	Service Operation (see PSOPERATION).
13	VERSIONNAME	Character(30)	VARCHAR2(30) NOT NULL	Service Operation Version
14	IBPUBTRANSACTID	Character(36)	VARCHAR2(36) NOT NULL	Orig Transaction ID
15	CONVERSATIONID	Character(36)	VARCHAR2(36) NOT NULL	Conversation ID
16	CANONICALTRSFRMID	Character(36)	VARCHAR2(36) NOT NULL	Canonical Transform ID
17	INREPLYTOID	Character(36)	VARCHAR2(36) NOT NULL	In Reply To ID
18	ISREQUEST	Number(1,0)	SMALLINT NOT NULL	Is Request
19	ROUTINGDEFNNAME	Character(30)	VARCHAR2(30) NOT NULL	Routing Name
20	PUBCONSTATUS	Number(2,0)	SMALLINT NOT NULL	Publication Contract Status
21	STATUSSTRING	Character(5)	VARCHAR2(5) NOT NULL	Status String
22	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.
23	RETRYCOUNT	Number(10,0)	DECIMAL(10) NOT NULL	Pub/Sub Retry Count
24	MACHINENAME	Character(30)	VARCHAR2(30) NOT NULL	Machine Name
25	SLAVEPROCESSNAME	Character(15)	VARCHAR2(15) NOT NULL	Secondary Process Name
26	IB_SLAVEQUEUED	Number(1,0)	SMALLINT NOT NULL	IB Secondary Queued
27	TUXDOMAIN	Character(30)	VARCHAR2(30) NOT NULL	Tuxedo Domain Name
28	PROCESSID	Signed Number(11,0)	DECIMAL(10) NOT NULL	Process Identifier
29	NRID	Signed Number(11,0)	DECIMAL(10) NOT NULL	Non-Repudiation ID