Adventure Works DW - Table - dbo

Table properties

name	value
name	dbo_DimEmployee
data source view	Adventure Works DW
case sensitive	False
display expression
friendly name	DimEmployee
db schema name	dbo
db table name	DimEmployee
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
EmployeeKey	False	EmployeeKey	Int32	0	True	True	0	1				EmployeeKey
ParentEmployeeKey	True	ParentEmployeeKey	Int32	1	False							ParentEmployeeKey
EmployeeNationalIDAlternateKey	True	EmployeeNationalIDAlternateKey	String	2	False					15		EmployeeNationalIDAlternateKey
ParentEmployeeNationalIDAlternateKey	True	ParentEmployeeNationalIDAlternateKey	String	3	False					15		ParentEmployeeNationalIDAlternateKey
FirstName	False	FirstName	String	4	False					50		FirstName
LastName	False	LastName	String	5	False					50		LastName
MiddleName	True	MiddleName	String	6	False					50		MiddleName
NameStyle	False	NameStyle	Boolean	7	False							NameStyle
Title	True	Title	String	8	False					50		Title
HireDate	True	HireDate	DateTime	9	False				UnspecifiedLocal			HireDate
BirthDate	True	BirthDate	DateTime	10	False				UnspecifiedLocal			BirthDate
LoginID	True	LoginID	String	11	False					256		LoginID
EmailAddress	True	EmailAddress	String	12	False					50		EmailAddress
Phone	True	Phone	String	13	False					25		Phone
MaritalStatus	True	MaritalStatus	String	14	False					1		MaritalStatus
EmergencyContactName	True	EmergencyContactName	String	15	False					50		EmergencyContactName
EmergencyContactPhone	True	EmergencyContactPhone	String	16	False					25		EmergencyContactPhone
SalariedFlag	True	SalariedFlag	Boolean	17	False							SalariedFlag
Gender	True	Gender	String	18	False					1		Gender
PayFrequency	True	PayFrequency	Byte	19	False							PayFrequency
BaseRate	True	BaseRate	Decimal	20	False							BaseRate
VacationHours	True	VacationHours	Int16	21	False							VacationHours
SickLeaveHours	True	SickLeaveHours	Int16	22	False							SickLeaveHours
CurrentFlag	False	CurrentFlag	Boolean	23	False							CurrentFlag
SalesPersonFlag	False	SalesPersonFlag	Boolean	24	False							SalesPersonFlag
DepartmentName	True	DepartmentName	String	25	False					50		DepartmentName
FullName	True	FullName	String	26	False					153	True	FullName	show/hide CASE WHEN MiddleName IS NULL THEN FirstName + ' ' + LastName ELSE FirstName + ' ' + MiddleName + '.' + ' ' + LastName END
SalesTerritoryKey	True	SalesTerritoryKey	Int32	27	False							SalesTerritoryKey
GenderDesc	True	GenderDesc	String	28	False					6	True	GenderDesc	show/hide CASE WHEN Gender = 'M' THEN 'Male' ELSE 'Female' END
MaritalStatusDesc	True	MaritalStatusDesc	String	29	False					7	True	MaritalStatusDesc	show/hide CASE WHEN MaritalStatus = 'S' THEN 'Single' ELSE 'Married' END
StartDate	True	StartDate	DateTime	30	False				UnspecifiedLocal			StartDate
EndDate	True	EndDate	DateTime	31	False				UnspecifiedLocal			EndDate
Status	True	Status	String	32	False					50		Status
PayFrequencyDesc	False	PayFrequencyDesc	String	33	False					10	True	PayFrequencyDesc	show/hide CASE WHEN PayFrequency = '1' THEN 'Monthly' ELSE 'Bi-Monthly' END
EmployeeStatus	False	EmployeeStatus	String	34	False					8	True	EmployeeStatus	show/hide CASE WHEN Status = 'Current' THEN 'Active' ELSE 'Inactive' END
SimpleEndDate	True	SimpleEndDate	String	35	False					93	True	SimpleEndDate	show/hide CASE WHEN EndDate IS NULL THEN 'Active' ELSE DATENAME(mm, EndDate) + ' ' + DATENAME(dd, EndDate) + ', ' + DATENAME(yy, EndDate) END
SimpleStartDate	True	SimpleStartDate	String	36	False					93	True	SimpleStartDate	show/hide DATENAME(mm, StartDate) + ' ' + DATENAME(dd, StartDate) + ', ' + DATENAME(yy, StartDate)
SimpleHireDate	True	SimpleHireDate	String	37	False					93	True	SimpleHireDate	show/hide DATENAME(mm, HireDate) + ' ' + DATENAME(dd, HireDate) + ', ' + DATENAME(yy, HireDate)
HireYear	True	HireYear	Int32	38	False						True	HireYear	show/hide DATEPART(yy, HireDate)
SalariedFlagDesc	False	SalariedFlagDesc	String	39	False					5	True	SalariedFlagDesc	show/hide Case When SalariedFlag = 0 Then 'False' Else 'True' End
SalesPersonFlagDesc	False	SalesPersonFlagDesc	String	40	False					5	True	SalesPersonFlagDesc	show/hide Case When SalesPersonFlag = 0 Then 'False' Else 'True' End

References

parent column	child column	relation name	nested
dbo_DimEmployee.	dbo_DimEmployee.	FK_DimEmployee_DimEmployee	False
dbo_DimSalesTerritory.	dbo_DimEmployee.	FK_DimEmployee_DimSalesTerritory	False

Referenced by

parent column	child column	relation name	nested
dbo_DimEmployee.	dbo_DimEmployee.	FK_DimEmployee_DimEmployee	False
dbo_DimSalesTerritory.	dbo_DimEmployee.	FK_DimEmployee_DimSalesTerritory	False

Foreign key graph

dbo_DimEmployeedbo_DimSalesTerritorydbo_DimEmployee dbo_DimEmployeedbo_FactResellerSalesFactSalesQuota

Dependency graph

Adventure Works DWdbo_DimEmployee

Objects that dbo_DimEmployee depends on

name	object type	level
Adventure Works DW	DataSourceView	1

Table - dbo_DimEmployee

Table properties

Columns

References

Referenced by

Foreign key graph

Dependency graph

Objects that dbo_DimEmployee depends on