Employee Table (AdventureWorks)

Contains employee information such as their national identification number, work title, and vacation and sick leave hours. Employee names are stored in the Contact table.

Employee Table Definition

The Employee table is contained in the HumanResources schema.

Column	Data type	Nullability	Description
EmployeeID	int	Not null	Primary key for employee rows.
NationalIDNumber	nvarchar(15)	Not null	Unique national identification number such as a social security number.
ContactID	int	Not null	Identifies the employee in the Contact table. Foreign key to Contact.ContactID.
LoginID	nvarchar(256)	Not null	Network logon.
ManagerID	int	Null	Manager to whom the employee is assigned. Foreign key to Employee.EmployeeID.
Title	nvarchar(50)	Not null	Work title such as Buyer or Sales Representative.
BirthDate	datetime	Not null	Date of birth.
MaritalStatus	nchar(1)	Not null	M = Married S = Single
Gender	nchar(1)	Not null	M = Male F = Female
HireDate	datetime	Not Null	Date on which the employee was hired.
SalariedFlag	Flag (user-defined type) bit	Not null	Job classification. 0 = Hourly, not exempt from collective bargaining. 1 = Salaried, exempt from collective bargaining.
VacationHours	smallint	Not null	Number of available vacation hours.
SickLeaveHours	smallint	Not null	Number of available sick leave hours.
CurrentFlag	Flag (user-defined type) bit	Not null	0 = Inactive 1 = Active
rowguid	uniqueidentifier ROWGUIDCOL	Not null	ROWGUIDCOL number that uniquely identifies the row. Used to support a merge replication sample.
ModifiedDate	datetime	Not null	Date and time the row was last updated.

See Also

Reference

Address Table (AdventureWorks)
Contact Table (AdventureWorks)
Department Table (AdventureWorks)
EmployeeDepartmentHistory Table (AdventureWorks)
EmployeePayHistory Table (AdventureWorks)
JobCandidate Table (AdventureWorks)

Concepts

EmployeeAddress Table (AdventureWorks)

Other Resources

AdventureWorks Data Dictionary

Help and Information

Getting SQL Server 2005 Assistance