|
|
|
|
|
|
The Date Dimension table contains data for dates.
Field Name |
Data Type |
Description |
Date_Key |
integer |
Primary Key |
Date |
date |
|
Full_Date_Description |
varchar(18) |
|
Day_of_Week |
varchar(9) |
|
Day_Number_in_Calendar_Month |
integer |
|
Day_Number_in_Calendar_Year |
integer |
|
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) |
|