EmployeeDepartmentHistory Table (AdventureWorks)
Contains current and historical data about employees and the departments in which they work. The department in which the employee is currently working is identified by a null value in the EndDate column.
EmployeeDepartmentHistory Table Definition
The EmployeeDepartmentHistory table is contained in the HumanResources schema.
| Column | Data type | Nullability | Description |
|---|---|---|---|
EmployeeID |
int |
Not null |
Employee identification number. Foreign key to Employee.EmployeeID. |
DepartmentID |
smallint |
Not null |
Department in which the employee works or worked. Foreign key to Department.DepartmentID. |
ShiftID |
tinyint |
Not null |
Work shift, such as day, evening, or night, to which the employee is assigned. Foreign key to Shift.ShiftID. |
StartDate |
datetime |
Not null |
Date the employee started work in the department. |
EndDate |
datetime |
Null |
Date the employee left the department. NULL = Current department |
ModifiedDate |
datetime |
Not null |
Date and time the row was last updated. |
See Also
Reference
Department Table (AdventureWorks)
Employee Table (AdventureWorks)
Shift Table (AdventureWorks)
Other Resources
AdventureWorks Data Dictionary