Table: dbo.Tax_Form_Filing
This table represents an instance of a Tax Form Collation for a particular client.It is possible that instance was never processed nor filed.While it is the case that this deals with Tax Forms one Collation at a time,this table-level documentation is the only place that will be acknowledged, except where the distinction is critical.
Columns
Name | Type | Constraints | Description
tax_form_filing_KEY | int (4) | NOT NULL | Primary key for this table
client_KEY | int (4) | NOT NULL | Key of client to which this tax form filing belongs
tax_form_KEY | int (4) | NOT NULL | Key of Tax Form Collation that is being described. Note that individual tax forms do not actually have keys! All tax_form_KEY values everywhere in the system actually indicate a Tax Form Collation!
period_end_date | date (3) | NOT NULL | The period end date that disambiguates the tax form collation to a particular filing. It is always necessary to have this data point, so when no period end date seems obvious, something will need to stand in.

Primary key
Name | Columns | Description
PK_Tax_Form_Filing | tax_form_filing_KEY |
Unique constraints
Name | Columns | Description
UK_Tax_Form_Filing$client_KEY$tax_form_KEY$period_end_date | client_KEY, tax_form_KEY, period_end_date |

Foreign keys
Name | Columns | Referenced table | Description
FK_Tax_Form_Filing__Client__client_KEY | client_KEY | Client (client_KEY) | FOREIGN KEY constraint of client_KEY for the Tax_Form_Filing table
FK_Tax_Form_Filing__Tax_Form__tax_form_KEY | tax_form_KEY | Tax_Form (tax_form_KEY) | FOREIGN KEY constraint of tax_form_KEY for the Tax_Form_Filing table

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Tax_Form_Filing_Override__Tax_Form_Filing__tax_form_filing_KEY | tax_form_filing_KEY | Tax_Form_Filing_Override | FOREIGN KEY Reference to Tax_Form_Filing table