PTFP_IBPHDR_VW

index back

IB Pub Headers for Feeds

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.
SELECT DISTINCT H.IBTRANSACTIONID , H.PUBNODE , H.PUBSTATUS , H.QUEUENAME , H.QUEUESEQID , H.EXTOPERATIONNAME , H.SUBQUEUE , H.NRID , H.PUBLISHTIMESTAMP , H.LASTUPDDTTM , B.IB_OPERATIONNAME , B.VERSIONNAME FROM PSAPMSGPUBHDR H , PSIBRTNGDEFN B , PSMSGNODEDEFN D WHERE D.LOCALDEFAULTFLG = 'Y' AND B.EFF_STATUS = 'A' AND B.SENDERNODENAME = D.MSGNODENAME AND B.RECEIVERNODENAME = 'ATOM' AND B.RTNGTYPE = 'A' AND H.IB_OPERATIONNAME = B.IB_OPERATIONNAME

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).
QUEUESEQIDSigned Number(11,0)DECIMAL(10) NOT NULLQueue Sequence ID
EXTOPERATIONNAMECharacter(254)VARCHAR2(254) NOT NULLExternal Service Name
SUBQUEUECharacter(60)VARCHAR2(60) NOT NULLSub Queue
NRIDSigned Number(11,0)DECIMAL(10) NOT NULLNon-Repudiation ID
PUBLISHTIMESTAMPDateTime(26)TIMESTAMPPub/Sub Timestamp
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.
IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
VERSIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation Version
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19