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