Book Contents

Book Index

Next Topic

Home

Date_Dimension

This 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

Calendar_Year

Integer

Calendar year of the Date e.g. 2001

Calendar_Year_Month

Integer

Calendar Month of the Date (1-12) e.g. 9 for September

Day_Num_in_Fiscal_Month

Integer

The day number in the month (1-31) e.g. 21 for 21st of any month.