date_dimension

This table contains information about dates. It is generated from a file containing correct date/time data.

Column Name Data Type NULLs
date_key
INTEGER No
date
DATE Yes
full_date_description
VARCHAR(18) Yes
day_of_week
VARCHAR(9) Yes
day_number_in_calendar_month
INTEGER Yes
day_number_in_calendar_year
INTEGER Yes
day_number_in_fiscal_month
INTEGER Yes
day_number_in_fiscal_year
INTEGER Yes
last_day_in_week_indicator
INTEGER Yes
last_day_in_month_indicator
INTEGER Yes
calendar_week_number_in_year
INTEGER Yes
calendar_month_name
VARCHAR(9) Yes
calendar_month_number_in_year
INTEGER Yes
calendar_year_month
CHAR(7) Yes
calendar_quarter
INTEGER Yes
calendar_year_quarter
CHAR(7) Yes
calendar_half_year
INTEGER Yes
calendar_year
INTEGER Yes
holiday_indicator
VARCHAR(10) Yes
weekday_indicator
CHAR(7) Yes
selling_season
VARCHAR(32) Yes