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) |