Table: dbo.Form_1098_Option
This table stores the detailed options for 1098 form.
Columns
Name | Type | Constraints | Description
form_1099_KEY | int (4) | NOT NULL | Primary key and foreign key to the Form_1099_Option table.
description | nvarchar (256) |  | Form 1098 option: description.
address | nvarchar (256) |  | Form 1098 option: address.
city | nvarchar (256) |  | Form 1098 option: city.
state_abbreviation | nvarchar (4) |  | Form 1098 option: state.
zip | nvarchar (20) |  | Form 1098 option: zip.
description_override | nvarchar (256) |  | The override for the recipient's 1098 description.
address_override | nvarchar (256) |  | The override for the recipient's 1098 address.
city_override | nvarchar (256) |  | The override for the recipient's 1098 city.
state_abbreviation_override | nvarchar (4) |  | The override for the recipient's 1098 state.
zip_override | nvarchar (20) |  | The override for the recipient's 1098 zip.
description_original_override | nvarchar (256) |  | Original override of description.
address_original_override | nvarchar (256) |  | Original override of address.
city_original_override | nvarchar (256) |  | Original override of city.
state_abbreviation_original_override | nvarchar (4) |  | Original override of state.
zip_original_override | nvarchar (20) |  | Original override of zip.
description_corrected_override | nvarchar (256) |  | Corrected override of description.
address_corrected_override | nvarchar (256) |  | Corrected override of address.
city_corrected_override | nvarchar (256) |  | Corrected override of city.
state_abbreviation_corrected_override | nvarchar (4) |  | Corrected override of state.
zip_corrected_override | nvarchar (20) |  | Corrected override of zip.
same_address | bit (1) | NOT NULL | Whether or not the same address flag is set.
same_address_override | bit (1) |  | User override to the same address column. Null indicates not overridden.
same_address_original_override | bit (1) |  | Original override to the same address column for corrected 1098s. Null indicates not overridden.
same_address_corrected_override | bit (1) |  | Corrected override to the same address column for corrected 1098s. Null indicates not overridden.
mortgage_origination_date | smalldatetime (4) |  | The mortgage origination date.
mortgage_origination_date_override | smalldatetime (4) |  | User override to the mortgage_origination_date column. Null indicates not overridden.
mortgage_origination_date_original_override | smalldatetime (4) |  | Original override to the mortgage_origination_date column for corrected 1099s. Null indicates not overridden.
mortgage_origination_date_corrected_override | smalldatetime (4) |  | Corrected override to mortgage_origination_date column for corrected 1099s. Null indicates not overridden.
number_of_mortgaged_properties | int (4) | NOT NULL | Form 1098 option: number of mortgaged properties.
number_of_mortgaged_properties_override | int (4) |  | The override for the recipient's number of mortgaged properties.
number_of_mortgaged_properties_original_override | int (4) |  | Original override of number of mortgaged properties.
number_of_mortgaged_properties_corrected_override | int (4) |  | Corrected override of number of mortgaged properties.
mortgage_acquisition_date | date (3) |  | The mortgage acquisition date. Null indicates no value was given for this field when entering the transaction.
mortgage_acquisition_date_override | date (3) |  | User override to the mortgage_acquisition_date column. Null indicates not overridden.
mortgage_acquisition_date_original_override | date (3) |  | Original override to the mortgage_acquisition_date column for corrected 1099s. Null indicates not overridden.
mortgage_acquisition_date_corrected_override | date (3) |  | Corrected override to mortgage_acquisition_date column for corrected 1099s. Null indicates not overridden.

Primary key
Name | Columns | Description
PK_Form_1098_Option$form_1099_KEY | form_1099_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Form_1098_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1099 (form_1099_KEY) |