PSAPMSGPC_VW

index back

SELECT P.IBTRANSACTIONID , P.IB_SEGMENTINDEX , P.SUBNODE , P.IBPUBTRANSACTID , P.PUBNODE , P.IB_OPERATIONNAME , P.QUEUENAME , P.LASTUPDDTTM , H.CREATEDTTM FROM PSAPMSGPUBCON P , PSAPMSGPUBHDR H WHERE P.IBPUBTRANSACTID = H.IBTRANSACTIONID

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
PUBNODECharacter(30)VARCHAR2(30) NOT NULLApplication Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
QUEUENAMECharacter(30)VARCHAR2(30) NOT NULLChannel Name (see PSQUEUEDEFN).
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.
CREATEDTTMDateTime(26)TIMESTAMPDateTime of Query Creation
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19