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 Name Field Type Column Type Description
IBTRANSACTIONID Character(36) VARCHAR2(36) NOT NULL Transaction ID
PUBNODE Character(30) VARCHAR2(30) NOT NULL Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
PUBSTATUS Number(2,0) SMALLINT NOT NULL Publication Status
QUEUENAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSQUEUEDEFN).
QUEUESEQID Signed Number(11,0) DECIMAL(10) NOT NULL Queue Sequence ID
EXTOPERATIONNAME Character(254) VARCHAR2(254) NOT NULL External Service Name
SUBQUEUE Character(60) VARCHAR2(60) NOT NULL Sub Queue
NRID Signed Number(11,0) DECIMAL(10) NOT NULL Non-Repudiation ID
PUBLISHTIMESTAMP DateTime(26) TIMESTAMP Pub/Sub Timestamp
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.
IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
VERSIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation Version
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19