Operational Data Store Schema Reference

Back Next

DX_ODS_EVENT_STATUS Table

The DX_ODS_EVENT_STATUS table contains information about the status of events that

B2B Data Exchange

processes.

The following table describes the columns and data types of the DX_ODS_EVENT_STATUS table in the Oracle server:

Column Name	data type	Description
EVENT_STATUS_ID*	NUMBERPS(19,0), NOT NULL	Unique identifier for the event status.
EVENT_STATUS_NAME	VARCHAR2(255)	Name of the event status.
ERROR_FLAG	NUMBERPS(1,0), NOT NULL	Indicates whether the event reached an error state.
FINAL_FLAG	NUMBERPS(1,0), NOT NULL	Indicates whether the event reached a final state.
* Primary key. Used in the DX_ODS_EVENT_FACTS table as a foreign key.

The following table describes the columns and data types of the DX_ODS_EVENT_STATUS table in the SQL server:

Column Name	data type	Description
EVENT_STATUS_ID*	NUMBERIC(19,0), NOT NULL	Unique identifier for the event status.
EVENT_STATUS_NAME	VARCHAR(255)	Name of the event status.
ERROR_FLAG	NUMBERIC(1,0), NOT NULL	Indicates whether the event reached an error state.
FINAL_FLAG	NUMBERIC(1,0), NOT NULL	Indicates whether the event reached a final state.
* Primary key. Used in the DX_ODS_EVENT_FACTS table as a foreign key.