Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| dt_key | int | 4 | null |
|
|
Date key, which is a number representing the date in format YYYYMMDD |
||
| dt_dt | datetime | 16,3 | √ | null |
|
|
Date as a DATETIME data type |
|
| yr_nb | int | 4 | √ | null |
|
|
Year number of the date |
|
| yr_qtr_nb | int | 4 | √ | null |
|
|
Quarter number of the date within the year (1 to 4) |
|
| yr_mo_nb | int | 4 | √ | null |
|
|
Month number of the date within the year (1 to 12) |
|
| yr_wk_nb | int | 4 | √ | null |
|
|
Week number of the date within the year (1 to 53) |
|
| yr_dy_nb | int | 4 | √ | null |
|
|
Day number of the date within the year (1 to 366) |
|
| yr_dy_cnt | int | 4 | √ | null |
|
|
Number of days in the year (365 or 366) |
|
| yr_strt_dt | datetime | 16,3 | √ | null |
|
|
The start date of the year |
|
| yr_end_dt | datetime | 16,3 | √ | null |
|
|
The end date of the year |
|
| yr_end_flg | varchar | 1 | null |
|
|
Whether this date is the last day of the year (T or F) |
||
| yr_end_txt | varchar | 8 | √ | null |
|
|
Whether this date is the last day of the year (‘YEAR END’ or NULL) |
|
| leap_yr_flg | varchar | 1 | null |
|
|
Whether this year is a leap year (T or F) |
||
| leap_year_txt | varchar | 9 | √ | null |
|
|
Whether this year is a leap year (‘LEAP YEAR’ or NULL) |
|
| qtr_mo_nb | int | 4 | √ | null |
|
|
The number of the month within the quarter (1 to 3) |
|
| qtr_wk_nb | int | 4 | √ | null |
|
|
The number of the week within the quarter (1 to 14) |
|
| qtr_dy_nb | int | 4 | √ | null |
|
|
The number of the day within the quarter (1 to 92) |
|
| qtr_strt_dt | datetime | 16,3 | √ | null |
|
|
The start date of the quarter |
|
| qtr_end_dt | datetime | 16,3 | √ | null |
|
|
The end date of the quarter |
|
| qtr_end_flg | varchar | 1 | null |
|
|
Whether this date is the last day of the quarter (T or F) |
||
| qtr_end_txt | varchar | 11 | √ | null |
|
|
Whether this date is the last day of the quarter (‘QUARTER END’ or NULL) |
|
| mo_wk_nb | int | 4 | √ | null |
|
|
The number of the week within the month (1 to 5) |
|
| mo_dy_nb | int | 4 | √ | null |
|
|
The number of the day within the month (1 to 31) |
|
| mo_strt_dt | datetime | 16,3 | √ | null |
|
|
The start date of the month |
|
| mo_end_dt | datetime | 16,3 | √ | null |
|
|
The end date of the month |
|
| mo_end_flg | varchar | 1 | null |
|
|
Whether this date is the last day of the month (T or F) |
||
| mo_end_txt | varchar | 9 | √ | null |
|
|
Whether this date is the last day of the month (‘MONTH END’ or NULL) |
|
| mo_nm | nvarchar | 60 | √ | null |
|
|
Full name of the month (January, February, March, April, May, June, July, August, September, October, November, December) |
|
| mo_abrv_nm | nvarchar | 8000 | √ | null |
|
|
Abbreviated name of the month (Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec) |
|
| wk_dy_nb | int | 4 | √ | null |
|
|
Week day number, with Sunday as the start of the week (1 to 7) |
|
| wk_strt_dt | datetime | 16,3 | √ | null |
|
|
The start date of the week, with Sunday as the start of the week |
|
| wk_end_dt | datetime | 16,3 | √ | null |
|
|
The end date of the week, with Sunday as the start of the week |
|
| wk_end_flg | varchar | 1 | null |
|
|
Whether this date is on the weekend (T or F) |
||
| dy_nm | nvarchar | 60 | √ | null |
|
|
Full name of the day (Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday) |
|
| dy_abrv_nm | nvarchar | 8000 | √ | null |
|
|
Abbreviated name of the day (Sun, Mon, Tues, Wed, Thu, Fri, Sat) |
|
| prev_yr_dt | datetime | 16,3 | √ | null |
|
|
Same date from the prior year |
|
| prev_90_days_dt | datetime | 16,3 | √ | null |
|
|
The date 90 days prior |
|
| prev_60_days_dt | datetime | 16,3 | √ | null |
|
|
The date 60 days prior |
|
| prev_30_days_dt | datetime | 16,3 | √ | null |
|
|
The date 30 days prior |
|
| weekday_flg | varchar | 1 | null |
|
|
Whether this date is a weekday (T or F) |
||
| weekday_txt | varchar | 8 | null |
|
|
Whether this date is a weekday (‘WEEKDAY’ or ‘WEEKEND’) |
||
| dt_yyyymm_txt | varchar | 8 | √ | null |
|
|
The date formatted as YYYYMM |
|
| dt_yyyymmdd_txt | varchar | 8 | √ | null |
|
|
The date formatted as YYYYMMDD |
|
| dt_ddmonyy_txt | nvarchar | 8000 | √ | null |
|
|
The date formatted as DDMONYY |
|
| dt_ddmonyyyy_txt | nvarchar | 8000 | √ | null |
|
|
The date formatted as DDMONYYYY |
|
| mo_nm_fr | varchar | 9 | null |
|
|
Nom complet du mois |
||
| mo_abrv_nm_fr | varchar | 7 | null |
|
|
Nom abrégé du mois |
||
| dy_nm_fr | varchar | 8 | null |
|
|
Nom complet du jour |
||
| dy_abrv_nm_fr | varchar | 7 | null |
|
|
Nom abrégé du jour |
||
| dt_dmy_fr | varchar | 38 | null |
|
|
|||
| dt_dmy_txt_fr | varchar | 35 | null |
|
|
|||
| yr_wk_cal | int | 4 | √ | null |
|
|
North American: week 1 begins on the Sunday of the week of the first day of the year. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__ACTIVE_H__952F07BEB9031C70 | Primary key | Asc | dt_key |
| ACTIVE_HUB_DATES_dt_dt_IX | Performance | Asc | dt_dt |
| ACTIVE_HUB_DATES_yr_nb_dt_dt_IX | Performance | Asc/Asc | yr_nb + dt_dt |
| ACTIVE_HUB_DATES_yr_nb_dt_key_mo_nm_IX | Performance | Asc/Asc/Asc | yr_nb + dt_key + mo_nm |