PSIBNWPUBCON_VW

index back

IB Pub Headers


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

PeopleSoft Field NameField TypeColumn TypeDescription
IB_NWREMOTENODECharacter(30)VARCHAR2(30) NOT NULLIb Network Remote Node Name
IBTRANSACTIONIDCharacter(36)VARCHAR2(36) NOT NULLTransaction ID
IB_SEGMENTINDEXNumber(4,0)SMALLINT NOT NULLIB Segment Index
SUBNODECharacter(30)VARCHAR2(30) NOT NULLSubscribing Node
IB_SENDPUBIDSigned Number(11,0)DECIMAL(10) NOT NULLIB Send Publication ID
SUBQUEUECharacter(60)VARCHAR2(60) NOT NULLSub Queue
IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
VERSIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation Version
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.
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
PUBCONSTATUSNumber(2,0)SMALLINT NOT NULLPublication Contract 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
IBPUBTRANSACTIDCharacter(36)VARCHAR2(36) NOT NULLOrig Transaction ID
ACTIONNAMECharacter(30)VARCHAR2(30) NOT NULLAction Name
ROUTINGDEFNNAMECharacter(30)VARCHAR2(30) NOT NULLRouting Name
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