|
|
|
|
|
|
The Date Dimension table contains data for 1,828 dates for the years 2000-2004. It is generated from a file containing correct date/time data.
Column Name |
Data Type |
Description/Example |
Date_Key |
integer |
1 |
Date |
date |
01/01/2000 |
Full_Date_Description |
varchar(18) |
January 1, 2000 |
Day_of_Week |
varchar(9) |
Sunday |
Day_Number_in_Calendar_Month |
integer |
1 |
Day_Number_in_Calendar_Year |
integer |
1 |
Day_Number_in_Fiscal_Month |
integer |
1 |
Day_Number_in_Fiscal_Year |
integer |
1 |
Last_Day_in_Week_Indicator |
integer |
1 |
Last_Day_in_Month_Indicator |
integer |
0 |
Calendar_Week_Number_in_Year |
integer |
52 |
Calendar_Month_Name |
varchar(9) |
January |
Calendar_Month_Number_in_Year |
integer |
1 |
Calendar_Year_Month |
char(7) |
2000-1 |
Calendar_Quarter |
integer |
1 |
Calendar_Year_Quarter |
char(7) |
2000-Q1 |
Calendar_Half_Year |
integer |
1 |
Calendar_Year |
integer |
2000 |
Holiday_Indicator |
varchar(10) |
Holiday |
Weekday_Indicator |
char(7) |
Weekend |
Selling_Season |
varchar(32) |
ValentinesDay |