Table: dbo.Form_1099_R_Option
Detailed options for 1099-R form
Columns
Name | Type | Constraints | Description
form_1099_KEY | int (4) | NOT NULL | Primary key and foreign key to the Form_1099_Option table
is_taxable_amount_not_determined | bit (1) | NOT NULL | Form 1099-R option: taxable amount not determined
is_total_distribution | bit (1) | NOT NULL | Form 1099-R option: total distribution
is_irs_sep_simple | bit (1) | NOT NULL | Form 1099-R option: irs sep simple
box_8_percentage | decimal (5, 2) |  | Form 1099-R option: box 8 percentage
percentage_total_distribution | decimal (5, 2) |  | Form 1099-R option: percentage total distribution
first_year_of_roth_contribution | int (4) |  | Form 1099-R option: first year of roth contribution
first__form_1099_r_distribution_code_KEY | int (4) |  | Form 1099-R option: first distribution code
second__form_1099_r_distribution_code_KEY | int (4) |  | Form 1099-R option: second distribution code
first_year_of_roth_contribution_override | int (4) |  | The override for the recipient's first year of designated Roth contributions.
is_taxable_amount_not_determined_override | bit (1) |  | The override for whether or not the recipient's taxable amount is not determined.
is_total_distribution_override | bit (1) |  | The override for whether or not the recipient's amount is the total distribution.
override_first__form_1099_r_distribution_code_KEY | int (4) |  | The override for the recipient's first distribution code.
override_second__form_1099_r_distribution_code_KEY | int (4) |  | The override for the recipient's second distribution code.
is_ira_sep_simple_override | bit (1) |  | The override for whether or not the recipient's amount applies to IRA/SEP/SIMPLE.
box_8_percentage_override | decimal (9, 2) |  | The override for the recipient's box 8 percent.
percentage_total_distribution_override | decimal (9, 2) |  | The override for the recipient's percentage of total distribution.
first_year_of_roth_contribution_original_override | int (4) |  | Original override of first year roth contribution.
is_taxable_amount_not_determined_original_override | bit (1) |  | Original override of whether taxable amount is not determined.
is_total_distribution_original_override | bit (1) |  | Original override of whether is total distribution.
original_override_first__form_1099_r_distribution_code_KEY | int (4) |  | Original override of the first form 1099 r distribution code.
original_override_second__form_1099_r_distribution_code_KEY | int (4) |  | Original override of the second form 1099 r distribution code.
is_ira_sep_simple_original_override | bit (1) |  | Original override of whether is ira sep simple.
box_8_percentage_original_override | decimal (9, 2) |  | Original override of box 8 percentage.
percentage_total_distribution_original_override | decimal (9, 2) |  | Original override of percentage total distribution.
first_year_of_roth_contribution_corrected_override | int (4) |  | Corrected override of first year roth contribution.
is_taxable_amount_not_determined_corrected_override | bit (1) |  | Corrected override of whether taxable amount is not determined.
is_total_distribution_corrected_override | bit (1) |  | Corrected override of whether is total distribution.
corrected_override_first__form_1099_r_distribution_code_KEY | int (4) |  | Corrected override of the first form 1099 r distribution code.
corrected_override_second__form_1099_r_distribution_code_KEY | int (4) |  | Corrected override of the first form 1099 r distribution code.
is_ira_sep_simple_corrected_override | bit (1) |  | Corrected override of whether is ira sep simple.
box_8_percentage_corrected_override | decimal (9, 2) |  | Corrected override of box 8 percentage.
percentage_total_distribution_corrected_override | decimal (9, 2) |  | Corrected override of percentage total distribution.
fatca_filing_requirement | bit (1) | NOT NULL | Whether or not the foreign account tax compliance act flag is set.
fatca_filing_requirement_override | bit (1) |  | User override to the fatca_filing_requirement column. Null indicates not overridden.
fatca_filing_requirement_original_override | bit (1) |  | Original override to the fatca_filing_requirement column for corrected 1099s. Null indicates not overridden.
fatca_filing_requirement_corrected_override | bit (1) |  | Corrected override to the fatca_filing_requirement column for corrected 1099s. Null indicates not overridden.
date_of_payment | date (3) |  | Date of Payment.
date_of_payment_override | date (3) |  | Date of Payment Override.
date_of_payment_original_override | date (3) |  | Original Date of Payment Override.
date_of_payment_corrected_override | date (3) |  | Corrected Date of Payment Override.

Primary key
Name | Columns | Description
PK_Form_1099_R_Option$form_1099_KEY | form_1099_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Form_1099_R_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1099 (form_1099_KEY) |
FK_Form_1099_R_Option__Form_1099_R_Distribution_Code__corrected_override_first__form_1099_r_distribution_code_KEY | corrected_override_first__form_1099_r_distribution_code_KEY | Form_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_KEY | corrected_override_second__form_1099_r_distribution_code_KEY | Form_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_KEY | first__form_1099_r_distribution_code_KEY | Form_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_KEY | original_override_first__form_1099_r_distribution_code_KEY | Form_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_KEY | original_override_second__form_1099_r_distribution_code_KEY | Form_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_KEY | override_first__form_1099_r_distribution_code_KEY | Form_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_KEY | override_second__form_1099_r_distribution_code_KEY | Form_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_KEY | second__form_1099_r_distribution_code_KEY | Form_1099_R_Distribution_Code (form_1099_r_distribution_code_KEY) |