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 |