|
|
|
|
|
|
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 |
Date_Description |
Varchar |
Description of the Date e.g. January 1, 2000 |
Day_Num_In_Fiscal_Month |
Integer |
The day number in the month (1-31) e.g. 21 for 21st of any month. |
Calendar_Year_Month |
Integer |
Calendar Month of the Date (1-12) e.g. 9 for September |
Calendar_Year |
Integer |
Calendar year of the Date e.g. 2001 |