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
NameTypeConstraintsDescription
conversion_wizard_local_withholding_KEYint (4)NOT NULLThe primary key for this table.
source_tax_descriptionnvarchar (50)NOT NULLDescription of a tax currently being used by a third party or CSA that will need to be mapped.
source_state_abbreviationnvarchar (4)NOT NULLState abbreviation for the source tax information.
source_tax_typenvarchar (50)NOT NULLThe tax type associated with the source information.
citynvarchar (60)NOT NULLThe city to be used for the local tax.
postal_codenvarchar (20)NOT NULLThe zip code to be used to generate the lcoal tax.
countynvarchar (50)NOT NULLThe county to be used in local tax generation.
school_district_descriptionnvarchar (100)NOT NULLThe school district description to be used in local tax generation.
municipality_descriptionnvarchar (100)NOT NULLThe municipality description to be used in local tax generation.
employee_tax_descriptionnvarchar (200)NOT NULLThe description of the local withholding tax selected for use in SBPR. This is the tax description from the Symmetry calc engine.
employer_tax_descriptionnvarchar (200)NOT NULLThe 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_uidnvarchar (60)NOT NULLThe employee tax that the user decided to map the source information to. Stores the tax uid provided by Symmetry.
employer_tax_ste_tax_uidnvarchar (60)NOT NULLThe employer tax that the user decided to map the source information to. Stores the tax uid provided by Symmetry.
Primary key
NameColumnsDescription
PK_Conversion_Wizard_Local_Withholdingconversion_wizard_local_withholding_KEY
Unique constraints
NameColumnsDescription
UK_Conversion_Wizard_Local_Withholding$source_tax_description$source_state_abbreviation$source_tax_typesource_tax_description, source_state_abbreviation, source_tax_type

Schema diagram