EO_EIP_MSG2_VW

index back

EIP View over App Msg Subscrib

Enterprise Components EIP (enterprise integration point) view over app message subsription master file and message define rec file used by EIP Inbound Error Handling utility
SELECT A.PUBNODE , A.QUEUENAME , A.QUEUESEQID , A.IB_OPERATIONNAME , A.ACTIONNAME , A.STATUSSTRING , A.SUBCONSTATUS , A.LASTUPDDTTM FROM PSAPMSGSUBCON A

PeopleSoft Field NameField TypeColumn TypeDescription
PUBNODECharacter(30)VARCHAR2(30) NOT NULLApplication Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
CHNLNAMECharacter(30)VARCHAR2(30) NOT NULLChannel Name (see PSCHNLDEFN).
PUBIDSigned Number(11,0)DECIMAL(10) NOT NULLPublication Identifier
MSGNAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
SUBNAMECharacter(30)VARCHAR2(30) NOT NULLName of a Subscription, which defines which subscription process is invoked when you receive an application message.
STATUSSTRINGCharacter(5)VARCHAR2(5) NOT NULLStatus String
SUBCONSTATUSNumber(2,0)SMALLINT NOT NULLSubscription Contract Status for Application Messaging
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.
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19