Table: dbo.Tax_Form_Selection
This table contains all the tax forms selected.
Columns
Name | Type | Constraints | Description
tax_form_selection_KEY | int (4) | NOT NULL | Primary key for the Tax_Form_Selection table.
tax_jurisdiction_KEY | int (4) | NOT NULL | This 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_KEY | int (4) | NOT NULL | The filing method currently in use for the form.
do_not_file | bit (1) | NOT NULL | True if a form should will not be filed and therefore never needs to display in tax processing.
tax_form_KEY | int (4) | NOT NULL | Foreign key to the tax form this tax form selection is for.
tax_form_selection_filing_instruction_type_KEY | tinyint (1) | NOT NULL | The tax form selection filing instruction type of the tax form selection

Primary key
Name | Columns | Description
PK_Tax_Form_Selection | tax_form_selection_KEY |
Unique constraints
Name | Columns | Description
UK_Tax_Form_Selection$tax_jurisdiction_KEY$tax_form_KEY | tax_jurisdiction_KEY, tax_form_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Tax_Form_Selection__Tax_Form_Selection_Filing_Instruction_Type__tax_form_selection_filing_instruction_type_KEY | tax_form_selection_filing_instruction_type_KEY | Tax_Form_Selection_Filing_Instruction_Type (tax_form_selection_filing_instruction_type_KEY) |
FK_Tax_Form_Selection__Tax_Form__tax_form_KEY | tax_form_KEY | Tax_Form (tax_form_KEY) |
FK_Tax_Form_Selection__Tax_Form_Filing_Method__tax_form_filing_method_KEY | tax_form_filing_method_KEY | Tax_Form_Filing_Method (tax_form_filing_method_KEY) |
FK_Tax_Form_Selection__Tax_Jurisdiction__tax_jurisdiction_KEY | tax_jurisdiction_KEY | Tax_Jurisdiction (tax_jurisdiction_KEY) |