Table: dbo.Conversion_Wizard_Local_Withholding
Stores local withholding conversion settings, both the source information and what it will be mapped to in SBPR.
Columns
Name | Type | Constraints | Description
conversion_wizard_local_withholding_KEY | int (4) | NOT NULL | The primary key for this table.
source_tax_description | nvarchar (50) | NOT NULL | Description of a tax currently being used by a third party or CSA that will need to be mapped.
source_state_abbreviation | nvarchar (4) | NOT NULL | State abbreviation for the source tax information.
source_tax_type | nvarchar (50) | NOT NULL | The tax type associated with the source information.
city | nvarchar (60) | NOT NULL | The city to be used for the local tax.
postal_code | nvarchar (20) | NOT NULL | The zip code to be used to generate the lcoal tax.
county | nvarchar (70) | NOT NULL | The county to be used in local tax generation.
school_district_description | nvarchar (100) | NOT NULL | The school district description to be used in local tax generation.
municipality_description | nvarchar (100) | NOT NULL | The municipality description to be used in local tax generation.
employee_tax_description | nvarchar (200) | NOT NULL | The description of the local withholding tax selected for use in SBPR. This is the tax description from the Symmetry calc engine.
employer_tax_description | nvarchar (200) | NOT NULL | The description of the local withholding employer tax selected for use in SBPR. This is the tax description from the Symmetry calc engine.
employee_tax_ste_tax_uid | nvarchar (60) | NOT NULL | The employee tax that the user decided to map the source information to. Stores the tax uid provided by Symmetry.
employer_tax_ste_tax_uid | nvarchar (60) | NOT NULL | The employer tax that the user decided to map the source information to. Stores the tax uid provided by Symmetry.

Primary key
Name | Columns | Description
PK_Conversion_Wizard_Local_Withholding | conversion_wizard_local_withholding_KEY |
Unique constraints
Name | Columns | Description
UK_Conversion_Wizard_Local_Withholding$source_tax_description$source_state_abbreviation$source_tax_type | source_tax_description, source_state_abbreviation, source_tax_type |