Table: dbo.Tax_Form_Filing_Override
Entries in this table each represent a single overriden field on a Tax Form.When the option to Save overrides by period end date for the relevant form type is off,the system will maintain only one set of overrides for the given tax form collation / client combination by dynamically reassigning them from one period_end_date to another.
Columns
NameTypeConstraintsDescription
tax_form_filing_override_KEYint (4)NOT NULLPrimary key for this table
tax_form_filing_KEYint (4)NOT NULLKey into the Tax_Form_Filing table to indicate to which filing this override applies
unitsmallint (2)NOT NULLNon-multi-unit forms are always unit 1. For multi-unit forms, this indicates to which copy of a given page the override applies.
field_reference_numbersmallint (2)NOT NULLUniquely identifies a given overridable field within a combination of a Tax Form Collation and a page
override_datanvarchar (300)NOT NULLThe payload of the override, formatted as text
page_identifieruniqueidentifier (16)NOT NULLRepresents a unique form page. For year specific forms, the same page_identifier will be shared across all form years.
Primary key
NameColumnsDescription
PK_Tax_Form_Filing_Overridetax_form_filing_override_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Tax_Form_Filing_Override__Tax_Form_Filing__tax_form_filing_KEYtax_form_filing_KEYTax_Form_Filing (tax_form_filing_KEY)FOREIGN KEY Reference to Tax_Form_Filing table

Schema diagram