Operational Data Store Schema Reference

Back Next

DX_ODS_TIME_BREAKDOWN Table

The DX_ODS_TIME_BREAKDOWN table contains information about the time frames during which

B2B Data Exchange

processes events.

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

Column Name	data type	Description
TIMESLICE*	CHAR(10), NOT NULL	Start date and time of the interval during which B2B Data Exchange processed events for each time frame.
SECONDS_FROM_MIDNIGHT	NUMBERPS(5,0), NOT NULL	Number of seconds from the beginning of the calendar day.
WEEK_OF_YEAR	NUMBERPS(2,0), NOT NULL	Number of the week in the calendar year. For example, the first week of January is week 1.
DAY_OF_MONTH	NUMBERPS(2,0), NOT NULL	Calendar date of the day. For example, March 23rd is day 23.
MONTH_OF_YEAR	NUMBERPS(2,0), NOT NULL	Calendar month of the year. For example, June is month 6.
YEAR	NUMBERPS(5,0), NOT NULL	Calendar year, such as 2011.
* Primary key.

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

Column Name	data type	Description
TIMESLICE*	DATETIME2(10), NOT NULL	Start date and time of the interval during which B2B Data Exchange processed events for each time frame.
SECONDS_FROM_MIDNIGHT	NUMBERIC(5,0), NOT NULL	Number of seconds from the beginning of the calendar day.
WEEK_OF_YEAR	NUMBERIC(2,0), NOT NULL	Number of the week in the calendar year. For example, the first week of January is week 1.
DAY_OF_MONTH	NUMBERIC(2,0), NOT NULL	Calendar date of the day. For example, March 23rd is day 23.
MONTH_OF_YEAR	NUMBERIC(2,0), NOT NULL	Calendar month of the year. For example, June is month 6.
YEAR_	NUMBERIC(5,0), NOT NULL	Calendar year, such as 2011.
* Primary key.