Table: dbo.Form_1099_R_Distribution_Code_Map
Ties first distribution codes to the potential options for second distribution code
Columns
NameTypeConstraintsDescription
form_1099_r_distribution_code_map_KEYint (4)NOT NULLPrimary key to the Form_1099_R_Distribution_Sub_Code table
primary__form_1099_r_distribution_code_KEYint (4)NOT NULLThe code selected as first distribution code
secondary__form_1099_r_distribution_code_KEYint (4)NOT NULLThe code available as an option for second distribution code
Primary key
NameColumnsDescription
PK_Form_1099_R_Distribution_Code_Mapform_1099_r_distribution_code_map_KEY
Unique constraints
NameColumnsDescription
UK_Form_1099_R_Distribution_Code_Map$primary__form_1099_r_distribution_code_KEY$secondary__form_1099_r_distribution_code_KEYprimary__form_1099_r_distribution_code_KEY, secondary__form_1099_r_distribution_code_KEY
Foreign keys
NameColumnsReferenced 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 (form_1099_r_distribution_code_KEY)
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 (form_1099_r_distribution_code_KEY)

Schema diagram