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) |