Operational Data Store Schema Reference

Back Next

DX_ODS_EVENT_FACTS Table

The DX_ODS_EVENT_FACTS table contains aggregated information about events that

B2B Data Exchange

processes.

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

Column Name	data type	Description
ROW_ID*	NUMBERPS(38,0), NOT NULL	Numeric identifier for the row that contains aggregated information for the events.
TIMESLICE	CHAR(10), NOT NULL	Start date and time of the interval during which B2B Data Exchange processed events for each time frame.
EVENT_TYPE_ID	NUMBERPS(19,0), NOT NULL	Unique identifier for the event type.
EVENT_STATUS_ID	NUMBERPS(19,0), NOT NULL	Unique identifier for the event status.
PARTNER_ID	NUMBERPS(19,0)	Unique identifier for the related partner.
ACCOUNT_ID	NUMBERPS(19,0)	Unique identifier for the related account.
ACCESS_ID*	NUMBERPS(19,0)	Unique identifier for the access role. The identifier is generated and does not represent the access role name in the Operation Console
EVENT_COUNT	NUMBERPS(19,0), NOT NULL	Number of events that B2B Data Exchange processed during the time frame.
TOTAL_PROCESSING_TIME	BINARY_DOUBLE, NOT NULL	Total time that it took for B2B Data Exchange to process all events during the time frame.
MIN_PROCESSING_TIME	BINARY_DOUBLE, NOT NULL	Shortest time in miliseconds that it took for B2B Data Exchange to process an event.
MAX_PROCESSING_TIME	BINARY_DOUBLE, NOT NULL	Longest time in miliseconds that it took for B2B Data Exchange to process an event during the time frame.
TOTAL_DELAYED_TIME	FLOAT(53), NOT NULL	Total delay time in miliseconds for the B2B Data Exchange to process an event during the time frame.
* Primary key.

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

Column Name	data type	Description
ROW_ID*	NUMERIC (38,0), NOT NULL	Numeric identifier for the row that contains aggregated information for the events.
TIMESLICE	DATETIME2, NOT NULL	Start date and time of the interval during which B2B Data Exchange processed events for each time frame.
EVENT_TYPE_ID	NUMERIC(19,0), NOT NULL	Unique identifier for the event type.
EVENT_STATUS_ID	NUMERIC(19,0), NOT NULL	Unique identifier for the event status.
PARTNER_ID	NUMERIC(19,0)	Unique identifier for the related partner.
ACCOUNT_ID	NUMERIC(19,0)	Unique identifier for the related account.
ACCESS_ID*	NUMERIC(19,0)	Unique identifier for the access role. The identifier is generated and does not represent the access role name in the Operation Console
EVENT_COUNT	NUMERIC(19,0), NOT NULL	Number of events that B2B Data Exchange processed during the time frame.
TOTAL_PROCESSING_TIME	FLOAT(53), NOT NULL	Total time that it took for B2B Data Exchange to process all events during the time frame.
MIN_PROCESSING_TIME	FLOAT(53), NOT NULL	Shortest time in miliseconds that it took for B2B Data Exchange to process an event.
MAX_PROCESSING_TIME	FLOAT(53), NOT NULL	Longest time in miliseconds that it took for B2B Data Exchange to process an event during the time frame.
TOTAL_DELAYED_TIME	FLOAT(53), NOT NULL	Total delay time in miliseconds for the B2B Data Exchange to process an event during the time frame.
* Primary key.