HumanResources.EmployeeDepartmentHistory - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	HumanResources
Name	EmployeeDepartmentHistory
Module	Human Resources

Employee department transfers.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		BusinessEntityID	int			HumanResources.Employee	Employee identification number. Foreign key to Employee.BusinessEntityID.
Employee identification number. Foreign key to Employee.BusinessEntityID. References: HumanResources.Employee
	2		DepartmentID	smallint			HumanResources.Department	Department in which the employee worked including currently. Foreign key to Department.DepartmentID.
Department in which the employee worked including currently. Foreign key to Department.DepartmentID. References: HumanResources.Department
	3		ShiftID	tinyint			HumanResources.Shift	Identifies which 8-hour shift the employee works. Foreign key to Shift.Shift.ID.
Identifies which 8-hour shift the employee works. Foreign key to Shift.Shift.ID. References: HumanResources.Shift
	4		StartDate	date				Date the employee started work in the department.
Date the employee started work in the department.
	5		EndDate	date				Date the employee left the department. NULL = Current department.
Date the employee left the department. NULL = Current department.
	6		ModifiedDate	datetime		Default: getdate()		Date and time the record was last updated.
Date and time the record was last updated. Default: getdate()

Relations

Foreign table		Primary table	Join	Title / Name / Description
HumanResources.EmployeeDepartmentHistory		HumanResources.Department	HumanResources.EmployeeDepartmentHistory.DepartmentID = HumanResources.Department.DepartmentID	FK_EmployeeDepartmentHistory_Department_DepartmentID Foreign key constraint referencing Department.DepartmentID.
HumanResources.EmployeeDepartmentHistory.DepartmentID = HumanResources.Department.DepartmentID Name: FK_EmployeeDepartmentHistory_Department_DepartmentID Foreign key constraint referencing Department.DepartmentID.
HumanResources.EmployeeDepartmentHistory		HumanResources.Employee	HumanResources.EmployeeDepartmentHistory.BusinessEntityID = HumanResources.Employee.BusinessEntityID	FK_EmployeeDepartmentHistory_Employee_BusinessEntityID Foreign key constraint referencing Employee.EmployeeID.
HumanResources.EmployeeDepartmentHistory.BusinessEntityID = HumanResources.Employee.BusinessEntityID Name: FK_EmployeeDepartmentHistory_Employee_BusinessEntityID Foreign key constraint referencing Employee.EmployeeID.
HumanResources.EmployeeDepartmentHistory		HumanResources.Shift	HumanResources.EmployeeDepartmentHistory.ShiftID = HumanResources.Shift.ShiftID	FK_EmployeeDepartmentHistory_Shift_ShiftID Foreign key constraint referencing Shift.ShiftID
HumanResources.EmployeeDepartmentHistory.ShiftID = HumanResources.Shift.ShiftID Name: FK_EmployeeDepartmentHistory_Shift_ShiftID Foreign key constraint referencing Shift.ShiftID
HumanResources.Employee		HumanResources.EmployeeDepartmentHistory		sdsdsd fk_EmployeeDepartmentHistory_Employee
Title: sdsdsd Name: fk_EmployeeDepartmentHistory_Employee

Unique keys

	Key name	Columns	Description
	PK_EmployeeDepartmentHistory_BusinessEntityID_StartDate_DepartmentID	BusinessEntityID, DepartmentID, ShiftID, StartDate	Primary key (clustered) constraint
Primary key (clustered) constraint

Uses

Name
HumanResources.EmployeeDepartmentHistory
HumanResources.Department
HumanResources.Employee
HumanResources.Shift

Used by

Name
HumanResources.EmployeeDepartmentHistory
HumanResources.vEmployeeDepartment
HumanResources.vEmployeeDepartmentHistory
HumanResources.Employee (sdsdsd)

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56