Table: dbo.Form_1098_Option
This table stores the detailed options for 1098 form.
Columns
NameTypeConstraintsDescription
form_1099_KEYint (4)NOT NULLPrimary key and foreign key to the Form_1099_Option table.
descriptionnvarchar (256)Form 1098 option: description.
addressnvarchar (256)Form 1098 option: address.
citynvarchar (256)Form 1098 option: city.
state_abbreviationnvarchar (4)Form 1098 option: state.
zipnvarchar (20)Form 1098 option: zip.
description_overridenvarchar (256)The override for the recipient's 1098 description.
address_overridenvarchar (256)The override for the recipient's 1098 address.
city_overridenvarchar (256)The override for the recipient's 1098 city.
state_abbreviation_overridenvarchar (4)The override for the recipient's 1098 state.
zip_overridenvarchar (20)The override for the recipient's 1098 zip.
description_original_overridenvarchar (256)Original override of description.
address_original_overridenvarchar (256)Original override of address.
city_original_overridenvarchar (256)Original override of city.
state_abbreviation_original_overridenvarchar (4)Original override of state.
zip_original_overridenvarchar (20)Original override of zip.
description_corrected_overridenvarchar (256)Corrected override of description.
address_corrected_overridenvarchar (256)Corrected override of address.
city_corrected_overridenvarchar (256)Corrected override of city.
state_abbreviation_corrected_overridenvarchar (4)Corrected override of state.
zip_corrected_overridenvarchar (20)Corrected override of zip.
same_addressbit (1)NOT NULLWhether or not the same address flag is set.
same_address_overridebit (1)User override to the same address column. Null indicates not overridden.
same_address_original_overridebit (1)Original override to the same address column for corrected 1098s. Null indicates not overridden.
same_address_corrected_overridebit (1)Corrected override to the same address column for corrected 1098s. Null indicates not overridden.
mortgage_origination_datesmalldatetime (4)The mortgage origination date.
mortgage_origination_date_overridesmalldatetime (4)User override to the mortgage_origination_date column. Null indicates not overridden.
mortgage_origination_date_original_overridesmalldatetime (4)Original override to the mortgage_origination_date column for corrected 1099s. Null indicates not overridden.
mortgage_origination_date_corrected_overridesmalldatetime (4)Corrected override to mortgage_origination_date column for corrected 1099s. Null indicates not overridden.
number_of_mortgaged_propertiesint (4)NOT NULLForm 1098 option: number of mortgaged properties.
number_of_mortgaged_properties_overrideint (4)The override for the recipient's number of mortgaged properties.
number_of_mortgaged_properties_original_overrideint (4)Original override of number of mortgaged properties.
number_of_mortgaged_properties_corrected_overrideint (4)Corrected override of number of mortgaged properties.
mortgage_acquisition_datedate (3)The mortgage acquisition date. Null indicates no value was given for this field when entering the transaction.
mortgage_acquisition_date_overridedate (3)User override to the mortgage_acquisition_date column. Null indicates not overridden.
mortgage_acquisition_date_original_overridedate (3)Original override to the mortgage_acquisition_date column for corrected 1099s. Null indicates not overridden.
mortgage_acquisition_date_corrected_overridedate (3)Corrected override to mortgage_acquisition_date column for corrected 1099s. Null indicates not overridden.
Primary key
NameColumnsDescription
PK_Form_1098_Option$form_1099_KEYform_1099_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Form_1098_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1099 (form_1099_KEY)

Schema diagram