Table: dbo.Form_1098_C_Option
This table stores the detailed options for 1098 C form.
Columns
NameTypeConstraintsDescription
form_1099_KEYint (4)NOT NULLPrimary key and foreign key to the Form_1099_C_Option table.
contribution_datedate (3)The date the donor contributed the vehicle to the donee. NULL is allowed because of a special requirement to allow a blank date.
contribution_date_overridedate (3)User override to the contribution date column. Null indicates not overridden.
contribution_date_original_overridedate (3)Original override to the contribution date column for corrected 1098Cs. Null indicates not overridden.
contribution_date_corrected_overridedate (3)Corrected override to the contribution date column for corrected 1098Cs. Null indicates not overridden.
odometer_mileageint (4)NOT NULLThe odometer mileage of the donated motor vehicle.
odometer_mileage_overrideint (4)User override to the odometer mileage column. Null indicates not overridden.
odometer_mileage_original_overrideint (4)Original override to the odometer mileage column for corrected 1098Cs. Null indicates not overridden.
odometer_mileage_corrected_overrideint (4)Corrected override to the odometer mileage column for corrected 1098Cs. Null indicates not overridden.
year_of_vehiclesmallint (2)The year the donated vehicle was manufactured. NULL is allowed because of a special requirement to allow a blank year.
year_of_vehicle_overridesmallint (2)User override to the year of vehicle column. Null indicates not overridden.
year_of_vehicle_original_overridesmallint (2)Original override to the year of vehicle column for corrected 1098Cs. Null indicates not overridden.
year_of_vehicle_corrected_overridesmallint (2)Corrected override to the year of vehicle column for corrected 1098Cs. Null indicates not overridden.
make_of_vehiclenvarchar (256)The make of the vehicle.
make_of_vehicle_overridenvarchar (256)User override to the make of vehicle column. Null indicates not overridden.
make_of_vehicle_original_overridenvarchar (256)Original override to the make of vehicle column for corrected 1098Cs. Null indicates not overridden.
make_of_vehicle_corrected_overridenvarchar (256)Corrected override to the make of vehicle column for corrected 1098Cs. Null indicates not overridden.
model_of_vehiclenvarchar (256)The model of the vehicle.
model_of_vehicle_overridenvarchar (256)User override to the model of vehicle column. Null indicates not overridden.
model_of_vehicle_original_overridenvarchar (256)Original override to the model of vehicle column for corrected 1098Cs. Null indicates not overridden.
model_of_vehicle_corrected_overridenvarchar (256)Corrected override to the model of vehicle column for corrected 1098Cs. Null indicates not overridden.
vehicle_idnvarchar (50)The vehicle identification number.
vehicle_id_overridenvarchar (50)User override to the vehicle id column. Null indicates not overridden.
vehicle_id_original_overridenvarchar (50)Original override to the vehicle id column for corrected 1098Cs. Null indicates not overridden.
vehicle_id_corrected_overridenvarchar (50)Corrected override to the vehicle id column for corrected 1098Cs. Null indicates not overridden.
sold_to_unrelated_partybit (1)NOT NULLThe vehicle was sold to an unrelated party.
sold_to_unrelated_party_overridebit (1)User override to the sold to unrelated party column. Null indicates not overridden.
sold_to_unrelated_party_original_overridebit (1)Original override to the sold to unrelated party column for corrected 1098Cs. Null indicates not overridden.
sold_to_unrelated_party_corrected_overridebit (1)Corrected override to the sold to unrelated party column for corrected 1098Cs. Null indicates not overridden.
date_solddate (3)The date that the donee sold the donated vehicle. Null indicates that they did not sell the vehicle to an unrelated party.
date_sold_overridedate (3)User override to the date sold column. Null indicates not overridden.
date_sold_original_overridedate (3)Original override to the date sold column for corrected 1098Cs. Null indicates not overridden.
date_sold_corrected_overridedate (3)Corrected override to the date sold column for corrected 1098Cs. Null indicates not overridden.
vehicle_not_transferred_for_money_other_property_or_servicesbit (1)NOT NULLThe vehicle will not be transferred for money, other property or services before completion of material improvements or significant intervening use.
vehicle_not_transferred_for_money_other_property_or_services_overridebit (1)User override to the vehicle not transferred for money other property or services column. Null indicates not overridden.
vehicle_not_transferred_for_money_other_property_or_services_original_overridebit (1)Original override to the vehicle not transferred for money other property or services column for corrected 1098Cs. Null indicates not overridden.
vehicle_not_transferred_for_money_other_property_or_services_corrected_overridebit (1)Corrected override to the vehicle not transferred for money other property or services column for corrected 1098Cs. Null indicates not overridden.
vehicle_transferred_below_fair_market_valuebit (1)NOT NULLThe vehicle is to be transferred to a needy person for significantly below fair market value.
vehicle_transferred_below_fair_market_value_overridebit (1)User override to the vehicle transferred below fair market value column. Null indicates not overridden.
vehicle_transferred_below_fair_market_value_original_overridebit (1)Original override to the vehicle transferred below fair market value column for corrected 1098Cs. Null indicates not overridden.
vehicle_transferred_below_fair_market_value_corrected_overridebit (1)Corrected override to the vehicle transferred below fair market values column for corrected 1098Cs. Null indicates not overridden.
detailed_descriptionnvarchar (256)The detailed description of material improvements or significant intervening use and duration of use.
detailed_description_overridenvarchar (256)User override to the detailed description column. Null indicates not overridden.
detailed_description_original_overridenvarchar (256)Original override to the detailed description column for corrected 1098Cs. Null indicates not overridden.
detailed_description_corrected_overridenvarchar (256)Corrected override to the detailed description column for corrected 1098Cs. Null indicates not overridden.
goods_or_services_in_exchange_for_vehiclebit (1)NOT NULLGoods or services were provided in exchange for the donated vehicle.
goods_or_services_in_exchange_for_vehicle_overridebit (1)User override to the goods or services in exchange for vehicle column. Null indicates not overridden.
goods_or_services_in_exchange_for_vehicle_original_overridebit (1)Original override to the goods or services in exchange for vehicle column for corrected 1098Cs. Null indicates not overridden.
goods_or_services_in_exchange_for_vehicle_corrected_overridebit (1)Corrected override to the goods or services in exchange for vehicle column for corrected 1098Cs. Null indicates not overridden.
goods_and_services_solely_intangible_religious_benefitsbit (1)NOT NULLWere goods and services that were provided solely of intangible religious benefits.
goods_and_services_solely_intangible_religious_benefits_overridebit (1)User override to the goods and services solely intangible religious benefits column. Null indicates not overridden.
goods_and_services_solely_intangible_religious_benefits_original_overridebit (1)Original override to the goods and services solely intangible religious benefits column for corrected 1098Cs. Null indicates not overridden.
goods_and_services_solely_intangible_religious_benefits_corrected_overridebit (1)Corrected override to the goods and services solely intangible religious benefits column for corrected 1098Cs. Null indicates not overridden.
goods_and_services_descriptionnvarchar (256)The description of the goods and services provided by the donee to the donor for the donated vehicle.
goods_and_services_description_overridenvarchar (256)User override to the goods and services description column. Null indicates not overridden.
goods_and_services_description_original_overridenvarchar (256)Original override to the goods and services description column for corrected 1098Cs. Null indicates not overridden.
goods_and_services_description_corrected_overridenvarchar (256)Corrected override to the goods and services description column for corrected 1098Cs. Null indicates not overridden.
may_not_claim_deduction_more_than_five_hundred_dollarsbit (1)NOT NULLThe donor may not claim a deduction of more than $500.00 for the donated vehicle.
may_not_claim_deduction_more_than_five_hundred_dollars_overridebit (1)User override to the may not claim deduction more than five hundred dollars column. Null indicates not overridden.
may_not_claim_deduction_more_than_five_hundred_dollars_original_overridebit (1)Original override to the may not claim deduction more than five hundred dollars column for corrected 1098Cs. Null indicates not overridden.
may_not_claim_deduction_more_than_five_hundred_dollars_corrected_overridebit (1)Corrected override to the may not claim deduction more than five hundred dollars column for corrected 1098Cs. Null indicates not overridden.
Primary key
NameColumnsDescription
PK_Form_1098_C_Option$form_1099_KEYform_1099_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Form_1098_C_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1099 (form_1099_KEY)

Schema diagram