PSIBPROF_PUB_VW

index back

SELECT IBTRANSACTIONID , IB_SEGMENTINDEX , SUBNODE , IBPUBTRANSACTID , IB_OPERATIONNAME , QUEUENAME , PUBNODE , ibprofiletimestamp FROM PSIBPROFILEPUB

PeopleSoft Field NameField TypeColumn TypeDescription
IBTRANSACTIONIDCharacter(36)VARCHAR2(36) NOT NULLTransaction ID
IB_SEGMENTINDEXNumber(4,0)SMALLINT NOT NULLIB Segment Index
SUBNODECharacter(30)VARCHAR2(30) NOT NULLSubscribing Node
IBPUBTRANSACTIDCharacter(36)VARCHAR2(36) NOT NULLOrig Transaction ID
IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
QUEUENAMECharacter(30)VARCHAR2(30) NOT NULLChannel Name (see PSQUEUEDEFN).
PUBNODECharacter(30)VARCHAR2(30) NOT NULLApplication Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
IBPROFILETIMESTAMPDateTime(26)TIMESTAMPIB Profile Timestamp
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19