Table: dbo.Form_1099_Sa_Option
Detailed options for 1099-SA form
Columns
NameTypeConstraintsDescription
form_1099_KEYint (4)NOT NULLPrimary key and foreign key to the Form_1099_Option table
form_1099_sa_distribution_code_KEYint (4)Form 1099-SA option: distribution code
is_hsabit (1)NOT NULLForm 1099-SA option: HSA
is_archer_msabit (1)NOT NULLForm 1099-SA option: archer MSA
is_ma_msabit (1)NOT NULLForm 1099-SA option: MA MSA
override__form_1099_sa_distribution_code_KEYint (4)The override for the recipient's distribution code.
is_hsa_overridebit (1)The override for whether or not the recipient's amount applies to HSA.
is_archer_msa_overridebit (1)The override for whether or not the recipient's amount applies to Archer MSA.
is_msa_overridebit (1)The override for whether or not the recipient's amount applies to MSA.
original_override__form_1099_sa_distribution_code_KEYint (4)Original override of form 1099 sa distribution code.
is_hsa_original_overridebit (1)Original override of whether is hsa
is_archer_msa_original_overridebit (1)Original override of whether is archer msa.
is_msa_original_overridebit (1)Original override of whether is msa.
corrected_override__form_1099_sa_distribution_code_KEYint (4)Corrected override of form 1099 sa distribution code.
is_hsa_corrected_overridebit (1)Corrected override of whether is hsa
is_archer_msa_corrected_overridebit (1)Corrected override of whether is archer msa.
is_msa_corrected_overridebit (1)Corrected override of whether is msa.
Primary key
NameColumnsDescription
PK_Form_1099_Sa_Option$form_1099_KEYform_1099_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Form_1099_Sa_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1099 (form_1099_KEY)
FK_Form_1099_Sa_Option__Form_1099_Sa_Distribution_Code__corrected_override__form_1099_sa_distribution_code_KEYcorrected_override__form_1099_sa_distribution_code_KEYForm_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_KEYform_1099_sa_distribution_code_KEYForm_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_KEYoriginal_override__form_1099_sa_distribution_code_KEYForm_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_KEYoverride__form_1099_sa_distribution_code_KEYForm_1099_Sa_Distribution_Code (form_1099_sa_distribution_code_KEY)

Schema diagram