Meta Data Management Repository

Calendar

Name	Type	Cardinality
DW_Id	bigint	1 - 1
DateValue	datetime	1 - 1
DisplayDate	varchar	1 - 1
DayOfMonth	int	1 - 1
DayName	varchar	1 - 1
DayOfWeek	int	1 - 1
IsWeekDay	int	1 - 1
DayOfQuarter	int	1 - 1
DayOfWeekInYear	int	1 - 1
DayOfYear	int	1 - 1
WeekKey	int	1 - 1
Week	int	1 - 1
WeekName	varchar	1 - 1
YearWeekName	varchar	1 - 1
WeekOfMonth	int	1 - 1
WeekOfQuarter	int	1 - 1
WeekOfYear	int	1 - 1
MonthKey	int	1 - 1
Month	int	1 - 1
MonthName	varchar	1 - 1
YearMonthName	varchar	1 - 1
QuarterKey	int	1 - 1
Quarter	int	1 - 1
QuarterName	varchar	1 - 1
HalfYearKey	int	1 - 1
HalfYear	int	1 - 1
HalfYearName	varchar	1 - 1
YearHalfYearName	varchar	1 - 1
YearQuarterName	varchar	1 - 1
Year	int	1 - 1
YearName	varchar	1 - 1
FirstDayOfMonth	datetime	1 - 1
LastDayOfMonth	datetime	1 - 1
FirstDayOfQuarter	datetime	1 - 1
LastDayOfQuarter	datetime	1 - 1
FirstDayOfYear	datetime	1 - 1
LastDayOfYear	datetime	1 - 1
YearIndex	int	1 - 1
QuarterIndex	int	1 - 1
MonthIndex	int	1 - 1
WeekIndex	int	1 - 1
DW_Batch	bigint	1 - 1
DW_SourceCode	varchar	1 - 1
DW_TimeStamp	datetime	1 - 1