Table: dbo.Form_1099_R_Distribution_Code_Map
Ties first distribution codes to the potential options for second distribution code
Columns
Name | Type | Constraints | Description
form_1099_r_distribution_code_map_KEY | int (4) | NOT NULL | Primary key to the Form_1099_R_Distribution_Sub_Code table
primary__form_1099_r_distribution_code_KEY | int (4) | NOT NULL | The code selected as first distribution code
secondary__form_1099_r_distribution_code_KEY | int (4) | NOT NULL | The code available as an option for second distribution code

Primary key
Name | Columns | Description
PK_Form_1099_R_Distribution_Code_Map | form_1099_r_distribution_code_map_KEY |
Unique constraints
Name | Columns | Description
UK_Form_1099_R_Distribution_Code_Map$primary__form_1099_r_distribution_code_KEY$secondary__form_1099_r_distribution_code_KEY | primary__form_1099_r_distribution_code_KEY, secondary__form_1099_r_distribution_code_KEY |

Foreign keys
Name | Columns | Referenced 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 (form_1099_r_distribution_code_KEY) |
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 (form_1099_r_distribution_code_KEY) |