PSIBPUBCON_VW

 index back

IB Pub Headers


SELECT IBTRANSACTIONID , IB_SEGMENTINDEX , SUBNODE , IB_SENDPUBID , SUBQUEUE , IB_OPERATIONNAME , VERSIONNAME , NRID , LASTUPDDTTM , PUBNODE , PUBCONSTATUS , PUBCONSTATUS , QUEUENAME , QUEUESEQID , IB_OPERATIONNAME , IBPUBTRANSACTID , ' ' , ROUTINGDEFNNAME , CONVERSATIONID FROM PSAPMSGPUBCON

PeopleSoft Field Name Field Type Column Type Description
IBTRANSACTIONID Character(36) VARCHAR2(36) NOT NULL Transaction ID
IB_SEGMENTINDEX Number(4,0) SMALLINT NOT NULL IB Segment Index
SUBNODE Character(30) VARCHAR2(30) NOT NULL Subscribing Node
IB_SENDPUBID Signed Number(11,0) DECIMAL(10) NOT NULL IB Send Publication ID
SUBQUEUE Character(60) VARCHAR2(60) NOT NULL Sub Queue
IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
VERSIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation Version
NRID Signed Number(11,0) DECIMAL(10) NOT NULL Non-Repudiation ID
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.
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
PUBCONSTATUS Number(2,0) SMALLINT NOT NULL Publication Contract 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
IBPUBTRANSACTID Character(36) VARCHAR2(36) NOT NULL Orig Transaction ID
ACTIONNAME Character(30) VARCHAR2(30) NOT NULL Action Name
ROUTINGDEFNNAME Character(30) VARCHAR2(30) NOT NULL Routing Name
CONVERSATIONID Character(36) VARCHAR2(36) NOT NULL Conversation ID
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20