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 Name Field Type Column Type Description
GUID Character(36) VARCHAR2(36) NOT NULL Unique Identifier
ERRORTIMESTAMP DateTime(26) TIMESTAMP Error Timestamp
SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
PUBNODE Character(30) VARCHAR2(30) NOT NULL Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
IBDATAERRLOC Character(254) VARCHAR2(254) NOT NULL Int Broker Error Location
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19