PSIBPUBHDR_VW

index back

IB Pub Headers


SELECT DISTINCT A.IBTRANSACTIONID , A.PUBNODE , A.PUBSTATUS , A.QUEUENAME , A.EXTOPERATIONNAME , A.IB_OPERATIONNAME , A.SUBQUEUE , A.NRID , A.LASTUPDDTTM , A.PUBLISHTIMESTAMP , A.CREATEDTTM , A.ORIGPUBNODE , A.CONVERSATIONID FROM PSAPMSGPUBHDR A

PeopleSoft Field NameField TypeColumn TypeDescription
IBTRANSACTIONIDCharacter(36)VARCHAR2(36) NOT NULLTransaction ID
PUBNODECharacter(30)VARCHAR2(30) NOT NULLApplication Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
PUBSTATUSNumber(2,0)SMALLINT NOT NULLPublication Status
QUEUENAMECharacter(30)VARCHAR2(30) NOT NULLChannel Name (see PSQUEUEDEFN).
EXTOPERATIONNAMECharacter(254)VARCHAR2(254) NOT NULLExternal Service Name
IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
SUBQUEUECharacter(60)VARCHAR2(60) NOT NULLSub Queue
NRIDSigned Number(11,0)DECIMAL(10) NOT NULLNon-Repudiation ID
LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
PUBLISHTIMESTAMPDateTime(26)TIMESTAMPPub/Sub Timestamp
CREATEDTTMDateTime(26)TIMESTAMPDateTime of Query Creation
ORIGPUBNODECharacter(30)VARCHAR2(30) NOT NULLOriginal Publishing Node
CONVERSATIONIDCharacter(36)VARCHAR2(36) NOT NULLConversation ID
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19