Table: dbo.Employee_Political_Subdivision_Code_Override
This table stores override values for employee political subdivision codes. The employee can have at most one override for each client tax item.
Columns
Name | Type | Constraints | Description
employee_KEY | int (4) | NOT NULL | The key to the employee. This along with the client_tax_item_KEY make up the primary key
client_tax_item_KEY | int (4) | NOT NULL | The client tax item key associated to the ste tax code for this political subdivision code. This along with the employee_KEY make up the primary key
political_subdivision_code_override | varchar (6) |  | The value for the political subdivision code override.
employee_political_subdivision_code_override_KEY | int (4) | NOT NULL | The primary key to the table.

Primary key
Name | Columns | Description
PK_Employee_Political_Subdivision_Code_Override | employee_political_subdivision_code_override_KEY |
Unique constraints
Name | Columns | Description
UK_Employee_Political_Subdivision_Code_Override$employee_KEY$client_tax_item_KEY | employee_KEY, client_tax_item_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Employee_Political_Subdivision_Code_Override__Client_Tax_Item__client_tax_item_KEY | client_tax_item_KEY | Client_Tax_Item (client_tax_item_KEY) |
FK_Employee_Political_Subdivision_Code_Override__Employee__employee_KEY | employee_KEY | Employee (employee_KEY) |