PSAPMSGSUBCON

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