EO_EIP_MSG_VW (SQL View)	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

EO_EIP_MSG_VW

(SQL View)

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 PeopleSoft Field Type Database Column Type Description

1 PUBNODE Character(30) VARCHAR2(30) NOT NULL Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.

2 CHNLNAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSCHNLDEFN).

3 PUBID Signed Number(11,0) DECIMAL(10) NOT NULL Publication Identifier

4 MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).

5 SUBNAME Character(30) VARCHAR2(30) NOT NULL Name of a Subscription, which defines which subscription process is invoked when you receive an application message.

6 STATUSSTRING Character(5) VARCHAR2(5) NOT NULL Status String

7 SUBCONSTATUS Number(2,0) SMALLINT NOT NULL Subscription Contract Status for Application Messaging

8 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.

9 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

10 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PUBNODE	Character(30)	VARCHAR2(30) NOT NULL	Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
2	CHNLNAME	Character(30)	VARCHAR2(30) NOT NULL	Channel Name (see PSCHNLDEFN).
3	PUBID	Signed Number(11,0)	DECIMAL(10) NOT NULL	Publication Identifier
4	MSGNAME	Character(30)	VARCHAR2(30) NOT NULL	Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
5	SUBNAME	Character(30)	VARCHAR2(30) NOT NULL	Name of a Subscription, which defines which subscription process is invoked when you receive an application message.
6	STATUSSTRING	Character(5)	VARCHAR2(5) NOT NULL	Status String
7	SUBCONSTATUS	Number(2,0)	SMALLINT NOT NULL	Subscription Contract Status for Application Messaging
8	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.
9	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
10	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).