EO_EIP_MSG_VW

index back

EIP View over App Msg Subscrib

Enterprise Components EIP (enterprise integration point) view over app message subscription 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 , B.EIP_PROGRAM , B.RECNAME FROM PSAPMSGSUBCON A , PS_EO_EIP_PRG_MSG B WHERE A.IB_OPERATIONNAME = B.MSGNAME

PeopleSoft Field Name Field Type Column Type Description
PUBNODE Character(30) VARCHAR2(30) NOT NULL Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
CHNLNAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSCHNLDEFN).
PUBID Signed Number(11,0) DECIMAL(10) NOT NULL Publication Identifier
MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
SUBNAME Character(30) VARCHAR2(30) NOT NULL Name of a Subscription, which defines which subscription process is invoked when you receive an application message.
STATUSSTRING Character(5) VARCHAR2(5) NOT NULL Status String
SUBCONSTATUS Number(2,0) SMALLINT NOT NULL Subscription Contract Status for Application Messaging
LASTUPDDTTM DateTime(26) TIMESTAMP Specifies 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.
EIP_PROGRAM Character(10) VARCHAR2(10) NOT NULL Enterprise Components EIP (enterprise integration point) program field
601=Consumer Sync
701=BOM Sync
801=Item Revision
901=Item Bus Unit Sync
902=Item Sync
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19