Table: dbo.Form_1099_R_Distribution_Code
Distribution codes for the 1099-R form, box 7
Columns
Name | Type | Constraints | Description
form_1099_r_distribution_code_KEY | int (4) | NOT NULL | Primary key to the Form_1099_R_Distribution_Code table
distribution_code | nvarchar (2) | NOT NULL | Single character code entered into the 1099-R form
description | nvarchar (512) | NOT NULL | Description of the code entered into the 1099-R form
starting_year | int (4) | NOT NULL | The year this code went into effect
ending_year | int (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
Name | Columns | Description
PK_Form_1099_R_Distribution_Code | form_1099_r_distribution_code_KEY |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Form_1099_R_Distribution_Code_Map__Form_1099_R_Distribution_Code__primary__form_1099_r_distribution_code_KEY | primary__form_1099_r_distribution_code_KEY | Form_1099_R_Distribution_Code_Map |
FK_Form_1099_R_Distribution_Code_Map__Form_1099_R_Distribution_Code__secondary__form_1099_r_distribution_code_KEY | secondary__form_1099_r_distribution_code_KEY | Form_1099_R_Distribution_Code_Map |
FK_Form_1099_R_Option__Form_1099_R_Distribution_Code__corrected_override_first__form_1099_r_distribution_code_KEY | corrected_override_first__form_1099_r_distribution_code_KEY | Form_1099_R_Option |
FK_Form_1099_R_Option__Form_1099_R_Distribution_Code__corrected_override_second__form_1099_r_distribution_code_KEY | corrected_override_second__form_1099_r_distribution_code_KEY | Form_1099_R_Option |
FK_Form_1099_R_Option__Form_1099_R_Distribution_Code__first__form_1099_r_distribution_code_KEY | first__form_1099_r_distribution_code_KEY | Form_1099_R_Option |
FK_Form_1099_R_Option__Form_1099_R_Distribution_Code__original_override_first__form_1099_r_distribution_code_KEY | original_override_first__form_1099_r_distribution_code_KEY | Form_1099_R_Option |
FK_Form_1099_R_Option__Form_1099_R_Distribution_Code__original_override_second__form_1099_r_distribution_code_KEY | original_override_second__form_1099_r_distribution_code_KEY | Form_1099_R_Option |
FK_Form_1099_R_Option__Form_1099_R_Distribution_Code__override_first__form_1099_r_distribution_code_KEY | override_first__form_1099_r_distribution_code_KEY | Form_1099_R_Option |
FK_Form_1099_R_Option__Form_1099_R_Distribution_Code__override_second__form_1099_r_distribution_code_KEY | override_second__form_1099_r_distribution_code_KEY | Form_1099_R_Option |
FK_Form_1099_R_Option__Form_1099_R_Distribution_Code__second__form_1099_r_distribution_code_KEY | second__form_1099_r_distribution_code_KEY | Form_1099_R_Option |