Table: dbo.Form_5498_Option
Detailed options for 5498 form
Columns
NameTypeConstraintsDescription
form_1099_KEYint (4)NOT NULLPrimary key and foreign key to the Form_1099_Option table
is_irabit (1)NOT NULLForm 1099-SA option: IRA
is_sepbit (1)NOT NULLForm 1099-SA option: SEP
is_simplebit (1)NOT NULLForm 1099-SA option: SIMPLE
is_roth_irabit (1)NOT NULLForm 1099-SA option: Roth IRA
is_required_minimum_distribution_for_current_yearbit (1)NOT NULLForm 1099-SA option: required minimum distribution for current year
is_ira_overridebit (1)The override for whether the recipient's amount applies to an IRA.
is_sep_overridebit (1)The override for whether the recipient's amount applies to SEP.
is_simple_overridebit (1)The override for whether the recipient's amount applies to SIMPLE.
is_roth_ira_overridebit (1)The override for whether the recipient's amount applies to a Roth IRA.
is_required_minimum_distribution_for_current_year_overridebit (1)The override for whether the recipient's amount requires the minimum distribution.
required_minimum_distribution_datesmalldatetime (4)The date of the required minimum distribution, or null if there is none.
required_minimum_distribution_date_overridesmalldatetime (4)The override for the date of the required minimum distribution, or null if there is no override.
postponed_contribution_yearint (4)The year of the postponed contribution, or null if there is none.
postponed_contribution_year_overrideint (4)The override for the year of the postponed contribution, or null if there is no override.
form_5498_repayment_code_KEYint (4)The key to the repayment code, or null if there is none.
override__form_5498_repayment_code_KEYint (4)The override for the key to the repayment code, or null if there is no override.
form_5498_other_contribution_code_KEYint (4)The key to the other contributions code, or null if there is none.
override__form_5498_other_contribution_code_KEYint (4)The override for the key to the other contributions code, or null if there is no override.
is_ira_original_overridebit (1)Original override of whether is ira.
is_sep_original_overridebit (1)Original override of whether is sep.
is_simple_original_overridebit (1)Original override of whether is simple.
is_roth_ira_original_overridebit (1)Original override of whether is roth ira.
is_required_minimum_distribution_for_current_year_original_overridebit (1)Original override of whether is required minimum distribution for current year.
required_minimum_distribution_date_original_overridesmalldatetime (4)Original override of required minimum distribution date.
postponed_contribution_year_original_overrideint (4)Original override of postponed contribution year.
original_override__form_5498_repayment_code_KEYint (4)Original override of form 5498 repayment code.
original_override__form_5498_other_contribution_code_KEYint (4)Original override of form 5498 other contribution code.
is_ira_corrected_overridebit (1)Corrected override of whether is ira.
is_sep_corrected_overridebit (1)Corrected override of whether is sep.
is_simple_corrected_overridebit (1)Corrected override of whether is simple.
is_roth_ira_corrected_overridebit (1)Corrected override of whether is roth ira.
is_required_minimum_distribution_for_current_year_corrected_overridebit (1)Corrected override of whether is required minimum distribution for current year.
required_minimum_distribution_date_corrected_overridesmalldatetime (4)Corrected override of required minimum distribution date.
postponed_contribution_year_corrected_overrideint (4)Corrected override of postponed contribution year.
corrected_override__form_5498_repayment_code_KEYint (4)Corrected override of form 5498 repayment code.
corrected_override__form_5498_other_contribution_code_KEYint (4)Corrected override of form 5498 other contribution code.
postponed_contribution_codenvarchar (16)Postponed contribution code. Null or empty string indicates no value.
postponed_contribution_code_overridenvarchar (16)Override of the Postponed contribution code. Null indicates not overridden.
postponed_contribution_code_original_overridenvarchar (16)Original override of the Postponed contribution code. Null indicates not overridden.
postponed_contribution_code_corrected_overridenvarchar (16)Corrected override of the Postponed contribution code. Null indicates not overridden.
first__form_5498_fmv_code_KEYint (4)NOT NULLForm 5498 first FMV code.
second__form_5498_fmv_code_KEYint (4)NOT NULLForm 5498 second FMV code.
override_first__form_5498_fmv_code_KEYint (4)Form 5498 override first FMV code. Null indicates not overridden.
override_second__form_5498_fmv_code_KEYint (4)Form 5498 override second FMV code. Null indicates not overridden.
original_override_first__form_5498_fmv_code_KEYint (4)Form 5498 original override first FMV code. Null indicates not overridden.
original_override_second__form_5498_fmv_code_KEYint (4)Form 5498 original override second FMV code. Null indicates not overridden.
corrected_override_first__form_5498_fmv_code_KEYint (4)Form 5498 corrected override first FMV code. Null indicates not overridden.
corrected_override_second__form_5498_fmv_code_KEYint (4)Form 5498 corrected override second FMV code. Null indicates not overridden.
Primary key
NameColumnsDescription
PK_Form_5498_Option$form_1099_KEYform_1099_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Form_5498_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1099 (form_1099_KEY)
FK_Form_5498_Option__Form_5498_Fmv_Code__corrected_override_first__form_5498_fmv_code_KEYcorrected_override_first__form_5498_fmv_code_KEYForm_5498_Fmv_Code (form_5498_fmv_code_KEY)
FK_Form_5498_Option__Form_5498_Fmv_Code__corrected_override_second__form_5498_fmv_code_KEYcorrected_override_second__form_5498_fmv_code_KEYForm_5498_Fmv_Code (form_5498_fmv_code_KEY)
FK_Form_5498_Option__Form_5498_Fmv_Code__first__form_5498_fmv_code_KEYfirst__form_5498_fmv_code_KEYForm_5498_Fmv_Code (form_5498_fmv_code_KEY)
FK_Form_5498_Option__Form_5498_Fmv_Code__original_override_first__form_5498_fmv_code_KEYoriginal_override_first__form_5498_fmv_code_KEYForm_5498_Fmv_Code (form_5498_fmv_code_KEY)
FK_Form_5498_Option__Form_5498_Fmv_Code__original_override_second__form_5498_fmv_code_KEYoriginal_override_second__form_5498_fmv_code_KEYForm_5498_Fmv_Code (form_5498_fmv_code_KEY)
FK_Form_5498_Option__Form_5498_Fmv_Code__override_first__form_5498_fmv_code_KEYoverride_first__form_5498_fmv_code_KEYForm_5498_Fmv_Code (form_5498_fmv_code_KEY)
FK_Form_5498_Option__Form_5498_Fmv_Code__override_second__form_5498_fmv_code_KEYoverride_second__form_5498_fmv_code_KEYForm_5498_Fmv_Code (form_5498_fmv_code_KEY)
FK_Form_5498_Option__Form_5498_Fmv_Code__second__form_5498_fmv_code_KEYsecond__form_5498_fmv_code_KEYForm_5498_Fmv_Code (form_5498_fmv_code_KEY)
FK_Form_5498_Option__Form_5498_Other_Contribution_Code__corrected_override__form_5498_other_contribution_code_KEYcorrected_override__form_5498_other_contribution_code_KEYForm_5498_Other_Contribution_Code (form_5498_other_contribution_code_KEY)
FK_Form_5498_Option__Form_5498_Other_Contribution_Code__form_5498_other_contribution_code_KEYform_5498_other_contribution_code_KEYForm_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_KEYoriginal_override__form_5498_other_contribution_code_KEYForm_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_KEYoverride__form_5498_other_contribution_code_KEYForm_5498_Other_Contribution_Code (form_5498_other_contribution_code_KEY)
FK_Form_5498_Option__Form_5498_Repayment_Code__corrected_override__form_5498_repayment_code_KEYcorrected_override__form_5498_repayment_code_KEYForm_5498_Repayment_Code (form_5498_repayment_code_KEY)
FK_Form_5498_Option__Form_5498_Repayment_Code__form_5498_repayment_code_KEYform_5498_repayment_code_KEYForm_5498_Repayment_Code (form_5498_repayment_code_KEY)
FK_Form_5498_Option__Form_5498_Repayment_Code__original_override__form_5498_repayment_code_KEYoriginal_override__form_5498_repayment_code_KEYForm_5498_Repayment_Code (form_5498_repayment_code_KEY)
FK_Form_5498_Option__Form_5498_Repayment_Code__override__form_5498_repayment_code_KEYoverride__form_5498_repayment_code_KEYForm_5498_Repayment_Code (form_5498_repayment_code_KEY)

Schema diagram