Table: dbo.Tax_Jurisdiction
Columns
Name | Type | Constraints | Description
tax_jurisdiction_KEY | int (4) | NOT NULL | Primary key of this table.
description | nvarchar (160) | NOT NULL | Description of Tax_Jurisdiction record.
client_KEY | int (4) | NOT NULL | Key of associated client.
tax_jurisdiction_type_KEY | nvarchar (30) | NOT NULL | Type of tax jurisdiction.
parent__tax_jurisdiction_KEY | int (4) |  | parent__tax_jurisdiction_KEY
ste_state_code_KEY | nvarchar (4) | NOT NULL | STE state code
do_not_consolidate | bit (1) | NOT NULL | A flag to mark certain jurisdictions as not consolidated.["BR"] If this flag is true, payroll tax forms should be filed at an individual client level.

Primary key
Name | Columns | Description
PK_Tax_Jurisdiction | tax_jurisdiction_KEY |
Unique constraints
Name | Columns | Description
UK_Tax_Jurisdiction$client_KEY$description$tax_jurisdiction_type_KEY$ste_state_code_KEY | client_KEY, description, tax_jurisdiction_type_KEY, ste_state_code_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Tax_Jurisdiction__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Tax_Jurisdiction__Ste_State_Code__ste_state_code_KEY | ste_state_code_KEY | Ste_State_Code (ste_state_code_KEY) |
FK_Tax_Jurisdiction__Tax_Jurisdiction__parent__tax_jurisdiction_KEY | parent__tax_jurisdiction_KEY | Tax_Jurisdiction (tax_jurisdiction_KEY) |
FK_Tax_Jurisdiction__Tax_Jurisdiction_Type__tax_jurisdiction_type_KEY | tax_jurisdiction_type_KEY | Tax_Jurisdiction_Type (tax_jurisdiction_type_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Tax_Jurisdiction__Tax_Jurisdiction__parent__tax_jurisdiction_KEY | parent__tax_jurisdiction_KEY | Tax_Jurisdiction |
FK_Tax_Jurisdiction_Suta_Base_Rate__Tax_Jurisdiction__tax_jurisdiction_KEY | tax_jurisdiction_KEY | Tax_Jurisdiction_Suta_Base_Rate |
FK_Tax_Form_Selection__Tax_Jurisdiction__tax_jurisdiction_KEY | tax_jurisdiction_KEY | Tax_Form_Selection |
FK_Employer_Jurisdiction_Payroll_Tax_Information__Tax_Jurisdiction__tax_jurisdiction_KEY | tax_jurisdiction_KEY | Employer_Jurisdiction_Payroll_Tax_Information |
FK_Work_Location_Tax_Jurisdiction__Tax_Jurisdiction__tax_jurisdiction_KEY | tax_jurisdiction_KEY | Work_Location_Tax_Jurisdiction |
FK_Print_W3_Selection__Tax_Jurisdiction__local_1__tax_jurisdiction_KEY | local_1__tax_jurisdiction_KEY | Print_W3_Selection |
FK_Print_W3_Selection__Tax_Jurisdiction__local_2__tax_jurisdiction_KEY | local_2__tax_jurisdiction_KEY | Print_W3_Selection |
FK_Print_W3_Selection__Tax_Jurisdiction__state_1__tax_jurisdiction_KEY | state_1__tax_jurisdiction_KEY | Print_W3_Selection |
FK_Print_W3_Selection__Tax_Jurisdiction__state_2__tax_jurisdiction_KEY | state_2__tax_jurisdiction_KEY | Print_W3_Selection |
FK_Tax_Jurisdiction_State_Setting__Tax_Jurisdiction__tax_jurisdiction_KEY | tax_jurisdiction_KEY | Tax_Jurisdiction_State_Setting |
FK_Client_Tax_Item__Tax_Jurisdiction__tax_jurisdiction_KEY | tax_jurisdiction_KEY | Client_Tax_Item |
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Tax_Jurisdiction__tax_jurisdiction_KEY | tax_jurisdiction_KEY | Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override |
FK_Print_W2_Selection__Tax_Jurisdiction__local_1__tax_jurisdiction_KEY | local_1__tax_jurisdiction_KEY | Print_W2_Selection |
FK_Print_W2_Selection__Tax_Jurisdiction__local_2__tax_jurisdiction_KEY | local_2__tax_jurisdiction_KEY | Print_W2_Selection |
FK_Print_W2_Selection__Tax_Jurisdiction__state_1__tax_jurisdiction_KEY | state_1__tax_jurisdiction_KEY | Print_W2_Selection |
FK_Print_W2_Selection__Tax_Jurisdiction__state_2__tax_jurisdiction_KEY | state_2__tax_jurisdiction_KEY | Print_W2_Selection |
FK_Employee_W2_Tax_Jurisdiction_Override__Tax_Jurisdiction__tax_jurisdiction_KEY | tax_jurisdiction_KEY | Employee_W2_Tax_Jurisdiction_Override |
FK_Employee_Tax_Jurisdiction__Tax_Jurisdiction__tax_jurisdiction_KEY | tax_jurisdiction_KEY | Employee_Tax_Jurisdiction |