| Column Name | Data Type | Is Key | Short description |
| DateKey | int | | Surrogate primary key |
| FullDate | datetime | | Full date as a SQL date (time=00:00:00) |
| DateName | char | | String expression of the full date in users' favored format |
| DayOfWeek | tinyint | | Number of the day of week; Sunday = 1 |
| DayNameOfWeek | char | | Day name of week |
| DayOfMonth | tinyint | | Number of the day in the month |
| DayOfYear | smallint | | Number of the day in the year |
| WeekdayWeekend | char | | Is today a weekday or a weekend |
| WeekOfYear | tinyint | | Week of year |
| MonthName | char | | Month name |
| MonthOfYear | tinyint | | Month of year |
| IsLastDayOfMonth | char | | Is this the last day of the calendar month? |
| CalendarQuarter | tinyint | | Calendar quarter |
| CalendarYear | smallint | | Calendar year |
| CalendarYearMonth | char | | Calendar year and month |
| CalendarYearQtr | char | | Calendar year and quarter |
| FiscalMonthOfYear | tinyint | | Fiscal month of year (1..12). FY starts in July |
| FiscalQuarter | tinyint | | Fiscal quarter |
| FiscalYear | int | | Fiscal year. Fiscal year begins in July. |
| FiscalYearMonth | char | | Fiscal year and month |
| FiscalYearQtr | char | | Fiscal year and quarter |
| AuditKey | int | | What process loaded this row? |