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