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