| 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 | ||