SCRM 2006 SCRS_Date_Dimension_View

SCRS_Date_Dimension_View lists both calendar and fiscal calendar information for each date.

SCRS_Date_Dimension_View

Column	Type	Constraint	Description
DateKey	smallint	Not Null	Foreign key that uniquely identifies each product in the SC_DateDimension_Table.
CalendarDate	datetime	Not Null	Full calendar date stored as a SQL Server datetime (8 bytes).
CalendarDayOfMonth	tinyint	Not Null	Day of the month only; for example, 28 for 05-28-2004.
CalendarDayOfWeek	tinyint	Not Null	Day of the week stored as an integer; for example, Sunday = 1 through Saturday = 7.
CalendarDayOfWeekEnglish	nvarchar	Not Null	Text name of the day of the week in English.
CalendarDayOfWeekFrench	nvarchar	Null values allowed	Text name of the day of the week in French.
CalendarDayOfWeekGerman	nvarchar	Null values allowed	Text name of the day of the week in German.
CalendarDayOfWeekJapanese	nvarchar	Null values allowed	Text name of the day of the week in Japanese.
CalendarDayOfYear	smallint	Not Null	Day of the year stored as an integer; for example, 01-01-2005 = 1 and 02-02-2005 = 33.
CalendarEndOfMonth	tinyint	Not Null	Last calendar day of the month: False = 0, True = 1.
CalendarEndOfYear	tinyint	Not Null	Last day of the calendar year: False = 0, True = 1.
CalendarHalfYear	tinyint	Not Null	First half of the year stored as 1 and the second half as 2.
CalendarHalfYearName	nvarchar	Not Null	Text representation for first and second half of the year; for example, "First Half" or "H1".
CalendarMonthNameEnglish	nvarchar	Not Null	Text name of the month in English.
CalendarMonthNameFrench	nvarchar	Not Null	Text name of the month in French.
CalendarMonthNameGerman	nvarchar	Not Null	Text name of the month in German.
CalendarMonthNameJapanese	nvarchar	Not Null	Text name of the month in Japanese.
CalendarMonthOfYear	tinyint	Not Null	Month of the year stored as an integer; for example, January = 1 through December = 12.
CalendarMonthShortNameEnglish	nvarchar	Not Null	Abbreviated name of the month in English.
CalendarMonthShortNameFrench	nvarchar	Null values allowed	Abbreviated name of the month in French.
CalendarMonthShortNameGerman	nvarchar	Null values allowed	Abbreviated name of the month in German.
CalendarMonthShortNameJapanese	nvarchar	Null values allowed	Abbreviated name of the month in Japanese.
CalendarQuarter	tinyint	Not Null	Year quarter stored as an integer; for example, Q1 = 1 through Q4 = 4.
CalendarQuarterNameEnglish	nvarchar	Not Null	Text name of the year quarter in English.
CalendarQuarterNameFrench	nvarchar	Null values allowed	Text name of the year quarter in French.
CalendarQuarterNameGerman	nvarchar	Null values allowed	Text name of the year quarter in German.
CalendarQuarterNameJapanese	nvarchar	Null values allowed	Text name of the year quarter in Japanese.
CalendarWeekEnding	datetime	Not Null	Date of the end of the current calendar week.
CalendarWeekOfYear	tinyint	Not Null	Integer value for the week of the year.
CalendarYear	smallint	Not Null	Integer value for the year; for example, 2005.
CalendarYearName	nvarchar	Not Null	Text representation of the calendar year name.
FiscalHalfYear	tinyint	Null values allowed	First half of the year stored as 1 and the second half as 2.
FiscalHalfYearName	nvarchar	Null values allowed	Text representation for first and second half of year; for example, First Half or H1.
FiscalQuarter	tinyint	Null values allowed	Year quarter stored as an integer; for example, Q1 = 1 through Q4 = 4.
FiscalQuarterNameEnglish	nvarchar	Null values allowed	Text name of the year quarter in English.
FiscalQuarterNameFrench	nvarchar	Null values allowed	Text name of the year quarter in French.
FiscalQuarterNameGerman	nvarchar	Null values allowed	Text name of the year quarter in German.
FiscalQuarterNameJapanese	nvarchar	Null values allowed	Text name of the year quarter in Japanese.
FiscalYearNameEnglish	nvarchar	Null values allowed	Text representation of the calendar year name in English.
FiscalYearNameFrench	nvarchar	Null values allowed	Text representation of the calendar year name in French.
FiscalYearNameGerman	nvarchar	Null values allowed	Text representation of the calendar year name in German.
FiscalYearNameJapanese	nvarchar	Null values allowed	Text representation of the calendar year name in Japanese.
FiscalYearNumber	smallint	Null values allowed	Integer value of the fiscal year.
WeekEndDay	tinyint	Null values allowed	Flag indicating a weekend day. Values are Yes and No.
Workday	tinyint	Null values allowed	Flag indicating a workday. Values are Yes and No.

See Also

Other Resources

SCRM 2006 MOM Views
SCRM 2006 Report Customization
SCRM 2006 SMS Views
SCRM 2006 Stored Procedures