Information for the AnalyticsSourceDate

Columns

• DateKey (datatype: int) Required Primary Key
• Date (datatype: date) Required Primary Key
• FullDateDescription (datatype: nvarchar(max)) Required Primary Key
• DayOfWeek (datatype: int) Required Primary Key
• DayOfWeekName (datatype: nvarchar(450)) Required Primary Key
• DayOfWeekAbbreviated (datatype: nvarchar(450)) Required Primary Key
• DayNumberInCalendarMonth (datatype: int) Required Primary Key
• DayNumberInCalendarYear (datatype: int) Required Primary Key
• DayNumberInFiscalMonth (datatype: int) Required Primary Key
• DayNumberInFiscalYear (datatype: int) Required Primary Key
• LastDayInMonthIndictor (datatype: bit) Required Primary Key
• WeekNumberInMonth (datatype: int) Required Primary Key
• SundayDate (datatype: date) Required Primary Key
• GivingMonth (datatype: int) Required Primary Key
• GivingMonthName (datatype: nvarchar(450)) Required Primary Key
• CalendarWeek (datatype: int) Required Primary Key
• CalendarMonth (datatype: int) Required Primary Key
• CalendarMonthName (datatype: nvarchar(450)) Required Primary Key
• CalendarMonthNameAbbreviated (datatype: nvarchar(450)) Required Primary Key
• CalendarYearMonth (datatype: nvarchar(450)) Required Primary Key
• CalendarQuarter (datatype: nvarchar(450)) Required Primary Key
• CalendarYearQuarter (datatype: nvarchar(450)) Required Primary Key
• CalendarYear (datatype: int) Required Primary Key
• FiscalWeek (datatype: int) Required Primary Key
• FiscalWeekNumberInYear (datatype: int) Required Primary Key
• FiscalMonth (datatype: nvarchar(450)) Required Primary Key
• FiscalMonthAbbreviated (datatype: nvarchar(450)) Required Primary Key
• FiscalMonthNumberInYear (datatype: int) Required Primary Key
• FiscalMonthYear (datatype: nvarchar(450)) Required Primary Key
• FiscalQuarter (datatype: nvarchar(450)) Required Primary Key
• FiscalYearQuarter (datatype: nvarchar(450)) Required Primary Key
• FiscalHalfYear (datatype: nvarchar(450)) Required Primary Key
• FiscalYear (datatype: int) Required Primary Key
• HolidayIndicator (datatype: bit) Required Primary Key
• WeekHolidayIndicator (datatype: bit) Required Primary Key
• EasterIndicator (datatype: bit) Required Primary Key
• EasterWeekIndicator (datatype: bit) Required Primary Key
• ChristmasIndicator (datatype: bit) Required Primary Key
• ChristmasWeekIndicator (datatype: bit) Required Primary Key
• CalendarYearMonthName (datatype: nvarchar(450)) Required Primary Key
• Count (datatype: int) Required Primary Key
• CalendarMonthNameAbbrevated (datatype: nvarchar(450)) Required Primary Key
• FiscalMonthAbbrevated (datatype: nvarchar(450)) Required Primary Key
• WeekOfYear (datatype: int) Required Primary Key
• WeekCounter (datatype: int) Required Primary Key
• LeapYearIndicator (datatype: bit) Required Primary Key
• SundayDateYear (datatype: int) Required Primary Key
• Age (datatype: int) Required Primary Key
• AgeBracket (datatype: int) Required Primary Key