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
NameTypeConstraintsDescription
tax_form_filing_KEYint (4)NOT NULLPrimary key for this table
client_KEYint (4)NOT NULLKey of client to which this tax form filing belongs
tax_form_KEYint (4)NOT NULLKey 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_datedate (3)NOT NULLThe 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
NameColumnsDescription
PK_Tax_Form_Filingtax_form_filing_KEY
Unique constraints
NameColumnsDescription
UK_Tax_Form_Filing$client_KEY$tax_form_KEY$period_end_dateclient_KEY, tax_form_KEY, period_end_date
Foreign keys
NameColumnsReferenced tableDescription
FK_Tax_Form_Filing__Client__client_KEYclient_KEYClient (client_KEY)FOREIGN KEY constraint of client_KEY for the Tax_Form_Filing table
FK_Tax_Form_Filing__Tax_Form__tax_form_KEYtax_form_KEYTax_Form (tax_form_KEY)FOREIGN KEY constraint of tax_form_KEY for the Tax_Form_Filing table
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Tax_Form_Filing_Override__Tax_Form_Filing__tax_form_filing_KEYtax_form_filing_KEYTax_Form_Filing_OverrideFOREIGN KEY Reference to Tax_Form_Filing table

Schema diagram