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.
employer_pays_full_ccc_tax | bit (1) | NOT NULL | Flag to indicate if the employer pays the full CCC tax. 1 = employer pays. 0 = employee pays.
employer_subject_pfml_parental_leave_only | bit (1) | NOT NULL | Flag to indicate if the employer subject to PFML parental leave only tax. 1 = reduced coverage, reduced rate. 0 = full coverage, full rate (unless exempt).
has_25_or_more_employees | bit (1) | NOT NULL | Indicates whether the client has 25 or more employees in this state jurisdiction (1 = yes, 0 = no).
pfml_small_employer | bit (1) | NOT NULL | Indicates if the employer qualifies as a PFML small employer for Minnesota

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) |