EO_EIP_ERR_AET (SQL Table)	Index Back
Error Scan/ WF AE Cache Record Cache Record for AE Program that scans Subscription Contract Queue and a Staging Header Table (EO_EIP_CTL) for Inbound Data Errors and generates Workflow Notification to the designated users.

EO_EIP_ERR_AET

(SQL Table)

Error Scan/ WF AE Cache Record

Cache Record for AE Program that scans Subscription Contract Queue and a Staging Header Table (EO_EIP_CTL) for Inbound Data Errors and generates Workflow Notification to the designated users.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

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

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

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

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

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

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

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

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

10 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

11 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN

12 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field

13 EIP_DTA_STATUS Character(1) VARCHAR2(1) NOT NULL EIP Dta status
0=New
1=Error
2=Complete
3=In Process
4=Reprocess
5=Incomplete
6=Cancelled
7=Hold

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PUBNODE	Character(30)	VARCHAR2(30) NOT NULL	Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
3	CHNLNAME	Character(30)	VARCHAR2(30) NOT NULL	Channel Name (see PSCHNLDEFN).
4	PUBID	Signed Number(11,0)	DECIMAL(10) NOT NULL	Publication Identifier
5	MSGNAME	Character(30)	VARCHAR2(30) NOT NULL	Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
6	SUBNAME	Character(30)	VARCHAR2(30) NOT NULL	Name of a Subscription, which defines which subscription process is invoked when you receive an application message.
7	STATUSSTRING	Character(5)	VARCHAR2(5) NOT NULL	Status String
8	SUBCONSTATUS	Number(2,0)	SMALLINT NOT NULL	Subscription Contract Status for Application Messaging
9	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.
10	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
11	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: PSRECDEFN
12	EIP_CTL_ID	Character(25)	VARCHAR2(25) NOT NULL	Enterprise Components EIP (enterprise integration point) control field
13	EIP_DTA_STATUS	Character(1)	VARCHAR2(1) NOT NULL	EIP Dta status 0=New 1=Error 2=Complete 3=In Process 4=Reprocess 5=Incomplete 6=Cancelled 7=Hold