| Table: dbo.Client_W2_State_Override | |||
| The table used to store the overrides for a Client's state id numbers. | |||
| Columns | |||
| Name | Type | Constraints | Description |
| client_w2_state_override_KEY | int (4) | NOT NULL | Primary key. |
| ste_state_code_KEY | nvarchar (4) | NOT NULL | Foreign key into the Ste state code table. |
| state_id_number | nvarchar (50) | NOT NULL | The override for the client's state id. |
| client_w2_state_override_type_KEY | int (4) | NOT NULL | The type of override. |
| client_w2_filing_KEY | int (4) | NOT NULL | client w2 filing KEY |
| Primary key | |||
| Name | Columns | Description | |
| PK_Client_W2_State_Override | client_w2_state_override_KEY | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Client_W2_State_Override__Client_W2_Filing__client_w2_filing_KEY | client_w2_filing_KEY | Client_W2_Filing (client_w2_filing_KEY) | FOREIGN KEY constraint of client_w2_filing_KEY for the Client_W2_State_Override table |
| FK_Client_W2_State_Override__Client_W2_State_Override_Type__client_w2_state_override_type_KEY | client_w2_state_override_type_KEY | Client_W2_State_Override_Type (client_w2_state_override_type_KEY) | |
| FK_Client_W2_State_Override__Ste_State_Code__ste_state_code_KEY | ste_state_code_KEY | Ste_State_Code (ste_state_code_KEY) | |