Table: dbo.Tax_Jurisdiction_State_Setting
Columns
NameTypeConstraintsDescription
tax_jurisdiction_KEYint (4)NOT NULLReference to parent tax jurisdiction
withholding_idnvarchar (40)NOT NULLWithholding identification number used by state
suta_idnvarchar (40)NOT NULLState unemployment tax identification number
withholding_deposit_schedule_KEYint (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_nexusbit (1)NOT NULLFlag to indicate if the client has a business presence in the state - used by the Symetry Tax Engine
use_whole_dollar_roundingbit (1)NOT NULLFlag to indicate if amounts are rounded to whole dollars
workers_compensation_idnvarchar (40)NOT NULLState Workers Compensation ID
business_numbernvarchar (40)NOT NULLFormatted number assigned by the state to identify the business. Size and format are state dependant. Only applicable to certain states.
default__vendor_KEYint (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_assessmentbit (1)NOT NULLFlag to indicate if the employer pays the full Workers Benefit Fund assessment.
w2_psd_codenvarchar (18)NOT NULLPolitical subdivison code used for Pennsylvania W-2s.
governmental_reimbursable_employerbit (1)NOT NULLFlag to indicate if the employer is a governmental reimbursable employer.
employer_pays_full_employee_pfml_sharebit (1)NOT NULLFlag to indicate if the employer pays the full employee PFML share.
Primary key
NameColumnsDescription
PK_Tax_Jurisdiction_State_Setting$tax_jurisdiction_KEYtax_jurisdiction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Tax_Jurisdiction_State_Setting__Tax_Jurisdiction__tax_jurisdiction_KEYtax_jurisdiction_KEYTax_Jurisdiction (tax_jurisdiction_KEY)
FK_Tax_Jurisdiction_State_Setting__Vendor__default__vendor_KEYdefault__vendor_KEYVendor (vendor_KEY)
FK_Tax_Jurisdiction_State_Setting__Withholding_Deposit_Schedule__withholding_deposit_schedule_KEYwithholding_deposit_schedule_KEYWithholding_Deposit_Schedule (withholding_deposit_schedule_KEY)

Schema diagram