Table: dbo.Tax_Form
This poorly named table actually describes all tax form COLLATIONS currently in the system
Columns
Name | Type | Constraints | Description
tax_form_KEY | int (4) | NOT NULL | Primary Key
collation_item | nvarchar (100) | NOT NULL | Collation item name.
tax_form_type_KEY | int (4) | NOT NULL | Tax form type key.
ste_state_code_KEY | nvarchar (4) | NOT NULL | Ste State Code key from symmetry.
is_pending_approval | bit (1) | NOT NULL | Whether or not the form is pending approval. False is the normal case and indicates that the form has already been approved.

Primary key
Name | Columns | Description
PK_Tax_Form | tax_form_KEY |
Unique constraints
Name | Columns | Description
UK_Tax_Form$collation_item$tax_form_type_KEY$ste_state_code_KEY | collation_item, tax_form_type_KEY, ste_state_code_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Tax_Form__Ste_State_Code__ste_state_code_KEY | ste_state_code_KEY | Ste_State_Code (ste_state_code_KEY) |
FK_Tax_Form__Tax_Form_Type__tax_form_type_KEY | tax_form_type_KEY | Tax_Form_Type (tax_form_type_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Tax_Form_Filing__Tax_Form__tax_form_KEY | tax_form_KEY | Tax_Form_Filing | FOREIGN KEY constraint of tax_form_KEY for the Tax_Form_Filing table
FK_Elf_File__Tax_Form__tax_form_KEY | tax_form_KEY | Elf_File |
FK_W2_Rendered_Template__Tax_Form__tax_form_KEY | tax_form_KEY | W2_Rendered_Template |
FK_Processed_Tax_Form_Liability__Tax_Form__tax_form_KEY | tax_form_KEY | Processed_Tax_Form_Liability |
FK_Processed_Tax_Form__Tax_Form__tax_form_KEY | tax_form_KEY | Processed_Tax_Form |
FK_Client_W2_Rendered_Document__Tax_Form__tax_form_KEY | tax_form_KEY | Client_W2_Rendered_Document |
FK_Print_Filing_Instruction__Tax_Form__tax_form_KEY | tax_form_KEY | Print_Filing_Instruction |
FK_Tax_Agent_Form_Filing_Address__Tax_Form__tax_form_KEY | tax_form_KEY | Tax_Agent_Form_Filing_Address |
FK_Tax_Form_Selection__Tax_Form__tax_form_KEY | tax_form_KEY | Tax_Form_Selection |
FK_Magnetic_Media_File__Tax_Form__tax_form_KEY | tax_form_KEY | Magnetic_Media_File |
FK_Tax_Form_Liability_Processing_Lock__Tax_Form__tax_form_KEY | tax_form_KEY | Tax_Form_Liability_Processing_Lock |
FK_Client_1099_Tax_Form_Selection__Tax_Form__tax_form_KEY | tax_form_KEY | Client_1099_Tax_Form_Selection | FOREIGN KEY constraint of tax_form_KEY for the Tax_Form_Filing table.
FK_Employee_W2_Rendered_Document__Tax_Form__tax_form_KEY | tax_form_KEY | Employee_W2_Rendered_Document |