Table: dbo.Employee_W2_Filing
This table stores the period end years for each employee that have overrides for each w2 filing type
Columns
Name | Type | Constraints | Description
employee_w2_filing_KEY | int (4) | NOT NULL | Primary key of this table
employee_KEY | int (4) | NOT NULL | Employee key corresponding to the employee whose data has been overridden
w2_override_type_KEY | int (4) | NOT NULL | Distinguishes the type of filing which has been overridden
period_end_year | smallint (2) | NOT NULL | Distinguishes the employees based on the period end year for the respective overrides

Primary key
Name | Columns | Description
PK_Employee_W2_Filing | employee_w2_filing_KEY |
Unique constraints
Name | Columns | Description
UK_Employee_W2_Filing$employee_KEY$w2_override_type_KEY$period_end_year | employee_KEY, w2_override_type_KEY, period_end_year |

Foreign keys
Name | Columns | Referenced table | Description
FK_Employee_W2_Filing__Employee__employee_KEY | employee_KEY | Employee (employee_KEY) | FOREIGN KEY constraint of employee_KEY for the Employee_W2_Filing table which ensures we have a valid employee
FK_Employee_W2_Filing__W2_Override_Type__w2_override_type_KEY | w2_override_type_KEY | W2_Override_Type (w2_override_type_KEY) | FOREIGN KEY constraint of w2_override_type_KEY for the Employee_W2_Filing table which ensures valid w2 override type

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Employee_W2_Box_12_Override__Employee_W2_Filing__employee_w2_filing_KEY | employee_w2_filing_KEY | Employee_W2_Box_12_Override | FOREIGN KEY constraint of employee_w2_filing_KEY for the Employee_W2_Box_12_Override table which ensures the Employee_W2_Box_12_Override is for a valid filing
FK_Employee_W2_Box_14_Override__Employee_W2_Filing__employee_w2_filing_KEY | employee_w2_filing_KEY | Employee_W2_Box_14_Override | FOREIGN KEY constraint of employee_w2_filing_KEY for the Employee_W2_Box_14_Override table which ensures the Employee_W2_Box_14_Override is for a valid filing
FK_Employee_W2_Override__Employee_W2_Filing__employee_w2_filing_KEY | employee_w2_filing_KEY | Employee_W2_Override | FOREIGN KEY constraint of employee_w2_filing_KEY for the Employee_W2_Override table which ensures the Employee_W2_Override is for a valid filing
FK_Employee_W2_Tax_Jurisdiction_Override__Employee_W2_Filing__employee_w2_filing_KEY | employee_w2_filing_KEY | Employee_W2_Tax_Jurisdiction_Override | FOREIGN KEY constraint of employee_w2_filing_KEY for the Employee_W2_Tax_Jurisdiction_Override table which ensures the Employee_W2_Tax_Jurisdiction_Override is for a valid filing