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.
The EmployeeDepartmentHistory table is contained in the HumanResources schema.
Employee identification number. Foreign key to Employee.EmployeeID.
Department in which the employee works or worked. Foreign key to Department.DepartmentID.
Work shift, such as day, evening, or night, to which the employee is assigned. Foreign key to Shift.ShiftID.
Date the employee started work in the department.
Date the employee left the department.
NULL = Current department
Date and time the row was last updated.