Table: dbo.Form_1099_R_Distribution_Code
Distribution codes for the 1099-R form, box 7
Columns
NameTypeConstraintsDescription
form_1099_r_distribution_code_KEYint (4)NOT NULLPrimary key to the Form_1099_R_Distribution_Code table
distribution_codenvarchar (2)NOT NULLSingle character code entered into the 1099-R form
descriptionnvarchar (512)NOT NULLDescription of the code entered into the 1099-R form
starting_yearint (4)NOT NULLThe year this code went into effect
ending_yearint (4)The last year this code is valid, or null if the code is still valid for all years after the starting year
Primary key
NameColumnsDescription
PK_Form_1099_R_Distribution_Codeform_1099_r_distribution_code_KEY
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Form_1099_R_Distribution_Code_Map__Form_1099_R_Distribution_Code__primary__form_1099_r_distribution_code_KEYprimary__form_1099_r_distribution_code_KEYForm_1099_R_Distribution_Code_Map
FK_Form_1099_R_Distribution_Code_Map__Form_1099_R_Distribution_Code__secondary__form_1099_r_distribution_code_KEYsecondary__form_1099_r_distribution_code_KEYForm_1099_R_Distribution_Code_Map
FK_Form_1099_R_Option__Form_1099_R_Distribution_Code__corrected_override_first__form_1099_r_distribution_code_KEYcorrected_override_first__form_1099_r_distribution_code_KEYForm_1099_R_Option
FK_Form_1099_R_Option__Form_1099_R_Distribution_Code__corrected_override_second__form_1099_r_distribution_code_KEYcorrected_override_second__form_1099_r_distribution_code_KEYForm_1099_R_Option
FK_Form_1099_R_Option__Form_1099_R_Distribution_Code__first__form_1099_r_distribution_code_KEYfirst__form_1099_r_distribution_code_KEYForm_1099_R_Option
FK_Form_1099_R_Option__Form_1099_R_Distribution_Code__original_override_first__form_1099_r_distribution_code_KEYoriginal_override_first__form_1099_r_distribution_code_KEYForm_1099_R_Option
FK_Form_1099_R_Option__Form_1099_R_Distribution_Code__original_override_second__form_1099_r_distribution_code_KEYoriginal_override_second__form_1099_r_distribution_code_KEYForm_1099_R_Option
FK_Form_1099_R_Option__Form_1099_R_Distribution_Code__override_first__form_1099_r_distribution_code_KEYoverride_first__form_1099_r_distribution_code_KEYForm_1099_R_Option
FK_Form_1099_R_Option__Form_1099_R_Distribution_Code__override_second__form_1099_r_distribution_code_KEYoverride_second__form_1099_r_distribution_code_KEYForm_1099_R_Option
FK_Form_1099_R_Option__Form_1099_R_Distribution_Code__second__form_1099_r_distribution_code_KEYsecond__form_1099_r_distribution_code_KEYForm_1099_R_Option

Schema diagram