PSIBPUBHDR2_VW

Return to Index

Used to allow queries based on Operation and Version from the Publication Headers. Since these two fields are not saved directly, we need a view to indirectly query for them.

PlatformView Text
DefaultSELECT DISTINCT H.IBTRANSACTIONID , H.PUBNODE , H.PUBSTATUS , H.QUEUENAME , H.QUEUESEQID , H.EXTOPERATIONNAME , H.SUBQUEUE , H.NRID , H.LASTUPDDTTM , B.IB_OPERATIONNAME , B.VERSIONNAME FROM PSAPMSGPUBHDR H , PSIBRTNGDEFN B , PSRTNGDFNPARM C WHERE H.EXTOPERATIONNAME = C.ALIASNAME AND C.ROUTINGDEFNNAME = B.ROUTINGDEFNNAME AND C.EFFDT = B.EFFDT

PeopleSoft Field NameDescription
IBTRANSACTIONIDTransaction ID
PUBNODEApplication Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
PUBSTATUSPublication Status
QUEUENAMEChannel Name
QUEUESEQIDQueue Sequence ID
EXTOPERATIONNAMEExternal Service Name
SUBQUEUESub Queue
NRIDNon-Repudiation ID
LASTUPDDTTMSpecifies 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.
IB_OPERATIONNAMEService Operation
VERSIONNAMEService Operation Version

Author: PeopleTools

Return to Index

© Go-Faster Consultancy Ltd.  Last updated 24 July 2010