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