Table: dbo.Tax_Form_Override
This table stores data about override present on the most-recently edited version of a tax form. Each separate field that is overridden has its own entry in this table. Historical data is not preserved. As each form gets re-filed, the system makes the assumption that the same set of overrides as last time shall be applied, unless a service pack deletes overrides due to form updates. It is not possible to retrieve the set of overrides that existed at an arbitrary point in the history of form filing, as only the most recently edited version of the form has its overrides stored.
Columns
NameTypeConstraintsDescription
tax_form_override_KEYint (4)NOT NULLPrimary key for the Tax_Form_Override table.
client_KEYint (4)NOT NULLKey of associated client.
field_reference_numberint (4)NOT NULLfield_reference_number
override_datanvarchar (300)NOT NULLoverride_data
form_descriptionnvarchar (120)NOT NULLA description of the system form the override is being stored for. Cannot use the tax_form_KEY alone because multi-page forms only have one key.
ste_state_code_KEYnvarchar (4)NOT NULLA two digit string specifying the ste state code for the jurisdiction the override is being stored for.
Primary key
NameColumnsDescription
PK_Tax_Form_Overridetax_form_override_KEY
Unique constraints
NameColumnsDescription
UK_Tax_Form_Override$client_KEY$ste_state_code_KEY$form_description$field_reference_numberclient_KEY, ste_state_code_KEY, form_description, field_reference_number
Foreign keys
NameColumnsReferenced tableDescription
FK_Tax_Form_Override__Client__client_KEYclient_KEYClient (client_KEY)
FK_Tax_Form_Override__Ste_State_Code__ste_state_code_KEYste_state_code_KEYSte_State_Code (ste_state_code_KEY)

Schema diagram