Table: dbo.Form_1099_Sa_Option
Detailed options for 1099-SA form
Columns
Name | Type | Constraints | Description
form_1099_KEY | int (4) | NOT NULL | Primary key and foreign key to the Form_1099_Option table
form_1099_sa_distribution_code_KEY | int (4) |  | Form 1099-SA option: distribution code
is_hsa | bit (1) | NOT NULL | Form 1099-SA option: HSA
is_archer_msa | bit (1) | NOT NULL | Form 1099-SA option: archer MSA
is_ma_msa | bit (1) | NOT NULL | Form 1099-SA option: MA MSA
override__form_1099_sa_distribution_code_KEY | int (4) |  | The override for the recipient's distribution code.
is_hsa_override | bit (1) |  | The override for whether or not the recipient's amount applies to HSA.
is_archer_msa_override | bit (1) |  | The override for whether or not the recipient's amount applies to Archer MSA.
is_msa_override | bit (1) |  | The override for whether or not the recipient's amount applies to MSA.
original_override__form_1099_sa_distribution_code_KEY | int (4) |  | Original override of form 1099 sa distribution code.
is_hsa_original_override | bit (1) |  | Original override of whether is hsa
is_archer_msa_original_override | bit (1) |  | Original override of whether is archer msa.
is_msa_original_override | bit (1) |  | Original override of whether is msa.
corrected_override__form_1099_sa_distribution_code_KEY | int (4) |  | Corrected override of form 1099 sa distribution code.
is_hsa_corrected_override | bit (1) |  | Corrected override of whether is hsa
is_archer_msa_corrected_override | bit (1) |  | Corrected override of whether is archer msa.
is_msa_corrected_override | bit (1) |  | Corrected override of whether is msa.

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

Foreign keys
Name | Columns | Referenced table | Description
FK_Form_1099_Sa_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1099 (form_1099_KEY) |
FK_Form_1099_Sa_Option__Form_1099_Sa_Distribution_Code__corrected_override__form_1099_sa_distribution_code_KEY | corrected_override__form_1099_sa_distribution_code_KEY | Form_1099_Sa_Distribution_Code (form_1099_sa_distribution_code_KEY) |
FK_Form_1099_Sa_Option__Form_1099_Sa_Distribution_Code__form_1099_sa_distribution_code_KEY | form_1099_sa_distribution_code_KEY | Form_1099_Sa_Distribution_Code (form_1099_sa_distribution_code_KEY) |
FK_Form_1099_Sa_Option__Form_1099_Sa_Distribution_Code__original_override__form_1099_sa_distribution_code_KEY | original_override__form_1099_sa_distribution_code_KEY | Form_1099_Sa_Distribution_Code (form_1099_sa_distribution_code_KEY) |
FK_Form_1099_Sa_Option__Form_1099_Sa_Distribution_Code__override__form_1099_sa_distribution_code_KEY | override__form_1099_sa_distribution_code_KEY | Form_1099_Sa_Distribution_Code (form_1099_sa_distribution_code_KEY) |