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) |