Table: dbo.Tax_Jurisdiction_Suta_Base_Rate
Columns
NameTypeConstraintsDescription
tax_jurisdiction_suta_base_rate_KEYint (4)NOT NULLPrimary key for this table
tax_jurisdiction_KEYint (4)NOT NULLParent tax jurisdiction
effective_datesmalldatetime (4)NOT NULLDate the rate suta rate entered is effective
base_ratedecimal (5, 4)NOT NULLBase tax rate for state unemployment tax
reimburse_suta_chargesbit (1)NOT NULLClient reimburses state for SUTA charges made by employees drawing on their accounts rather than paying tax.
use_illinois_suta_fixed_ratebit (1)NOT NULLFlag indicating that Illinois SUTA calculation will use the fixed rate instead of this custom rate.
use_alternate_suta_wage_limitbit (1)NOT NULLIndicates that the client uses the alternate suta wage limit
nevada_bond_surcharge_ratedecimal (5, 4)NOT NULLThe rate used for the Nevada Bond Surcharge.
Primary key
NameColumnsDescription
PK_Tax_Jurisdiction_Suta_Base_Ratetax_jurisdiction_suta_base_rate_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Tax_Jurisdiction_Suta_Base_Rate__Tax_Jurisdiction__tax_jurisdiction_KEYtax_jurisdiction_KEYTax_Jurisdiction (tax_jurisdiction_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Tax_Jurisdiction_Suta_Supplemental_Rate__Tax_Jurisdiction_Suta_Base_Rate__tax_jurisdiction_suta_base_rate_KEYtax_jurisdiction_suta_base_rate_KEYTax_Jurisdiction_Suta_Supplemental_Rate

Schema diagram