| TimeKey
| False
| TimeKey
| Int32
| 0
| True
| True
| 0
| 1
|
|
|
|
|
|
| FullDateAlternateKey
| True
| FullDateAlternateKey
| DateTime
| 1
| False
|
|
|
| UnspecifiedLocal
|
|
|
|
|
| DayNumberOfWeek
| True
| DayNumberOfWeek
| Byte
| 2
| False
|
|
|
|
|
|
|
|
|
| EnglishDayNameOfWeek
| True
| EnglishDayNameOfWeek
| String
| 3
| False
|
|
|
|
| 10
|
|
|
|
| SpanishDayNameOfWeek
| True
| SpanishDayNameOfWeek
| String
| 4
| False
|
|
|
|
| 10
|
|
|
|
| FrenchDayNameOfWeek
| True
| FrenchDayNameOfWeek
| String
| 5
| False
|
|
|
|
| 10
|
|
|
|
| DayNumberOfMonth
| True
| DayNumberOfMonth
| Byte
| 6
| False
|
|
|
|
|
|
|
|
|
| DayNumberOfYear
| True
| DayNumberOfYear
| Int16
| 7
| False
|
|
|
|
|
|
|
|
|
| WeekNumberOfYear
| True
| WeekNumberOfYear
| Byte
| 8
| False
|
|
|
|
|
|
|
|
|
| EnglishMonthName
| True
| EnglishMonthName
| String
| 9
| False
|
|
|
|
| 10
|
|
|
|
| SpanishMonthName
| True
| SpanishMonthName
| String
| 10
| False
|
|
|
|
| 10
|
|
|
|
| FrenchMonthName
| True
| FrenchMonthName
| String
| 11
| False
|
|
|
|
| 10
|
|
|
|
| MonthNumberOfYear
| True
| MonthNumberOfYear
| Byte
| 12
| False
|
|
|
|
|
|
|
|
|
| CalendarQuarter
| True
| CalendarQuarter
| Byte
| 13
| False
|
|
|
|
|
|
|
|
|
| CalendarYear
| True
| CalendarYear
| String
| 14
| False
|
|
|
|
| 4
|
|
|
|
| CalendarSemester
| True
| CalendarSemester
| Byte
| 15
| False
|
|
|
|
|
|
|
|
|
| FiscalQuarter
| True
| FiscalQuarter
| Byte
| 16
| False
|
|
|
|
|
|
|
|
|
| FiscalYear
| True
| FiscalYear
| String
| 17
| False
|
|
|
|
| 4
|
|
|
|
| FiscalSemester
| True
| FiscalSemester
| Byte
| 18
| False
|
|
|
|
|
|
|
|
|
| SimpleDate
| True
| SimpleDate
| String
| 19
| False
|
|
|
|
| 93
| True
| SimpleDate
| show/hideDATENAME(mm, FullDateAlternateKey) + ' ' + DATENAME(dd, FullDateAlternateKey) + ',' + ' ' + DATENAME(yy, FullDateAlternateKey)
|
| CalendarYearDesc
| True
| CalendarYearDesc
| String
| 20
| False
|
|
|
|
| 7
| True
| CalendarYearDesc
| show/hide'CY' + ' ' + CalendarYear
|
| CalendarSemesterDesc
| True
| CalendarSemesterDesc
| String
| 21
| False
|
|
|
|
| 10
| True
| CalendarSemesterDesc
| show/hideCASE WHEN CalendarSemester = 1 THEN 'H1'+' '+ 'CY' +' '+ CONVERT(CHAR (4), CalendarYear) ELSE 'H2'+' '+ 'CY' +' '+ CONVERT(CHAR (4), CalendarYear) END
|
| CalendarQuarterDesc
| True
| CalendarQuarterDesc
| String
| 22
| False
|
|
|
|
| 10
| True
| CalendarQuarterDesc
| show/hide'Q' + CONVERT(CHAR (1), CalendarQuarter) +' '+ 'CY' +' '+ CONVERT(CHAR (4), CalendarYear)
|
| MonthName
| True
| MonthName
| String
| 23
| False
|
|
|
|
| 15
| True
| MonthName
| show/hideEnglishMonthName+' '+ CONVERT(CHAR (4), CalendarYear)
|
| FiscalYearDesc
| True
| FiscalYearDesc
| String
| 24
| False
|
|
|
|
| 7
| True
| FiscalYearDesc
| show/hide'FY' + ' ' + FiscalYear
|
| FiscalSemesterDesc
| True
| FiscalSemesterDesc
| String
| 25
| False
|
|
|
|
| 10
| True
| FiscalSemesterDesc
| show/hideCASE WHEN FiscalSemester = 1 THEN 'H1'+' '+ 'FY' +' '+ CONVERT(CHAR (4), FiscalYear) ELSE 'H2'+' '+ 'FY' +' '+ CONVERT(CHAR (4), FiscalYear) END
|
| FiscalQuarterDesc
| True
| FiscalQuarterDesc
| String
| 26
| False
|
|
|
|
| 10
| True
| FiscalQuarterDesc
| show/hide'Q' + CONVERT(CHAR (1), FiscalQuarter) +' '+ 'FY' +' '+ CONVERT(CHAR (4), FiscalYear)
|
| FiscalMonthNumberOfYear
| True
| FiscalMonthNumberOfYear
| Int32
| 27
| False
|
|
|
|
|
| True
| FiscalMonthNumberOfYear
| show/hideCASE WHEN MonthNumberOfYear = '1' THEN CONVERT(int,'7') WHEN MonthNumberOfYear = '2' THEN CONVERT(int,'8') WHEN MonthNumberOfYear = '3' THEN CONVERT(int,'9') WHEN MonthNumberOfYear = '4' THEN CONVERT(int,'10') WHEN MonthNumberOfYear = '5' THEN CONVERT(int,'11') WHEN MonthNumberOfYear = '6' THEN CONVERT(int,'12') WHEN MonthNumberOfYear = '7' THEN CONVERT(int,'1') WHEN MonthNumberOfYear = '8' THEN CONVERT(int,'2') WHEN MonthNumberOfYear = '9' THEN CONVERT(int,'3') WHEN MonthNumberOfYear = '10' THEN CONVERT(int,'4') WHEN MonthNumberOfYear = '11' THEN CONVERT(int,'5') WHEN MonthNumberOfYear = '12' THEN CONVERT(int,'6') END
|