| Column | Data Type | Nullable | Default | Description / PK / Index |
| EmployeeID | int | not null | | Primary key for Employee records.
PK_Employee_EmployeeID |
| NationalIDNumber | nvarchar(15) | not null | | Unique national identification number such as a social security number.
AK_Employee_NationalIDNumber |
| ContactID | int | not null | | Identifies the employee in the Contact table. Foreign key to Contact.ContactID.
|
| LoginID | nvarchar(256) | not null | | Network login.
AK_Employee_LoginID |
| ManagerID | int | null | | Manager to whom the employee is assigned. Foreign Key to Employee.M
IX_Employee_ManagerID |
| 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 | | Employee hired on this date.
|
| SalariedFlag | dbo.Flag | not null | ((1)) | Job classification. 0 = Hourly, not exempt from collective bargaining. 1 = Salaried, exempt from collective bargaining.
|
| VacationHours | smallint | not null | ((0)) | Number of available vacation hours.
|
| SickLeaveHours | smallint | not null | ((0)) | Number of available sick leave hours.
|
| CurrentFlag | dbo.Flag | not null | ((1)) | 0 = Inactive, 1 = Active
|
| rowguid | uniqueidentifier | not null | (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
AK_Employee_rowguid |
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated.
|