| Name |
Type |
Computed column expression |
| FullDateAlternateKey |
System.DateTime |
|
| DayNumberOfWeek |
System.Byte |
|
| DayNumberOfMonth |
System.Byte |
|
| DayNumberOfYear |
System.Int16 |
|
| WeekNumberOfYear |
System.Byte |
|
| MonthNumberOfYear |
System.Byte |
|
| CalendarQuarter |
System.Byte |
|
| CalendarYear |
System.Int16 |
|
| CalendarSemester |
System.Byte |
|
| FiscalQuarter |
System.Byte |
|
| FiscalYear |
System.Int16 |
|
| FiscalSemester |
System.Byte |
|
| CalendarQuarterDesc |
System.String |
'Q' + CONVERT(CHAR (1), CalendarQuarter) +
' CY ' +
CONVERT(CHAR (4), CalendarYear) |
| FiscalQuarterDesc |
System.String |
'Q' + CONVERT(CHAR (1), FiscalQuarter) +
' FY ' +
CONVERT(CHAR (4), FiscalYear) |
| CalendarSemesterDesc |
System.String |
CASE
WHEN CalendarSemester = 1
THEN 'H1 '+'CY ' + CONVERT(CHAR (4), CalendarYear)
ELSE 'H2 '+ 'CY '+ CONVERT(CHAR (4), CalendarYear)
END |
| FiscalSemesterDesc |
System.String |
CASE
WHEN FiscalSemester = 1
THEN 'H1 '+'FY '+ CONVERT(CHAR (4), FiscalYear)
ELSE 'H2 '+'FY '+ CONVERT(CHAR (4), FiscalYear)
END |
| EnglishDayNameOfWeek |
System.String |
|
| SpanishDayNameOfWeek |
System.String |
|
| FrenchDayNameOfWeek |
System.String |
|
| EnglishMonthName |
System.String |
|
| SpanishMonthName |
System.String |
|
| FrenchMonthName |
System.String |
|
| SimpleDate |
System.String |
DATENAME(mm, FullDateAlternateKey) + ' ' +
DATENAME(dd, FullDateAlternateKey) + ', ' +
DATENAME(yy, FullDateAlternateKey) |
| MonthName |
System.String |
EnglishMonthName+' '+ CONVERT(CHAR (4), CalendarYear) |
| CalendarSemesterOfYear |
System.String |
CASE
WHEN CalendarSemester = 1
THEN 'CY H1'
ELSE 'CY H2'
END |
| FiscalSemesterOfYear |
System.String |
CASE
WHEN FiscalSemester = 1
THEN 'FY H1'
ELSE 'FY H2'
END |
| CalendarQuarterOfYear |
System.String |
'CY Q' + CONVERT(CHAR (1), CalendarQuarter) |
| FiscalQuarterOfYear |
System.String |
'FY Q' + CONVERT(CHAR (1), FiscalQuarter) |
| FiscalYearDesc |
System.String |
'FY '+ CONVERT(CHAR (4), FiscalYear) |
| CalendarYearDesc |
System.String |
'CY '+ CONVERT(CHAR (4), CalendarYear) |
| DateKey |
System.Int32 |
|
| MonthNameValue |
System.DateTime |
CAST(
CONVERT( CHAR(2), MonthNumberOfYear)
+ '/ ' + '1/' +
CONVERT(CHAR(4), CalendarYear) AS DATE
) |
| FiscalWeekNumberOfYear |
System.Int32 |
CASE
WHEN WeekNumberOfYear< 27
THEN
WeekNumberOfYear + 27
ELSE
WeekNumberOfYear - 26
END |
| FiscalWeek |
System.String |
CASE
WHEN WeekNumberOfYear< 27
THEN
'FY Week ' + CONVERT(CHAR(2), WeekNumberOfYear + 27)
ELSE
'FY Week ' + CONVERT(CHAR(2), WeekNumberOfYear - 26)
END |
| CalendarWeek |
System.String |
'CY Week ' + CONVERT(CHAR(2), WeekNumberOfYear) |
| FiscalWeekDesc |
System.String |
CASE
WHEN WeekNumberOfYear< 27
THEN
'Week ' + CONVERT(CHAR(2), WeekNumberOfYear + 27) +
' FY ' + CONVERT(CHAR (4), FiscalYear)
ELSE
'Week ' + CONVERT(CHAR(2), WeekNumberOfYear - 26) +
' FY ' + CONVERT(CHAR (4), FiscalYear)
END |
| CalendarWeekDesc |
System.String |
'Week ' + CONVERT(CHAR(2), WeekNumberOfYear) +
' CY ' + CONVERT(CHAR (4), CalendarYear) |