Table: dbo.Form_1099_R_Option
Detailed options for 1099-R form
Columns
NameTypeConstraintsDescription
form_1099_KEYint (4)NOT NULLPrimary key and foreign key to the Form_1099_Option table
is_taxable_amount_not_determinedbit (1)NOT NULLForm 1099-R option: taxable amount not determined
is_total_distributionbit (1)NOT NULLForm 1099-R option: total distribution
is_irs_sep_simplebit (1)NOT NULLForm 1099-R option: irs sep simple
box_8_percentagedecimal (5, 2)Form 1099-R option: box 8 percentage
percentage_total_distributiondecimal (5, 2)Form 1099-R option: percentage total distribution
first_year_of_roth_contributionint (4)Form 1099-R option: first year of roth contribution
first__form_1099_r_distribution_code_KEYint (4)Form 1099-R option: first distribution code
second__form_1099_r_distribution_code_KEYint (4)Form 1099-R option: second distribution code
first_year_of_roth_contribution_overrideint (4)The override for the recipient's first year of designated Roth contributions.
is_taxable_amount_not_determined_overridebit (1)The override for whether or not the recipient's taxable amount is not determined.
is_total_distribution_overridebit (1)The override for whether or not the recipient's amount is the total distribution.
override_first__form_1099_r_distribution_code_KEYint (4)The override for the recipient's first distribution code.
override_second__form_1099_r_distribution_code_KEYint (4)The override for the recipient's second distribution code.
is_ira_sep_simple_overridebit (1)The override for whether or not the recipient's amount applies to IRA/SEP/SIMPLE.
box_8_percentage_overridedecimal (9, 2)The override for the recipient's box 8 percent.
percentage_total_distribution_overridedecimal (9, 2)The override for the recipient's percentage of total distribution.
first_year_of_roth_contribution_original_overrideint (4)Original override of first year roth contribution.
is_taxable_amount_not_determined_original_overridebit (1)Original override of whether taxable amount is not determined.
is_total_distribution_original_overridebit (1)Original override of whether is total distribution.
original_override_first__form_1099_r_distribution_code_KEYint (4)Original override of the first form 1099 r distribution code.
original_override_second__form_1099_r_distribution_code_KEYint (4)Original override of the second form 1099 r distribution code.
is_ira_sep_simple_original_overridebit (1)Original override of whether is ira sep simple.
box_8_percentage_original_overridedecimal (9, 2)Original override of box 8 percentage.
percentage_total_distribution_original_overridedecimal (9, 2)Original override of percentage total distribution.
first_year_of_roth_contribution_corrected_overrideint (4)Corrected override of first year roth contribution.
is_taxable_amount_not_determined_corrected_overridebit (1)Corrected override of whether taxable amount is not determined.
is_total_distribution_corrected_overridebit (1)Corrected override of whether is total distribution.
corrected_override_first__form_1099_r_distribution_code_KEYint (4)Corrected override of the first form 1099 r distribution code.
corrected_override_second__form_1099_r_distribution_code_KEYint (4)Corrected override of the first form 1099 r distribution code.
is_ira_sep_simple_corrected_overridebit (1)Corrected override of whether is ira sep simple.
box_8_percentage_corrected_overridedecimal (9, 2)Corrected override of box 8 percentage.
percentage_total_distribution_corrected_overridedecimal (9, 2)Corrected override of percentage total distribution.
fatca_filing_requirementbit (1)NOT NULLWhether or not the foreign account tax compliance act flag is set.
fatca_filing_requirement_overridebit (1)User override to the fatca_filing_requirement column. Null indicates not overridden.
fatca_filing_requirement_original_overridebit (1)Original override to the fatca_filing_requirement column for corrected 1099s. Null indicates not overridden.
fatca_filing_requirement_corrected_overridebit (1)Corrected override to the fatca_filing_requirement column for corrected 1099s. Null indicates not overridden.
date_of_paymentdate (3)Date of Payment.
date_of_payment_overridedate (3)Date of Payment Override.
date_of_payment_original_overridedate (3)Original Date of Payment Override.
date_of_payment_corrected_overridedate (3)Corrected Date of Payment Override.
Primary key
NameColumnsDescription
PK_Form_1099_R_Option$form_1099_KEYform_1099_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Form_1099_R_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1099 (form_1099_KEY)
FK_Form_1099_R_Option__Form_1099_R_Distribution_Code__corrected_override_first__form_1099_r_distribution_code_KEYcorrected_override_first__form_1099_r_distribution_code_KEYForm_1099_R_Distribution_Code (form_1099_r_distribution_code_KEY)
FK_Form_1099_R_Option__Form_1099_R_Distribution_Code__corrected_override_second__form_1099_r_distribution_code_KEYcorrected_override_second__form_1099_r_distribution_code_KEYForm_1099_R_Distribution_Code (form_1099_r_distribution_code_KEY)
FK_Form_1099_R_Option__Form_1099_R_Distribution_Code__first__form_1099_r_distribution_code_KEYfirst__form_1099_r_distribution_code_KEYForm_1099_R_Distribution_Code (form_1099_r_distribution_code_KEY)
FK_Form_1099_R_Option__Form_1099_R_Distribution_Code__original_override_first__form_1099_r_distribution_code_KEYoriginal_override_first__form_1099_r_distribution_code_KEYForm_1099_R_Distribution_Code (form_1099_r_distribution_code_KEY)
FK_Form_1099_R_Option__Form_1099_R_Distribution_Code__original_override_second__form_1099_r_distribution_code_KEYoriginal_override_second__form_1099_r_distribution_code_KEYForm_1099_R_Distribution_Code (form_1099_r_distribution_code_KEY)
FK_Form_1099_R_Option__Form_1099_R_Distribution_Code__override_first__form_1099_r_distribution_code_KEYoverride_first__form_1099_r_distribution_code_KEYForm_1099_R_Distribution_Code (form_1099_r_distribution_code_KEY)
FK_Form_1099_R_Option__Form_1099_R_Distribution_Code__override_second__form_1099_r_distribution_code_KEYoverride_second__form_1099_r_distribution_code_KEYForm_1099_R_Distribution_Code (form_1099_r_distribution_code_KEY)
FK_Form_1099_R_Option__Form_1099_R_Distribution_Code__second__form_1099_r_distribution_code_KEYsecond__form_1099_r_distribution_code_KEYForm_1099_R_Distribution_Code (form_1099_r_distribution_code_KEY)

Schema diagram