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, |
| CalendarEndOfMonth | tinyint | Not Null | Last calendar day of the month: False = 0, True = 1. |
| CalendarEndOfYear | tinyint | Not Null | Last day of the calendar year: |
| 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, |
| 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, |
| 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 |
| Workday | tinyint | Null values allowed | Flag indicating a workday. Values are |