PSIBLOGERR_VW

index back

PS Integration Network


SELECT DISTINCT A.GUID , A.ERRORTIMESTAMP , A.SEQNO , A.PUBNODE , A.MESSAGE_SET_NBR , A.MESSAGE_NBR , A.IBDATAERRLOC FROM PSIBLOGERR A , PSAPMSGARCHTMP4 B WHERE A.GUID = B.GUID

PeopleSoft Field NameField TypeColumn TypeDescription
GUIDCharacter(36)VARCHAR2(36) NOT NULLUnique Identifier
ERRORTIMESTAMPDateTime(26)TIMESTAMPError Timestamp
SEQNONumber(5,0)INTEGER NOT NULLSequence Number
PUBNODECharacter(30)VARCHAR2(30) NOT NULLApplication Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
MESSAGE_SET_NBRNumber(5,0)INTEGER NOT NULLMessage Set Number. This field refers to the Message Set Number in the Message Catalog.
MESSAGE_NBRNumber(5,0)INTEGER NOT NULLMessage Number. This field refers to the Message Number in the Message Catalog.
IBDATAERRLOCCharacter(254)VARCHAR2(254) NOT NULLInt Broker Error Location
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19