EnterpriseDW
 dbo.DimDate (Table)
Home  Diagrams  Documents  Images  EnterpriseDW  Storage  Users  Roles  Schemas  Tables  Views  Indexes  Triggers  Stored Procedures  Functions  Data Types  XML Schemas  Rules  Defaults  Fulltext Catalogs  Synonyms  Keys  Partitions  Assemblies 
Current Path:  EnterpriseDW   Tables   dbo.DimDate
  Properties
Property Value
Name DimDate
Schema dbo
Row Count 49309
Data Size 22528 KB
Index Size 64 KB
Create Date 8/28/2013 9:52 AM
Description The primary date dimension, allows the data warehouse to resolve dates and perform date functions. There is one row per 'day'.
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
AuditKey
int(10, 0)
False
False
False
 
Indication of audit status of the row. The default value is 0.
CalendarMonthOfYear
varchar(35)
False
False
False
 
Combination of Year and Month Name. Example 2012-January
CalendarPeriod
varchar(15)
False
False
False
 
Combination of Year and Month. Example: 201307
CalendarPeriodSort
int(10, 0)
False
False
False
 
A sort sequence for Calendar Period that will allow Completed period per fiscal year to show first in Filters
DateName
varchar(25)
False
False
False
 
The date in the format YYYY-MM-DD.
In Primary Key
DateSK
int(10, 0)
False
False
False
 
The primary date identity field for the date dimension. Contains a date in the format YYYYMMDD.
Day
varchar(35)
False
False
False
 
A literal representation of the day within the calendar year. The value includes the day of the week, the day of the month and the calendar year ( Saturday, September 26 CY 2012).
DayOfMonth
tinyint(3, 0)
False
False
False
 
Numeric value for the day of the month. Valid values are 1 through 31.
DayOfWeek
tinyint(3, 0)
False
False
False
 
Numeric value for the day of the week, starting from Sunday. The valid values are 1 through 7.
DayOfYear
smallint(5, 0)
False
False
False
 
Numeric value for the day within the year. The valid values are 1 through 366.
FiscalMonth
varchar(25)
False
False
False
 
A literal representation of the month within the Fiscal Year. The value includes the month and the fiscal year ( September FY 2012).
FiscalMonthOfYear
tinyint(3, 0)
False
False
False
 
Numeric value for the month within the fiscal year. The valid values are 1 through 12.
FiscalPeriod
varchar(20)
False
False
False
 
Combination of Fiscal Year and Fiscal Month of Year. Example 201301
FiscalPeriodOfYear
varchar(6)
False
False
False
 
Combination of Fiscal Period and Year. Example 012013
FiscalQuarter
varchar(25)
False
False
False
 
A literal representation of the Quarter within the Fiscal Year. The value includes the quarter identifier and the fiscal year ( Q1 FY 2012).
FiscalYear
varchar(15)
False
False
False
 
A literal representation of the Fiscal Year. The value includes the fiscal year ( FY 2012).
FullDate
datetime(23, 3)
False
False
False
 
The date represented in the SQL 'datetime' format.
IsAvailableForFinance
varchar(1)
False
False
False
 
Inidcates if Dates should be listed in filters for Financial Dashboards
IsCurrentDay
varchar(1)
False
False
False
 
Binary field (Y/N) that indicates which date should be treated as the current day. Only 1 record in DimDate should be set as Y.
IsCurrentFiscalYear
varchar(1)
False
False
False
 
Indication the date is within the current fiscal year. The valid values are' Y' and' N'.
IsNextFiscalYear
varchar(1)
False
False
False
 
Indication the date is within the next (as compared to the current) fiscal year. The valid values are 'Y' and 'N'.
IsPriorFiscalYear
varchar(1)
False
False
False
 
Indication the date is within the prior (as compared to the current) fiscal year. The valid values are 'Y' and 'N'.
Month
varchar(35)
False
False
False
 
Literal description for the month within the calendar year. The valid values are January through December.
MonthOfYear
tinyint(3, 0)
False
False
False
 
Numeric value for the month within the calendar year. The valid values are 1 through 12.
PayPeriodCode
smallint(5, 0)
False
False
False
 
((-1))
Pay Period indicator. Not currently used, default value -1.
Quarter
varchar(20)
False
False
False
 
A literal representation of the Quarter within the Calendar Year. The value includes the quarter identifier and the calendar year ( Q1 CY 2012).
QuarterOfYear
varchar(10)
False
False
False
 
A literal representation of the Quarter within the Fiscal Year. The value includes the quarter identifier( Q1).
RowChangeReason
varchar(200)
False
False
False
 
('Initial Row')
Indication of the origin of the row. The default value is 'Initial Row'.
RowEndDate
datetime(23, 3)
False
False
False
 
('12/31/9999')
The effective end date-time for the current date row.
RowIsCurrent
char(1)
False
False
False
 
('Y')
Indicator if the row is the most current representation of the day. The valid values are 'N' or 'Y'.
RowStartDate
datetime(23, 3)
False
False
False
 
('01/01/1900')
The effective start date-time for the current date row.
Week
varchar(25)
False
False
False
 
A literal representation of the week within the calendar year. The value includes a week indicator and the calendar year ( Week 01 CY 2012).
WeekdayWeekend
varchar(10)
False
False
False
 
Indicator if the day is a 'weekday' or a 'weekend' day. The valid values are 'weekday' and 'weekend'.
WeekOfYear
tinyint(3, 0)
False
False
False
 
Numeric value for the week within the calendar year, starting from Sunday. The valid values are 1 through 53.
Year
varchar(15)
False
False
False
 
A literal representation of the calendar year. The valid values can be '1999', '2012' or '2025'.
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
True
DateSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.DimDate depends on)
Name Type
Table
Table
Table
Table
Table
Table
Table
Table
Table
Table
Table
Table
Table
Table
Table
Table
Table
Table
  Child Dependencies (objects that depend on dbo.DimDate)
Name Type
TABLE
TABLE
TABLE
TABLE
TABLE
TABLE
TABLE
TABLE
TABLE
TABLE
TABLE
TABLE
TABLE
TABLE
TABLE
TABLE
TABLE
TABLE
  Extended Properties
Object Property Value
DimDate
MS_Description
The primary date dimension, allows the data warehouse to resolve dates and perform date functions. There is one row per 'day'.
AuditKey
MS_Description
Indication of audit status of the row. The default value is 0.
CalendarMonthOfYear
MS_Description
Combination of Year and Month Name. Example 2012-January
CalendarPeriod
MS_Description
Combination of Year and Month. Example: 201307
CalendarPeriodSort
MS_Description
A sort sequence for Calendar Period that will allow Completed period per fiscal year to show first in Filters
DateName
MS_Description
The date in the format YYYY-MM-DD.
DateSK
MS_Description
The primary date identity field for the date dimension. Contains a date in the format YYYYMMDD.
Day
MS_Description
A literal representation of the day within the calendar year. The value includes the day of the week, the day of the month and the calendar year ( Saturday, September 26 CY 2012).
DayOfMonth
MS_Description
Numeric value for the day of the month. Valid values are 1 through 31.
DayOfWeek
MS_Description
Numeric value for the day of the week, starting from Sunday. The valid values are 1 through 7.
DayOfYear
MS_Description
Numeric value for the day within the year. The valid values are 1 through 366.
FiscalMonth
MS_Description
A literal representation of the month within the Fiscal Year. The value includes the month and the fiscal year ( September FY 2012).
FiscalMonthOfYear
MS_Description
Numeric value for the month within the fiscal year. The valid values are 1 through 12.
FiscalPeriod
MS_Description
Combination of Fiscal Year and Fiscal Month of Year. Example 201301
FiscalPeriodOfYear
MS_Description
Combination of Fiscal Period and Year. Example 012013
FiscalQuarter
MS_Description
A literal representation of the Quarter within the Fiscal Year. The value includes the quarter identifier and the fiscal year ( Q1 FY 2012).
FiscalYear
MS_Description
A literal representation of the Fiscal Year. The value includes the fiscal year ( FY 2012).
FullDate
MS_Description
The date represented in the SQL 'datetime' format.
IsAvailableForFinance
MS_Description
Inidcates if Dates should be listed in filters for Financial Dashboards
IsCurrentDay
MS_Description
Binary field (Y/N) that indicates which date should be treated as the current day. Only 1 record in DimDate should be set as Y.
IsCurrentFiscalYear
MS_Description
Indication the date is within the current fiscal year. The valid values are' Y' and' N'.
IsNextFiscalYear
MS_Description
Indication the date is within the next (as compared to the current) fiscal year. The valid values are 'Y' and 'N'.
IsPriorFiscalYear
MS_Description
Indication the date is within the prior (as compared to the current) fiscal year. The valid values are 'Y' and 'N'.
Month
MS_Description
Literal description for the month within the calendar year. The valid values are January through December.
MonthOfYear
MS_Description
Numeric value for the month within the calendar year. The valid values are 1 through 12.
PayPeriodCode
MS_Description
Pay Period indicator. Not currently used, default value -1.
Quarter
MS_Description
A literal representation of the Quarter within the Calendar Year. The value includes the quarter identifier and the calendar year ( Q1 CY 2012).
QuarterOfYear
MS_Description
A literal representation of the Quarter within the Fiscal Year. The value includes the quarter identifier( Q1).
RowChangeReason
MS_Description
Indication of the origin of the row. The default value is 'Initial Row'.
RowEndDate
MS_Description
The effective end date-time for the current date row.
RowIsCurrent
MS_Description
Indicator if the row is the most current representation of the day. The valid values are 'N' or 'Y'.
RowStartDate
MS_Description
The effective start date-time for the current date row.
Week
MS_Description
A literal representation of the week within the calendar year. The value includes a week indicator and the calendar year ( Week 01 CY 2012).
WeekdayWeekend
MS_Description
Indicator if the day is a 'weekday' or a 'weekend' day. The valid values are 'weekday' and 'weekend'.
WeekOfYear
MS_Description
Numeric value for the week within the calendar year, starting from Sunday. The valid values are 1 through 53.
Year
MS_Description
A literal representation of the calendar year. The valid values can be '1999', '2012' or '2025'.
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[DimDate] Script Date: 03/09/2017 17:14:54 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[DimDate](
    [DateSK] [int] NOT NULL,
    [FullDate] [datetime] NOT NULL,
    [DateName] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [PayPeriodCode] [smallint] NOT NULL,
    [DayOfMonth] [tinyint] NOT NULL,
    [DayOfWeek] [tinyint] NOT NULL,
    [DayOfYear] [smallint] NOT NULL,
    [Day] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FiscalMonth] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FiscalMonthOfYear] [tinyint] NOT NULL,
    [FiscalPeriod] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FiscalQuarter] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FiscalYear] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [IsCurrentFiscalYear] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [IsPriorFiscalYear] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [IsNextFiscalYear] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [MonthOfYear] [tinyint] NOT NULL,
    [Month] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [QuarterOfYear] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Quarter] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [WeekOfYear] [tinyint] NOT NULL,
    [Week] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [WeekdayWeekend] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Year] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CalendarPeriod] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CalendarPeriodSort] [int] NOT NULL,
    [CalendarMonthOfYear] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FiscalPeriodOfYear] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [IsAvailableForFinance] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowIsCurrent] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowStartDate] [datetime] NOT NULL,
    [RowEndDate] [datetime] NOT NULL,
    [RowChangeReason] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AuditKey] [int] NOT NULL,
    [IsCurrentDay] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 CONSTRAINT [PK_Dim_Date] PRIMARY KEY CLUSTERED 
(
    [DateSK] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
ALTER TABLE [dbo].[DimDate] ADD  CONSTRAINT [DF_SLDCADAPayPeriodCode]  DEFAULT ((-1)) FOR [PayPeriodCode]
ALTER TABLE [dbo].[DimDate] ADD  CONSTRAINT [defDimDate_RowIsCurrent]  DEFAULT ('Y') FOR [RowIsCurrent]
ALTER TABLE [dbo].[DimDate] ADD  CONSTRAINT [defDimDate_RowStartDate]  DEFAULT ('01/01/1900') FOR [RowStartDate]
ALTER TABLE [dbo].[DimDate] ADD  CONSTRAINT [defDimDate_RowEndDate]  DEFAULT ('12/31/9999') FOR [RowEndDate]
ALTER TABLE [dbo].[DimDate] ADD  CONSTRAINT [defDimDate_RowChangeReason]  DEFAULT ('Initial Row') FOR [RowChangeReason]


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The primary date dimension, allows the data warehouse to resolve dates and perform date functions. There is one row per ''day''.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication of audit status of the row. The default value is 0.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'AuditKey'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Combination of Year and Month Name. Example 2012-January' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'CalendarMonthOfYear'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Combination of Year and Month. Example: 201307' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'CalendarPeriod'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A sort sequence for Calendar Period that will allow Completed period per fiscal year to show first in Filters' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'CalendarPeriodSort'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The date in the format YYYY-MM-DD.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'DateName'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The primary date identity field for the date dimension. Contains a date in the format YYYYMMDD.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'DateSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A literal representation of the day within the calendar year. The value includes the day of the week, the day of the month and the calendar year ( Saturday, September 26 CY 2012).' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'Day'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Numeric value for the day of the month. Valid values are 1 through 31.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'DayOfMonth'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Numeric value for the day of the week, starting from Sunday. The valid values are 1 through 7.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'DayOfWeek'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Numeric value for the day within the year. The valid values are 1 through 366.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'DayOfYear'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A literal representation of the month within the Fiscal Year. The value includes the month and the fiscal year ( September FY 2012).' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'FiscalMonth'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Numeric value for the month within the fiscal year. The valid values are 1 through 12.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'FiscalMonthOfYear'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Combination of Fiscal Year and Fiscal Month of Year. Example 201301' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'FiscalPeriod'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Combination of Fiscal Period and Year. Example 012013' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'FiscalPeriodOfYear'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A literal representation of the Quarter within the Fiscal Year. The value includes the quarter identifier and the fiscal year ( Q1 FY 2012).' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'FiscalQuarter'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A literal representation of the Fiscal Year. The value includes the fiscal year ( FY 2012).' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'FiscalYear'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The date represented in the SQL ''datetime'' format.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'FullDate'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Inidcates if Dates should be listed in filters for Financial Dashboards' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'IsAvailableForFinance'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Binary field (Y/N) that indicates which date should be treated as the current day. Only 1 record in DimDate should be set as Y.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'IsCurrentDay'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the date is within the current fiscal year. The valid values are'' Y'' and'' N''.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'IsCurrentFiscalYear'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the date is within the next (as compared to the current) fiscal year. The valid values are ''Y'' and ''N''.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'IsNextFiscalYear'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication the date is within the prior (as compared to the current) fiscal year. The valid values are ''Y'' and ''N''.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'IsPriorFiscalYear'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Literal description for the month within the calendar year. The valid values are January through December.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'Month'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Numeric value for the month within the calendar year. The valid values are 1 through 12.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'MonthOfYear'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Pay Period indicator. Not currently used, default value -1.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'PayPeriodCode'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A literal representation of the Quarter within the Calendar Year. The value includes the quarter identifier and the calendar year ( Q1 CY 2012).' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'Quarter'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A literal representation of the Quarter within the Fiscal Year. The value includes the quarter identifier( Q1).' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'QuarterOfYear'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication of the origin of the row. The default value is ''Initial Row''.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'RowChangeReason'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The effective end date-time for the current date row.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'RowEndDate'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indicator if the row is the most current representation of the day. The valid values are ''N'' or ''Y''.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'RowIsCurrent'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The effective start date-time for the current date row.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'RowStartDate'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A literal representation of the week within the calendar year. The value includes a week indicator and the calendar year ( Week 01 CY 2012).' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'Week'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indicator if the day is a ''weekday'' or a ''weekend'' day. The valid values are ''weekday'' and ''weekend''.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'WeekdayWeekend'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Numeric value for the week within the calendar year, starting from Sunday. The valid values are 1 through 53.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'WeekOfYear'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A literal representation of the calendar year. The valid values can be ''1999'', ''2012'' or ''2025''.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimDate', @level2type=N'COLUMN',@level2name=N'Year'
  Sample Data
AuditKey CalendarMonthOfYear CalendarPeriod CalendarPeriodSort DateName DateSK Day DayOfMonth DayOfWeek DayOfYear FiscalMonth FiscalMonthOfYear FiscalPeriod FiscalPeriodOfYear FiscalQuarter FiscalYear FullDate IsAvailableForFinance IsCurrentDay IsCurrentFiscalYear IsNextFiscalYear IsPriorFiscalYear Month MonthOfYear PayPeriodCode Quarter QuarterOfYear RowChangeReason RowEndDate RowIsCurrent RowStartDate Week WeekdayWeekend WeekOfYear Year
0 April 1946 194604 2194604 04/19/1946 19460419 Friday, April 19 CY 1946 19 6 109 April FY 1946 10 FY 194610 101946 Q4 FY 1946 FY 1946 1946-04-19T00:00:00-04:00 N N N N N April 4 -1 Q2 CY 1946 Q2 Initial Row 9999-12-31T00:00:00-05:00 Y 1900-01-01T00:00:00-05:00 Week 16 CY 1946 Weekday 16 1946
0 March 2009 200903 2200903 03/16/2009 20090316 Monday, March 16 CY 2009 16 2 75 March FY 2009 9 FY 200909 092009 Q3 FY 2009 FY 2009 2009-03-16T00:00:00-04:00 Y N N N N March 3 -1 Q1 CY 2009 Q1 Initial Row 9999-12-31T00:00:00-05:00 Y 1900-01-01T00:00:00-05:00 Week 12 CY 2009 Weekday 12 2009
0 May 1970 197005 2197005 05/27/1970 19700527 Wednesday, May 27 CY 1970 27 4 147 May FY 1970 11 FY 197011 111970 Q4 FY 1970 FY 1970 1970-05-27T00:00:00-04:00 N N N N N May 5 -1 Q2 CY 1970 Q2 Initial Row 9999-12-31T00:00:00-05:00 Y 1900-01-01T00:00:00-05:00 Week 22 CY 1970 Weekday 22 1970
0 June 1932 193206 1193206 06/06/1932 19320606 Monday, June 06 CY 1932 6 2 158 June FY 1932 12 FY 193212 121932 Q4 FY 1932 FY 1932 1932-06-06T00:00:00-04:00 N N N N N June 6 -1 Q2 CY 1932 Q2 Initial Row 9999-12-31T00:00:00-05:00 Y 1900-01-01T00:00:00-05:00 Week 24 CY 1932 Weekday 24 1932
0 November 2031 203111 2203111 11/23/2031 20311123 Sunday, November 23 CY 2031 23 1 327 November FY 2032 5 FY 203205 052032 Q2 FY 2032 FY 2032 2031-11-23T00:00:00-05:00 N N N N N November 11 -1 Q4 CY 2031 Q4 Initial Row 9999-12-31T00:00:00-05:00 Y 1900-01-01T00:00:00-05:00 Week 48 CY 2031 Weekend 48 2031
0 November 1953 195311 2195311 11/28/1953 19531128 Saturday, November 28 CY 1953 28 7 332 November FY 1954 5 FY 195405 051954 Q2 FY 1954 FY 1954 1953-11-28T00:00:00-05:00 N N N N N November 11 -1 Q4 CY 1953 Q4 Initial Row 9999-12-31T00:00:00-05:00 Y 1900-01-01T00:00:00-05:00 Week 48 CY 1953 Weekend 48 1953
0 November 1924 192411 2192411 11/18/1924 19241118 Tuesday, November 18 CY 1924 18 3 323 November FY 1925 5 FY 192505 051925 Q2 FY 1925 FY 1925 1924-11-18T00:00:00-05:00 N N N N N November 11 -1 Q4 CY 1924 Q4 Initial Row 9999-12-31T00:00:00-05:00 Y 1900-01-01T00:00:00-05:00 Week 47 CY 1924 Weekday 47 1924
0 December 1967 196712 2196712 12/25/1967 19671225 Monday, December 25 CY 1967 25 2 359 December FY 1968 6 FY 196806 061968 Q2 FY 1968 FY 1968 1967-12-25T00:00:00-05:00 N N N N N December 12 -1 Q4 CY 1967 Q4 Initial Row 9999-12-31T00:00:00-05:00 Y 1900-01-01T00:00:00-05:00 Week 52 CY 1967 Weekday 52 1967
0 October 2006 200610 2200610 10/28/2006 20061028 Saturday, October 28 CY 2006 28 7 301 October FY 2007 4 FY 200704 042007 Q2 FY 2007 FY 2007 2006-10-28T00:00:00-04:00 Y N N N N October 10 -1 Q4 CY 2006 Q4 Initial Row 9999-12-31T00:00:00-05:00 Y 1900-01-01T00:00:00-05:00 Week 43 CY 2006 Weekend 43 2006
0 October 1954 195410 2195410 10/22/1954 19541022 Friday, October 22 CY 1954 22 6 295 October FY 1955 4 FY 195504 041955 Q2 FY 1955 FY 1955 1954-10-22T00:00:00-04:00 N N N N N October 10 -1 Q4 CY 1954 Q4 Initial Row 9999-12-31T00:00:00-05:00 Y 1900-01-01T00:00:00-05:00 Week 43 CY 1954 Weekday 43 1954
Powered by BI Documenter