| Table: dbo.Employee_W2_Verification_Dates | |||
| This table stores the dates the employee information has been verified for w2s | |||
| Columns | |||
| Name | Type | Constraints | Description |
| employee_w2_verification_dates_KEY | int (4) | NOT NULL | |
| employee_KEY | int (4) | NOT NULL | The employee who has been verified. |
| verification_date | smalldatetime (4) | The date the employee information was verified. | |
| year_verified | int (4) | NOT NULL | The year of the verified information. |
| Primary key | |||
| Name | Columns | Description | |
| PK_Employee_W2_Verification_Dates | employee_w2_verification_dates_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_Employee_W2_Verification_Dates$employee_KEY$year_verified | employee_KEY, year_verified | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Employee_W2_Verification_Dates__Employee__employee_KEY | employee_KEY | Employee (employee_KEY) | |