.png)
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.
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. |
