Operational Data Store Schema Reference

10.2.1
- 10.5.3
- 10.5.0
- 10.4.0
- 10.2.3
- 10.2.2 HotFix 1
- 10.2.2
- 10.2

Back Next

DX_ODS_CUSTOM_FACTS Table

The DX_ODS_CUSTOM_FACTS table contains information about values of event attributes that you select from the Operation Console to use in reports. The attribute values may represent any numeric data that you want to aggregate and use in custom Dashboard panels.

Oracle Server DX_ODS_CUSTOM_FACTS Table

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

Column Name	data type	Description
FACT_ROW_ID*	NUMBERPS(38,0), NOT NULL	Numeric identifier for the row that contains aggregated information for the custom event attribute.
EVENT_ATTRIBUTE_ID*	NUMBERPS(19,0), NOT NULL	Unique identifier for the event attribute to use in reports.
TIMESLICE	CHAR(10), NOT NULL	Start date and time of the interval during which B2B Data Exchange processed events for each time frame.
VALUE_SUM	NUMBER(8), NOT NULL	Total sum of the custom event attribute values that B2B Data Exchange processed during the time frame. For example, 2,000,000 is the total amount in dollars of insurance claims that B2B Data Exchange processed in one day.
VALUE_COUNT	NUMBER(8), NOT NULL	Total number of the custom event attribute values that B2B Data Exchange processed during the time frame. For example, B2B Data Exchange processed 10,000 insurance claims in one day.
VALUE_MIN	NUMBER(8), NOT NULL	Lowest value that B2B Data Exchange processed during the time frame. For example, $5,000 is the lowest insurance claim in dollars that B2B Data Exchange processed in one day.
VALUE_MAX	NUMBER(8), NOT NULL	Highest value that B2B Data Exchange processed during the time frame. For example, $500,000 is the highest insurance claim in dollars that B2B Data Exchange processed in one day.
* Primary key.

SQL Server DX_ODS_CUSTOM_FACTS Table

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

Column Name	data type	Description
FACT_ROW_ID*	NUMERIC(38,0), NOT NULL	Numeric identifier for the row that contains aggregated information for the custom event attribute.
EVENT_ATTRIBUTE_ID*	NUMERIC(19,0), NOT NULL	Unique identifier for the event attribute to use in reports.
TIMESLICE	DATETIME2, NOT NULL	Start date and time of the interval during which B2B Data Exchange processed events for each time frame.
VALUE_SUM	FLOAT, NOT NULL	Total sum of the custom event attribute values that B2B Data Exchange processed during the time frame. For example, 2,000,000 is the total amount in dollars of insurance claims that B2B Data Exchange processed in one day.
VALUE_COUNT	FLOAT, NOT NULL	Total number of the custom event attribute values that B2B Data Exchange processed during the time frame. For example, B2B Data Exchange processed 10,000 insurance claims in one day.
VALUE_MIN	FLOAT, NOT NULL	Lowest value that B2B Data Exchange processed during the time frame. For example, $5,000 is the lowest insurance claim in dollars that B2B Data Exchange processed in one day.
VALUE_MAX	FLOAT, NOT NULL	Highest value that B2B Data Exchange processed during the time frame. For example, $500,000 is the highest insurance claim in dollars that B2B Data Exchange processed in one day.
* Primary key.

Rename Saved Search

Table of Contents

Operational Data Store Schema Reference

Operational Data Store Schema Reference

DX_ODS_CUSTOM_FACTS Table

DX_ODS_CUSTOM_FACTS Table

Oracle Server DX_ODS_CUSTOM_FACTS Table

SQL Server DX_ODS_CUSTOM_FACTS Table