Table: dbo.Form_1099_C_Event_Code
Table for identifiable event code options for the 1099-C
Columns
NameTypeConstraintsDescription
form_1099_c_event_code_KEYtinyint (1)NOT NULLPrimary Key column
event_codenvarchar (2)NOT NULLForm 1099-C Identifiable Event Code
descriptionnvarchar (120)NOT NULLForm 1099-C Identifiable Event Code Description
starting_yearsmallint (2)NOT NULLForm 1099-C starting year as CCYY
ending_yearsmallint (2)Form 1099-C ending year as CCYY. NULL indicates still active code
Primary key
NameColumnsDescription
PK_Form_1099_C_Event_Codeform_1099_c_event_code_KEY
Unique constraints
NameColumnsDescription
UK_Form_1099_C_Event_Code$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Form_1099_C_Option__Form_1099_C_Event_Code__form_1099_c_event_code_KEYform_1099_c_event_code_KEYForm_1099_C_Option
FK_Form_1099_C_Option__Form_1099_C_Event_Code__override_form_1099_c_event_code_KEYoverride_form_1099_c_event_code_KEYForm_1099_C_Option
FK_Form_1099_C_Option__Form_1099_C_Event_Code__original_override_form_1099_c_event_code_KEYoriginal_override_form_1099_c_event_code_KEYForm_1099_C_Option
FK_Form_1099_C_Option__Form_1099_C_Event_Code__corrected_override_form_1099_c_event_code_KEYcorrected_override_form_1099_c_event_code_KEYForm_1099_C_Option

Schema diagram