EO_EIP_STG_TAO2 (SQL Table)	Index Back
Staging Err Tmp Tbl2 for WF AE This temporary table table is used by Inbound Data Error Scanning AE Program (EO_WF_ERR). Errors from EO_EIP_CTL Table are inserted into this table.

EO_EIP_STG_TAO2

(SQL Table)

Staging Err Tmp Tbl2 for WF AE

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 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

4 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	EIP_CTL_ID	Character(25)	VARCHAR2(25) NOT NULL	Enterprise Components EIP (enterprise integration point) control field
2	EIP_DTA_STATUS	Character(1)	VARCHAR2(1) NOT NULL	EIP Dta status 0=New Transaction 1=Error found on the transaction 2=Complete 3=In Process 4=Reprocess 5=Incomplete 6=Cancelled 7=Hold
3	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
4	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.