Table: dbo.Employee_W2_Verification_Dates
This table stores the dates the employee information has been verified for w2s
Columns
NameTypeConstraintsDescription
employee_w2_verification_dates_KEYint (4)NOT NULL
employee_KEYint (4)NOT NULLThe employee who has been verified.
verification_datesmalldatetime (4)The date the employee information was verified.
year_verifiedint (4)NOT NULLThe year of the verified information.
Primary key
NameColumnsDescription
PK_Employee_W2_Verification_Datesemployee_w2_verification_dates_KEY
Unique constraints
NameColumnsDescription
UK_Employee_W2_Verification_Dates$employee_KEY$year_verifiedemployee_KEY, year_verified
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_W2_Verification_Dates__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)

Schema diagram