PSAPMSGSUBCN_VW

Platform

View Text

Default

SELECT IBTRANSACTIONID , IB_SEGMENTINDEX , IB_OPERATIONNAME , IBPUBTRANSACTID , ACTIONNAME , PUBNODE , QUEUENAME , QUEUESEQID , SUBQUEUE , TRXTYPE , VERSIONNAME , CREATEDTTM , PUBLISHTIMESTAMP , ACTIONOWNER , CONVERSATIONID , INREPLYTOID , ISREQUEST , ROUTINGDEFNNAME , SUBCONSTATUS , STATUSSTRING , LASTUPDDTTM , RETRYCOUNT , MACHINENAME , SLAVEPROCESSNAME , IB_SLAVEQUEUED , TUXDOMAIN , PROCESSID FROM PSAPMSGSUBCON

PeopleSoft Field Name	Description
IBTRANSACTIONID	Transaction ID
IB_SEGMENTINDEX	IB Segment Index
IB_OPERATIONNAME	Service Operation
IBPUBTRANSACTID	Orig Transaction ID
ACTIONNAME	Action Name
PUBNODE	Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
QUEUENAME	Channel Name
QUEUESEQID	Queue Sequence ID
SUBQUEUE	Sub Queue
TRXTYPE	Integration Broker Transaction Type IA=Inbound Asynchronous IS=Inbound Synchronous OA=Outbound Asynchronous OS=Outbound Synchronous
VERSIONNAME	Service Operation Version
CREATEDTTM	DateTime of Query Creation
PUBLISHTIMESTAMP	Pub/Sub Timestamp
ACTIONOWNER	Action Owner
CONVERSATIONID	Conversation ID
INREPLYTOID	In Reply To ID
ISREQUEST	Is Request
ROUTINGDEFNNAME	Routing Name
SUBCONSTATUS	Subscription Contract Status for Application Messaging
STATUSSTRING	Status String
LASTUPDDTTM	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.
RETRYCOUNT	Pub/Sub Retry Count
MACHINENAME	Machine Name
SLAVEPROCESSNAME	Slave Process Name
IB_SLAVEQUEUED	IB Slave Queued
TUXDOMAIN	Tuxedo Domain Name
PROCESSID	Process Identifier

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd.  Last updated 24 July 2010