Table: dbo.Tax_Form
This poorly named table actually describes all tax form COLLATIONS currently in the system
Columns
NameTypeConstraintsDescription
tax_form_KEYint (4)NOT NULLPrimary Key
collation_itemnvarchar (100)NOT NULLCollation item name.
tax_form_type_KEYint (4)NOT NULLTax form type key.
ste_state_code_KEYnvarchar (4)NOT NULLSte State Code key from symmetry.
is_pending_approvalbit (1)NOT NULLWhether or not the form is pending approval. False is the normal case and indicates that the form has already been approved.
Primary key
NameColumnsDescription
PK_Tax_Formtax_form_KEY
Unique constraints
NameColumnsDescription
UK_Tax_Form$collation_item$tax_form_type_KEY$ste_state_code_KEYcollation_item, tax_form_type_KEY, ste_state_code_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Tax_Form__Ste_State_Code__ste_state_code_KEYste_state_code_KEYSte_State_Code (ste_state_code_KEY)
FK_Tax_Form__Tax_Form_Type__tax_form_type_KEYtax_form_type_KEYTax_Form_Type (tax_form_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Elf_File__Tax_Form__tax_form_KEYtax_form_KEYElf_File
FK_Tax_Form_Filing__Tax_Form__tax_form_KEYtax_form_KEYTax_Form_FilingFOREIGN KEY constraint of tax_form_KEY for the Tax_Form_Filing table
FK_W2_Rendered_Template__Tax_Form__tax_form_KEYtax_form_KEYW2_Rendered_Template
FK_Processed_Tax_Form_Liability__Tax_Form__tax_form_KEYtax_form_KEYProcessed_Tax_Form_Liability
FK_Processed_Tax_Form__Tax_Form__tax_form_KEYtax_form_KEYProcessed_Tax_Form
FK_Client_W2_Rendered_Document__Tax_Form__tax_form_KEYtax_form_KEYClient_W2_Rendered_Document
FK_Print_Filing_Instruction__Tax_Form__tax_form_KEYtax_form_KEYPrint_Filing_Instruction
FK_Tax_Agent_Form_Filing_Address__Tax_Form__tax_form_KEYtax_form_KEYTax_Agent_Form_Filing_Address
FK_Tax_Form_Selection__Tax_Form__tax_form_KEYtax_form_KEYTax_Form_Selection
FK_Magnetic_Media_File__Tax_Form__tax_form_KEYtax_form_KEYMagnetic_Media_File
FK_Tax_Form_Liability_Processing_Lock__Tax_Form__tax_form_KEYtax_form_KEYTax_Form_Liability_Processing_Lock
FK_Client_1099_Tax_Form_Selection__Tax_Form__tax_form_KEYtax_form_KEYClient_1099_Tax_Form_SelectionFOREIGN KEY constraint of tax_form_KEY for the Tax_Form_Filing table.
FK_Employee_W2_Rendered_Document__Tax_Form__tax_form_KEYtax_form_KEYEmployee_W2_Rendered_Document

Schema diagram