Table: dbo.Form_1099_G_Option
Detailed options for 1099-G form
Columns
NameTypeConstraintsDescription
form_1099_KEYint (4)NOT NULLPrimary key and foreign key to the Form_1099_Option table
box_2_amount_tax_yearint (4)Form 1099-G option: box 2 amount tax year
box_2_is_trade_or_business_incomebit (1)NOT NULLForm 1099-G option: box 2 is trade or business income
box_2_amount_tax_year_overrideint (4)The override for the tax year for the recipient's tax refunds, credits, and offsets.
box_2_is_trade_or_business_income_overridebit (1)The override for whether the recipient's tax refunds, credits, or offsets are trade or business income.
box_2_amount_tax_year_original_overrideint (4)Original override of box 2 amount.
box_2_is_trade_or_business_income_original_overridebit (1)Original override of whether box 2 is trade or business income.
box_2_amount_tax_year_corrected_overrideint (4)Corrected override of box 2 amount.
box_2_is_trade_or_business_income_corrected_overridebit (1)Corrected override of whether box 2 is trade or business income.
second_tin_notificationbit (1)NOT NULLWhether or not the second_tin_notification flag is set.
second_tin_notification_overridebit (1)User override to the second_tin_notification column. Null indicates not overridden.
second_tin_notification_original_overridebit (1)Original override to the second_tin_notification column for corrected 1099s. Null indicates not overridden.
second_tin_notification_corrected_overridebit (1)Corrected override to second_tin_notification column for corrected 1099s. Null indicates not overridden.
Primary key
NameColumnsDescription
PK_Form_1099_G_Option$form_1099_KEYform_1099_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Form_1099_G_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1099 (form_1099_KEY)

Schema diagram