Generated using SQL Data Dictionary demo version.


Table HumanResources.EmployeeDepartmentHistory (296 rows)


Employee department transfers.


  Column Data Type Identity Nullable Default
PK, FK BusinessEntityID int
Employee identification number. Foreign key to Employee.BusinessEntityID.
PK, FK DepartmentID smallint
Department in which the employee worked including currently. Foreign key to Department.DepartmentID.
PK, FK ShiftID tinyint
Identifies which 8-hour shift the employee works. Foreign key to Shift.Shift.ID.
PK StartDate date
Date the employee started work in the department.
EndDate date X
Date the employee left the department. NULL = Current department.
ModifiedDate datetime getdate()
Date and time the record was last updated.

Indexes:


References:


Used by: