Metadata hierarchy: MDWT_Adventure_Works_Demo ยป MDWT_AdventureWorksDW
| 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? |
| Column Name | Data Type |