| Table: dbo.Client_W2_Filing | |||
| Client W2 Filing table | |||
| Columns | |||
| Name | Type | Constraints | Description |
| client_w2_filing_KEY | int (4) | NOT NULL | Primary key for this table |
| client_KEY | int (4) | NOT NULL | Key of client to which this client w2 filing belongs |
| w2_override_type_KEY | int (4) | NOT NULL | w2 override type KEY |
| period_end_year | smallint (2) | NOT NULL | period end year for the client w2 filing |
| Primary key | |||
| Name | Columns | Description | |
| PK_Client_W2_Filing | client_w2_filing_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_Client_W2_Filing$client_KEY$w2_override_type_KEY$period_end_year | client_KEY, w2_override_type_KEY, period_end_year | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Client_W2_Filing__Client__client_KEY | client_KEY | Client (client_KEY) | FOREIGN KEY constraint of client_KEY for the Client_W2_Filing table |
| FK_Client_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 Client_W2_Filing table |
| Incoming foreign keys | |||
| Name | Columns | Referencing table | Description |
| FK_Client_W2_State_Override__Client_W2_Filing__client_w2_filing_KEY | client_w2_filing_KEY | Client_W2_State_Override | FOREIGN KEY constraint of client_w2_filing_KEY for the Client_W2_State_Override table |
| FK_Client_W2_Override__Client_W2_Filing__client_w2_filing_KEY | client_w2_filing_KEY | Client_W2_Override | FOREIGN KEY constraint of client_w2_filing_KEY for the Client_W2_Override table |