Adventure Works DW - Table

Table properties

name	value
name	dbo_DimTime
data source view	Adventure Works DW
case sensitive	False
display expression
friendly name	DimTime
db schema name	dbo
db table name	DimTime
type	Table

Columns

name	nulls	caption	data type	ordinal	unique	auto increment	auto increment seed	auto increment step	datetime mode	max length	is logical	db column name	computed column expression
TimeKey	False	TimeKey	Int32	0	True	True	0	1				TimeKey
FullDateAlternateKey	True	FullDateAlternateKey	DateTime	1	False				UnspecifiedLocal			FullDateAlternateKey
DayNumberOfWeek	True	DayNumberOfWeek	Byte	2	False							DayNumberOfWeek
DayNumberOfMonth	True	DayNumberOfMonth	Byte	3	False							DayNumberOfMonth
DayNumberOfYear	True	DayNumberOfYear	Int16	4	False							DayNumberOfYear
WeekNumberOfYear	True	WeekNumberOfYear	Byte	5	False							WeekNumberOfYear
MonthNumberOfYear	True	MonthNumberOfYear	Byte	6	False							MonthNumberOfYear
CalendarQuarter	True	CalendarQuarter	Byte	7	False							CalendarQuarter
CalendarYear	True	CalendarYear	String	8	False					4		CalendarYear
CalendarSemester	True	CalendarSemester	Byte	9	False							CalendarSemester
FiscalQuarter	True	FiscalQuarter	Byte	10	False							FiscalQuarter
FiscalYear	True	FiscalYear	String	11	False					4		FiscalYear
FiscalSemester	True	FiscalSemester	Byte	12	False							FiscalSemester
CalendarQuarterDesc	True	CalendarQuarterDesc	String	13	False					10	True	CalendarQuarterDesc	show/hide 'Q' + CONVERT(CHAR (1), CalendarQuarter) + ' CY ' + CONVERT(CHAR (4), CalendarYear)
FiscalQuarterDesc	True	FiscalQuarterDesc	String	14	False					10	True	FiscalQuarterDesc	show/hide 'Q' + CONVERT(CHAR (1), FiscalQuarter) +' '+ 'FY ' + CONVERT(CHAR (4), FiscalYear)
CalendarSemesterDesc	True	CalendarSemesterDesc	String	15	False					10	True	CalendarSemesterDesc	show/hide CASE WHEN CalendarSemester = 1 THEN 'H1 '+'CY ' + CONVERT(CHAR (4), CalendarYear) ELSE 'H2 '+ 'CY '+ CONVERT(CHAR (4), CalendarYear) END
FiscalSemesterDesc	True	FiscalSemesterDesc	String	16	False					10	True	FiscalSemesterDesc	show/hide CASE WHEN FiscalSemester = 1 THEN 'H1 '+'FY '+ CONVERT(CHAR (4), FiscalYear) ELSE 'H2 '+'FY '+ CONVERT(CHAR (4), FiscalYear) END
EnglishDayNameOfWeek	True	EnglishDayNameOfWeek	String	17	False					10		EnglishDayNameOfWeek
SpanishDayNameOfWeek	True	SpanishDayNameOfWeek	String	18	False					10		SpanishDayNameOfWeek
FrenchDayNameOfWeek	True	FrenchDayNameOfWeek	String	19	False					10		FrenchDayNameOfWeek
EnglishMonthName	True	EnglishMonthName	String	20	False					10		EnglishMonthName
SpanishMonthName	True	SpanishMonthName	String	21	False					10		SpanishMonthName
FrenchMonthName	True	FrenchMonthName	String	22	False					10		FrenchMonthName
SimpleDate	True	SimpleDate	String	23	False					93	True	SimpleDate	show/hide DATENAME(mm, FullDateAlternateKey) + ' ' + DATENAME(dd, FullDateAlternateKey) + ', ' + DATENAME(yy, FullDateAlternateKey)
MonthName	True	MonthName	String	24	False					15	True	MonthName	show/hide EnglishMonthName+' '+ CONVERT(CHAR (4), CalendarYear)
CalendarSemesterOfYear	False	CalendarSemesterOfYear	String	25	False					5	True	CalendarSemesterOfYear	show/hide CASE WHEN CalendarSemester = 1 THEN 'CY H1' ELSE 'CY H2' END
FiscalSemesterOfYear	False	FiscalSemesterOfYear	String	26	False					5	True	FiscalSemesterOfYear	show/hide CASE WHEN FiscalSemester = 1 THEN 'FY H1' ELSE 'FY H2' END
CalendarQuarterOfYear	True	CalendarQuarterOfYear	String	27	False					5	True	CalendarQuarterOfYear	show/hide 'CY Q' + CONVERT(CHAR (1), CalendarQuarter)
FiscalQuarterOfYear	True	FiscalQuarterOfYear	String	28	False					5	True	FiscalQuarterOfYear	show/hide 'FY Q' + CONVERT(CHAR (1), FiscalQuarter)
FiscalYearDesc	True	FiscalYearDesc	String	29	False					7	True	FiscalYearDesc	show/hide 'FY '+ FiscalYear
CalendarYearDesc	True	CalendarYearDesc	String	30	False					7	True	CalendarYearDesc	show/hide 'CY '+ CalendarYear
MonthNameValue	True	MonthNameValue	DateTime	31	False				UnspecifiedLocal		True	MonthNameValue	show/hide CAST( CONVERT( CHAR(2), MonthNumberOfYear) + '/ ' + '1/' + CalendarYear AS DATETIME )
CalendarYearValue	True	CalendarYearValue	Int16	32	False						True	CalendarYearValue	show/hide Cast( CalendarYear AS SmallInt)
FiscalYearValue	True	FiscalYearValue	Int16	33	False						True	FiscalYearValue	show/hide Cast( FiscalYear AS SmallInt)

Referenced by

parent column	child column	relation name	nested

Foreign key graph

dbo_DimTime dbo_FactCurrencyRatedbo_FactFinancedbo_FactInternetSalesdbo_FactInternetSalesdbo_FactInternetSalesdbo_FactResellerSalesdbo_FactResellerSalesdbo_FactResellerSalesFactSalesQuotaFactSalesSummaryFactSalesSummaryFactSalesSummary

Dependency graph

Adventure Works DWdbo_DimTime

Objects that dbo_DimTime depends on

name	object type	level
Adventure Works DW	DataSourceView	1

Table - dbo_DimTime

Table properties

Columns

Referenced by

Foreign key graph

Dependency graph

Objects that dbo_DimTime depends on