Table: dbo.Form_5498_Option
Detailed options for 5498 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_ira | bit (1) | NOT NULL | Form 1099-SA option: IRA
is_sep | bit (1) | NOT NULL | Form 1099-SA option: SEP
is_simple | bit (1) | NOT NULL | Form 1099-SA option: SIMPLE
is_roth_ira | bit (1) | NOT NULL | Form 1099-SA option: Roth IRA
is_required_minimum_distribution_for_current_year | bit (1) | NOT NULL | Form 1099-SA option: required minimum distribution for current year
is_ira_override | bit (1) |  | The override for whether the recipient's amount applies to an IRA.
is_sep_override | bit (1) |  | The override for whether the recipient's amount applies to SEP.
is_simple_override | bit (1) |  | The override for whether the recipient's amount applies to SIMPLE.
is_roth_ira_override | bit (1) |  | The override for whether the recipient's amount applies to a Roth IRA.
is_required_minimum_distribution_for_current_year_override | bit (1) |  | The override for whether the recipient's amount requires the minimum distribution.
required_minimum_distribution_date | smalldatetime (4) |  | The date of the required minimum distribution, or null if there is none.
required_minimum_distribution_date_override | smalldatetime (4) |  | The override for the date of the required minimum distribution, or null if there is no override.
postponed_contribution_year | int (4) |  | The year of the postponed contribution, or null if there is none.
postponed_contribution_year_override | int (4) |  | The override for the year of the postponed contribution, or null if there is no override.
form_5498_repayment_code_KEY | int (4) |  | The key to the repayment code, or null if there is none.
override__form_5498_repayment_code_KEY | int (4) |  | The override for the key to the repayment code, or null if there is no override.
form_5498_other_contribution_code_KEY | int (4) |  | The key to the other contributions code, or null if there is none.
override__form_5498_other_contribution_code_KEY | int (4) |  | The override for the key to the other contributions code, or null if there is no override.
is_ira_original_override | bit (1) |  | Original override of whether is ira.
is_sep_original_override | bit (1) |  | Original override of whether is sep.
is_simple_original_override | bit (1) |  | Original override of whether is simple.
is_roth_ira_original_override | bit (1) |  | Original override of whether is roth ira.
is_required_minimum_distribution_for_current_year_original_override | bit (1) |  | Original override of whether is required minimum distribution for current year.
required_minimum_distribution_date_original_override | smalldatetime (4) |  | Original override of required minimum distribution date.
postponed_contribution_year_original_override | int (4) |  | Original override of postponed contribution year.
original_override__form_5498_repayment_code_KEY | int (4) |  | Original override of form 5498 repayment code.
original_override__form_5498_other_contribution_code_KEY | int (4) |  | Original override of form 5498 other contribution code.
is_ira_corrected_override | bit (1) |  | Corrected override of whether is ira.
is_sep_corrected_override | bit (1) |  | Corrected override of whether is sep.
is_simple_corrected_override | bit (1) |  | Corrected override of whether is simple.
is_roth_ira_corrected_override | bit (1) |  | Corrected override of whether is roth ira.
is_required_minimum_distribution_for_current_year_corrected_override | bit (1) |  | Corrected override of whether is required minimum distribution for current year.
required_minimum_distribution_date_corrected_override | smalldatetime (4) |  | Corrected override of required minimum distribution date.
postponed_contribution_year_corrected_override | int (4) |  | Corrected override of postponed contribution year.
corrected_override__form_5498_repayment_code_KEY | int (4) |  | Corrected override of form 5498 repayment code.
corrected_override__form_5498_other_contribution_code_KEY | int (4) |  | Corrected override of form 5498 other contribution code.
postponed_contribution_code | nvarchar (16) |  | Postponed contribution code. Null or empty string indicates no value.
postponed_contribution_code_override | nvarchar (16) |  | Override of the Postponed contribution code. Null indicates not overridden.
postponed_contribution_code_original_override | nvarchar (16) |  | Original override of the Postponed contribution code. Null indicates not overridden.
postponed_contribution_code_corrected_override | nvarchar (16) |  | Corrected override of the Postponed contribution code. Null indicates not overridden.
first__form_5498_fmv_code_KEY | int (4) | NOT NULL | Form 5498 first FMV code.
second__form_5498_fmv_code_KEY | int (4) | NOT NULL | Form 5498 second FMV code.
override_first__form_5498_fmv_code_KEY | int (4) |  | Form 5498 override first FMV code. Null indicates not overridden.
override_second__form_5498_fmv_code_KEY | int (4) |  | Form 5498 override second FMV code. Null indicates not overridden.
original_override_first__form_5498_fmv_code_KEY | int (4) |  | Form 5498 original override first FMV code. Null indicates not overridden.
original_override_second__form_5498_fmv_code_KEY | int (4) |  | Form 5498 original override second FMV code. Null indicates not overridden.
corrected_override_first__form_5498_fmv_code_KEY | int (4) |  | Form 5498 corrected override first FMV code. Null indicates not overridden.
corrected_override_second__form_5498_fmv_code_KEY | int (4) |  | Form 5498 corrected override second FMV code. Null indicates not overridden.

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

Foreign keys
Name | Columns | Referenced table | Description
FK_Form_5498_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1099 (form_1099_KEY) |
FK_Form_5498_Option__Form_5498_Fmv_Code__corrected_override_first__form_5498_fmv_code_KEY | corrected_override_first__form_5498_fmv_code_KEY | Form_5498_Fmv_Code (form_5498_fmv_code_KEY) |
FK_Form_5498_Option__Form_5498_Fmv_Code__corrected_override_second__form_5498_fmv_code_KEY | corrected_override_second__form_5498_fmv_code_KEY | Form_5498_Fmv_Code (form_5498_fmv_code_KEY) |
FK_Form_5498_Option__Form_5498_Fmv_Code__first__form_5498_fmv_code_KEY | first__form_5498_fmv_code_KEY | Form_5498_Fmv_Code (form_5498_fmv_code_KEY) |
FK_Form_5498_Option__Form_5498_Fmv_Code__original_override_first__form_5498_fmv_code_KEY | original_override_first__form_5498_fmv_code_KEY | Form_5498_Fmv_Code (form_5498_fmv_code_KEY) |
FK_Form_5498_Option__Form_5498_Fmv_Code__original_override_second__form_5498_fmv_code_KEY | original_override_second__form_5498_fmv_code_KEY | Form_5498_Fmv_Code (form_5498_fmv_code_KEY) |
FK_Form_5498_Option__Form_5498_Fmv_Code__override_first__form_5498_fmv_code_KEY | override_first__form_5498_fmv_code_KEY | Form_5498_Fmv_Code (form_5498_fmv_code_KEY) |
FK_Form_5498_Option__Form_5498_Fmv_Code__override_second__form_5498_fmv_code_KEY | override_second__form_5498_fmv_code_KEY | Form_5498_Fmv_Code (form_5498_fmv_code_KEY) |
FK_Form_5498_Option__Form_5498_Fmv_Code__second__form_5498_fmv_code_KEY | second__form_5498_fmv_code_KEY | Form_5498_Fmv_Code (form_5498_fmv_code_KEY) |
FK_Form_5498_Option__Form_5498_Other_Contribution_Code__corrected_override__form_5498_other_contribution_code_KEY | corrected_override__form_5498_other_contribution_code_KEY | Form_5498_Other_Contribution_Code (form_5498_other_contribution_code_KEY) |
FK_Form_5498_Option__Form_5498_Other_Contribution_Code__form_5498_other_contribution_code_KEY | form_5498_other_contribution_code_KEY | Form_5498_Other_Contribution_Code (form_5498_other_contribution_code_KEY) |
FK_Form_5498_Option__Form_5498_Other_Contribution_Code__original_override__form_5498_other_contribution_code_KEY | original_override__form_5498_other_contribution_code_KEY | Form_5498_Other_Contribution_Code (form_5498_other_contribution_code_KEY) |
FK_Form_5498_Option__Form_5498_Other_Contribution_Code__override__form_5498_other_contribution_code_KEY | override__form_5498_other_contribution_code_KEY | Form_5498_Other_Contribution_Code (form_5498_other_contribution_code_KEY) |
FK_Form_5498_Option__Form_5498_Repayment_Code__corrected_override__form_5498_repayment_code_KEY | corrected_override__form_5498_repayment_code_KEY | Form_5498_Repayment_Code (form_5498_repayment_code_KEY) |
FK_Form_5498_Option__Form_5498_Repayment_Code__form_5498_repayment_code_KEY | form_5498_repayment_code_KEY | Form_5498_Repayment_Code (form_5498_repayment_code_KEY) |
FK_Form_5498_Option__Form_5498_Repayment_Code__original_override__form_5498_repayment_code_KEY | original_override__form_5498_repayment_code_KEY | Form_5498_Repayment_Code (form_5498_repayment_code_KEY) |
FK_Form_5498_Option__Form_5498_Repayment_Code__override__form_5498_repayment_code_KEY | override__form_5498_repayment_code_KEY | Form_5498_Repayment_Code (form_5498_repayment_code_KEY) |