Table: dbo.Tax_Jurisdiction_Suta_Base_Rate
Columns
Name | Type | Constraints | Description
tax_jurisdiction_suta_base_rate_KEY | int (4) | NOT NULL | Primary key for this table
tax_jurisdiction_KEY | int (4) | NOT NULL | Parent tax jurisdiction
effective_date | smalldatetime (4) | NOT NULL | Date the rate suta rate entered is effective
base_rate | decimal (5, 4) | NOT NULL | Base tax rate for state unemployment tax
reimburse_suta_charges | bit (1) | NOT NULL | Client reimburses state for SUTA charges made by employees drawing on their accounts rather than paying tax.
use_illinois_suta_fixed_rate | bit (1) | NOT NULL | Flag indicating that Illinois SUTA calculation will use the fixed rate instead of this custom rate.
use_alternate_suta_wage_limit | bit (1) | NOT NULL | Indicates that the client uses the alternate suta wage limit
nevada_bond_surcharge_rate | decimal (5, 4) | NOT NULL | The rate used for the Nevada Bond Surcharge.

Primary key
Name | Columns | Description
PK_Tax_Jurisdiction_Suta_Base_Rate | tax_jurisdiction_suta_base_rate_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Tax_Jurisdiction_Suta_Base_Rate__Tax_Jurisdiction__tax_jurisdiction_KEY | tax_jurisdiction_KEY | Tax_Jurisdiction (tax_jurisdiction_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Tax_Jurisdiction_Suta_Supplemental_Rate__Tax_Jurisdiction_Suta_Base_Rate__tax_jurisdiction_suta_base_rate_KEY | tax_jurisdiction_suta_base_rate_KEY | Tax_Jurisdiction_Suta_Supplemental_Rate |