Table: dbo.Tax_Jurisdiction_State_Setting
Columns
Name | Type | Constraints | Description
tax_jurisdiction_KEY | int (4) | NOT NULL | Reference to parent tax jurisdiction
withholding_id | nvarchar (40) | NOT NULL | Withholding identification number used by state
suta_id | nvarchar (40) | NOT NULL | State unemployment tax identification number
withholding_deposit_schedule_KEY | int (4) |  | DANGER!!! Not what it seems! In some cases foreign key to the Withholding_Deposit_Schedule table, but in others, the value is actually the primary surrogate key into the Vendor_Agent_Payment_Schedule table and is a vendor_agent_payment_schedule_KEY, which works only because the former table has nearly a superset of valid keys from the latter. Here be dragons, they are hungry, and you are coated in ketchup.
has_nexus | bit (1) | NOT NULL | Flag to indicate if the client has a business presence in the state - used by the Symetry Tax Engine
use_whole_dollar_rounding | bit (1) | NOT NULL | Flag to indicate if amounts are rounded to whole dollars
workers_compensation_id | nvarchar (40) | NOT NULL | State Workers Compensation ID
business_number | nvarchar (40) | NOT NULL | Formatted number assigned by the state to identify the business. Size and format are state dependant. Only applicable to certain states.
default__vendor_KEY | int (4) |  | This is the default vendor key to use when adding a new tax item that applies to the state. This is nullable since a default vendor KEY does not need to be selected for a state.
employer_pays_full_wbf_assessment | bit (1) | NOT NULL | Flag to indicate if the employer pays the full Workers Benefit Fund assessment.
w2_psd_code | nvarchar (18) | NOT NULL | Political subdivison code used for Pennsylvania W-2s.
governmental_reimbursable_employer | bit (1) | NOT NULL | Flag to indicate if the employer is a governmental reimbursable employer.
employer_pays_full_employee_pfml_share | bit (1) | NOT NULL | Flag to indicate if the employer pays the full employee PFML share.

Primary key
Name | Columns | Description
PK_Tax_Jurisdiction_State_Setting$tax_jurisdiction_KEY | tax_jurisdiction_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Tax_Jurisdiction_State_Setting__Tax_Jurisdiction__tax_jurisdiction_KEY | tax_jurisdiction_KEY | Tax_Jurisdiction (tax_jurisdiction_KEY) |
FK_Tax_Jurisdiction_State_Setting__Vendor__default__vendor_KEY | default__vendor_KEY | Vendor (vendor_KEY) |
FK_Tax_Jurisdiction_State_Setting__Withholding_Deposit_Schedule__withholding_deposit_schedule_KEY | withholding_deposit_schedule_KEY | Withholding_Deposit_Schedule (withholding_deposit_schedule_KEY) |