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

EO_EIP_MSG2_VW

(SQL View)

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

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