| Field Name | Type and Size |
|---|---|
| EmployeeID | int NOT NULL |
| Title | nvarchar(8) NULL |
| FirstName | Name NOT NULL |
| MiddleName | Name NULL |
| LastName | Name NOT NULL |
| Suffix | nvarchar(10) NULL |
| Shift | Name NOT NULL |
| Department | Name NOT NULL |
| GroupName | Name NOT NULL |
| StartDate | datetime NOT NULL |
| EndDate | datetime NULL |