EO_EIP_MSG_TAO2

(SQL Table)
Index Back

App Msg Err Tmp Tbl2 for WF AE

This temporary table table is used by Inbound Data Error Scanning AE Program (EO_WF_ERR). Errors from PSAPMSGSUBCON Table are inserted into this table.

# 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 SUBCONSTATUS Number(2,0) SMALLINT NOT NULL Subscription Contract Status for Application Messaging
7 STATUSSTRING Character(5) VARCHAR2(5) NOT NULL Status String
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.