Table: dbo.Tax_Form_Selection
This table contains all the tax forms selected.
Columns
NameTypeConstraintsDescription
tax_form_selection_KEYint (4)NOT NULLPrimary key for the Tax_Form_Selection table.
tax_jurisdiction_KEYint (4)NOT NULLThis is a bit confusing. The rules depend on the tax_form_type of the row's tax_form, based on the tax_form_KEY. For types that are not W-2, the related Tax_Jurisdiction must have tax_jurisdiction_type as one of Federal or State. For example, for a reconciliation form associated with a County, the actual related Tax_Jurisdicton row will be the parent Tax_Jurisdiction of type State. For forms of type W-2, smaller jurisdiction_type related rows are valid, such as City, County, Municipality and School District
tax_form_filing_method_KEYint (4)NOT NULLThe filing method currently in use for the form.
do_not_filebit (1)NOT NULLTrue if a form should will not be filed and therefore never needs to display in tax processing.
tax_form_KEYint (4)NOT NULLForeign key to the tax form this tax form selection is for.
tax_form_selection_filing_instruction_type_KEYtinyint (1)NOT NULLThe tax form selection filing instruction type of the tax form selection
Primary key
NameColumnsDescription
PK_Tax_Form_Selectiontax_form_selection_KEY
Unique constraints
NameColumnsDescription
UK_Tax_Form_Selection$tax_jurisdiction_KEY$tax_form_KEYtax_jurisdiction_KEY, tax_form_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Tax_Form_Selection__Tax_Form_Selection_Filing_Instruction_Type__tax_form_selection_filing_instruction_type_KEYtax_form_selection_filing_instruction_type_KEYTax_Form_Selection_Filing_Instruction_Type (tax_form_selection_filing_instruction_type_KEY)
FK_Tax_Form_Selection__Tax_Form__tax_form_KEYtax_form_KEYTax_Form (tax_form_KEY)
FK_Tax_Form_Selection__Tax_Form_Filing_Method__tax_form_filing_method_KEYtax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)
FK_Tax_Form_Selection__Tax_Jurisdiction__tax_jurisdiction_KEYtax_jurisdiction_KEYTax_Jurisdiction (tax_jurisdiction_KEY)

Schema diagram