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
Name | Type | Constraints | Description
tax_form_override_KEY | int (4) | NOT NULL | Primary key for the Tax_Form_Override table.
client_KEY | int (4) | NOT NULL | Key of associated client.
field_reference_number | int (4) | NOT NULL | field_reference_number
override_data | nvarchar (300) | NOT NULL | override_data
form_description | nvarchar (120) | NOT NULL | A 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_KEY | nvarchar (4) | NOT NULL | A two digit string specifying the ste state code for the jurisdiction the override is being stored for.

Primary key
Name | Columns | Description
PK_Tax_Form_Override | tax_form_override_KEY |
Unique constraints
Name | Columns | Description
UK_Tax_Form_Override$client_KEY$ste_state_code_KEY$form_description$field_reference_number | client_KEY, ste_state_code_KEY, form_description, field_reference_number |

Foreign keys
Name | Columns | Referenced table | Description
FK_Tax_Form_Override__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Tax_Form_Override__Ste_State_Code__ste_state_code_KEY | ste_state_code_KEY | Ste_State_Code (ste_state_code_KEY) |