|
|
|
|
|
|
The Date Dimension table contains data for dates.
Field Name |
Data Type |
Description/Example |
Date_Key |
integer |
Primary Key |
Date_Val |
date |
Date in 'mm/dd/yyyy' format |
Full_Date_Description |
varchar(18) |
Description of the Date e.g. January 1, 2000 |
Day_of_Week |
varchar(9) |
Calendar year of the Date e.g. 2001 |
Day_Number_in_Calendar_Month |
integer |
Calendar Month of the Date (1-12) e.g. 9 for September |
Day_Number_in_Calendar_Year |
integer |
The day number in the month (1-31) e.g. 21 for 21st of any month. |
Day_Number_in_Fiscal_Month |
integer |
|
Day_Number_in_Fiscal_Year |
integer |
|
Last_Day_in_Week_Indicator |
integer |
|
Last_Day_in_Month_Indicator |
integer |
|
Calendar_Week_Number_in_Year |
integer |
|
Calendar_Month_Name |
varchar(9) |
|
Calendar_Month_Number_in_Year |
integer |
|
Calendar_Year_Month |
char(7) |
|
Calendar_Quarter |
integer |
|
Calendar_Year_Quarter |
char(7) |
|
Calendar_Half_Year |
integer |
|
Calendar_Year |
integer |
|
Holiday_Indicator |
varchar(10) |
|
Weekday_Indicator |
char(7) |
|