EVENT_DATE Dimension
The EVENT_DATE dimension is a static dimension that stores information about dates. The ETL Initialize job populates this table determining date values from your system’s locale settings.
Field | Data Type | Description |
---|---|---|
EVENT_DATE_KEY | int | Primary key of this table. |
EVENT_DATE | datetime | Date of the event in “YYYY-M-D 0:0:0.0” format. |
DAY_NAME | nvarchar(32) | Text name of the day (“Monday”, “Tuesday”, and so on). |
DAY_NUM_IN_WEEK | int | Day of the week (1–7). |
DAY_NUM_IN_MONTH | int | Day of the month (1–31). |
DAY_NUM_IN_YEAR | int | Day of the year (1–366). |
WEEK_NUM_IN_YEAR | int | Week number of the year (1–53). |
WEEK_START_DATE | datetime | Date of the first day of the week in “YYYY-M-D 0:0:0. 0” format. |
WEEK_END_DATE | datetime | Date of the last day of the week in “YYYY-M-D 0:0:0. 0” format. |
MONTH_NAME | nvarchar(32) | Text name of the month—for example, “January”. |
MONTH_NUM_IN_YEAR | int | Month of the year (1–12). |
QUARTER_NUM_IN_YEAR | int | Quarter (1–4). |
YEAR_NUM | int | Year—for example, 2011. |
EVENT_DATE_STR | nvarchar(10) | String representation of the date in "YYYY-MM-DD" format |
This page was last edited on December 19, 2017, at 10:26.
Comments or questions about this documentation? Contact us for support!