Export (0) Print
Expand All
Expand Minimize

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft