Table: dbo.Tax_Jurisdiction
Columns
NameTypeConstraintsDescription
tax_jurisdiction_KEYint (4)NOT NULLPrimary key of this table.
descriptionnvarchar (160)NOT NULLDescription of Tax_Jurisdiction record.
client_KEYint (4)NOT NULLKey of associated client.
tax_jurisdiction_type_KEYnvarchar (30)NOT NULLType of tax jurisdiction.
parent__tax_jurisdiction_KEYint (4)parent__tax_jurisdiction_KEY
ste_state_code_KEYnvarchar (4)NOT NULLSTE state code
do_not_consolidatebit (1)NOT NULLA 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
NameColumnsDescription
PK_Tax_Jurisdictiontax_jurisdiction_KEY
Unique constraints
NameColumnsDescription
UK_Tax_Jurisdiction$client_KEY$description$tax_jurisdiction_type_KEY$ste_state_code_KEYclient_KEY, description, tax_jurisdiction_type_KEY, ste_state_code_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Tax_Jurisdiction__Client__client_KEYclient_KEYClient (client_KEY)
FK_Tax_Jurisdiction__Ste_State_Code__ste_state_code_KEYste_state_code_KEYSte_State_Code (ste_state_code_KEY)
FK_Tax_Jurisdiction__Tax_Jurisdiction__parent__tax_jurisdiction_KEYparent__tax_jurisdiction_KEYTax_Jurisdiction (tax_jurisdiction_KEY)
FK_Tax_Jurisdiction__Tax_Jurisdiction_Type__tax_jurisdiction_type_KEYtax_jurisdiction_type_KEYTax_Jurisdiction_Type (tax_jurisdiction_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Tax_Jurisdiction__Tax_Jurisdiction__parent__tax_jurisdiction_KEYparent__tax_jurisdiction_KEYTax_Jurisdiction
FK_Tax_Jurisdiction_Suta_Base_Rate__Tax_Jurisdiction__tax_jurisdiction_KEYtax_jurisdiction_KEYTax_Jurisdiction_Suta_Base_Rate
FK_Tax_Form_Selection__Tax_Jurisdiction__tax_jurisdiction_KEYtax_jurisdiction_KEYTax_Form_Selection
FK_Employer_Jurisdiction_Payroll_Tax_Information__Tax_Jurisdiction__tax_jurisdiction_KEYtax_jurisdiction_KEYEmployer_Jurisdiction_Payroll_Tax_Information
FK_Work_Location_Tax_Jurisdiction__Tax_Jurisdiction__tax_jurisdiction_KEYtax_jurisdiction_KEYWork_Location_Tax_Jurisdiction
FK_Print_W3_Selection__Tax_Jurisdiction__local_1__tax_jurisdiction_KEYlocal_1__tax_jurisdiction_KEYPrint_W3_Selection
FK_Print_W3_Selection__Tax_Jurisdiction__local_2__tax_jurisdiction_KEYlocal_2__tax_jurisdiction_KEYPrint_W3_Selection
FK_Print_W3_Selection__Tax_Jurisdiction__state_1__tax_jurisdiction_KEYstate_1__tax_jurisdiction_KEYPrint_W3_Selection
FK_Print_W3_Selection__Tax_Jurisdiction__state_2__tax_jurisdiction_KEYstate_2__tax_jurisdiction_KEYPrint_W3_Selection
FK_Tax_Jurisdiction_State_Setting__Tax_Jurisdiction__tax_jurisdiction_KEYtax_jurisdiction_KEYTax_Jurisdiction_State_Setting
FK_Client_Tax_Item__Tax_Jurisdiction__tax_jurisdiction_KEYtax_jurisdiction_KEYClient_Tax_Item
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Tax_Jurisdiction__tax_jurisdiction_KEYtax_jurisdiction_KEYEmployee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override
FK_Print_W2_Selection__Tax_Jurisdiction__local_1__tax_jurisdiction_KEYlocal_1__tax_jurisdiction_KEYPrint_W2_Selection
FK_Print_W2_Selection__Tax_Jurisdiction__local_2__tax_jurisdiction_KEYlocal_2__tax_jurisdiction_KEYPrint_W2_Selection
FK_Print_W2_Selection__Tax_Jurisdiction__state_1__tax_jurisdiction_KEYstate_1__tax_jurisdiction_KEYPrint_W2_Selection
FK_Print_W2_Selection__Tax_Jurisdiction__state_2__tax_jurisdiction_KEYstate_2__tax_jurisdiction_KEYPrint_W2_Selection
FK_Employee_W2_Tax_Jurisdiction_Override__Tax_Jurisdiction__tax_jurisdiction_KEYtax_jurisdiction_KEYEmployee_W2_Tax_Jurisdiction_Override
FK_Employee_Tax_Jurisdiction__Tax_Jurisdiction__tax_jurisdiction_KEYtax_jurisdiction_KEYEmployee_Tax_Jurisdiction

Schema diagram