PSIBTTSUBCON

#	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	IBTRANSACTIONID	Character(36)	VARCHAR2(36) NOT NULL	Transaction ID
3	IB_SEGMENTINDEX	Number(4,0)	SMALLINT NOT NULL	IB Segment Index
4	IB_OPERATIONNAME	Character(30)	VARCHAR2(30) NOT NULL	Service Operation (see PSOPERATION).
5	ACTIONNAME	Character(30)	VARCHAR2(30) NOT NULL	Action Name
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	QUEUESEQID	Signed Number(11,0)	DECIMAL(10) NOT NULL	Queue Sequence ID
9	SUBQUEUE	Character(60)	VARCHAR2(60) NOT NULL	Sub Queue
10	TRXTYPE	Character(4)	VARCHAR2(4) NOT NULL	Integration Broker Transaction Type IA=Inbound Asynchronous IS=Inbound Synchronous OA=Outbound Asynchronous OS=Outbound Synchronous
11	VERSIONNAME	Character(30)	VARCHAR2(30) NOT NULL	Service Operation Version
12	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation
13	PUBLISHTIMESTAMP	DateTime(26)	TIMESTAMP	Pub/Sub Timestamp
14	ACTIONOWNER	Character(30)	VARCHAR2(30) NOT NULL	Action Owner
15	IBPUBTRANSACTID	Character(36)	VARCHAR2(36) NOT NULL	Orig Transaction ID
16	CONVERSATIONID	Character(36)	VARCHAR2(36) NOT NULL	Conversation ID
17	INREPLYTOID	Character(36)	VARCHAR2(36) NOT NULL	In Reply To ID
18	ISREQUEST	Number(1,0)	SMALLINT NOT NULL	Is Request
19	CANONICALTRSFRMID	Character(36)	VARCHAR2(36) NOT NULL	Canonical Transform ID
20	ROUTINGDEFNNAME	Character(30)	VARCHAR2(30) NOT NULL	Routing Name
21	IB_NOTIF_SEQ	Number(5,0)	INTEGER NOT NULL	Notification Sequence
22	IB_AERESPONSE	Number(1,0)	SMALLINT NOT NULL	AE Respnse
23	SUBPROCID	Number(10,0)	DECIMAL(10) NOT NULL	Subscription Process ID
24	SUBCONSTATUS	Number(2,0)	SMALLINT NOT NULL	Subscription Contract Status for Application Messaging
25	STATUSSTRING	Character(5)	VARCHAR2(5) NOT NULL	Status String
26	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.
27	RETRYCOUNT	Number(10,0)	DECIMAL(10) NOT NULL	Pub/Sub Retry Count
28	MACHINENAME	Character(30)	VARCHAR2(30) NOT NULL	Machine Name
29	SLAVEPROCESSNAME	Character(15)	VARCHAR2(15) NOT NULL	Secondary Process Name
30	IB_SLAVEQUEUED	Number(1,0)	SMALLINT NOT NULL	IB Secondary Queued
31	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
32	TUXDOMAIN	Character(30)	VARCHAR2(30) NOT NULL	Tuxedo Domain Name
33	PROCESSID	Signed Number(11,0)	DECIMAL(10) NOT NULL	Process Identifier