Table: dbo.Form_1099_C_Event_Code
Table for identifiable event code options for the 1099-C
Columns
Name | Type | Constraints | Description
form_1099_c_event_code_KEY | tinyint (1) | NOT NULL | Primary Key column
event_code | nvarchar (2) | NOT NULL | Form 1099-C Identifiable Event Code
description | nvarchar (120) | NOT NULL | Form 1099-C Identifiable Event Code Description
starting_year | smallint (2) | NOT NULL | Form 1099-C starting year as CCYY
ending_year | smallint (2) |  | Form 1099-C ending year as CCYY. NULL indicates still active code

Primary key
Name | Columns | Description
PK_Form_1099_C_Event_Code | form_1099_c_event_code_KEY |
Unique constraints
Name | Columns | Description
UK_Form_1099_C_Event_Code$description | description |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Form_1099_C_Option__Form_1099_C_Event_Code__form_1099_c_event_code_KEY | form_1099_c_event_code_KEY | Form_1099_C_Option |
FK_Form_1099_C_Option__Form_1099_C_Event_Code__override_form_1099_c_event_code_KEY | override_form_1099_c_event_code_KEY | Form_1099_C_Option |
FK_Form_1099_C_Option__Form_1099_C_Event_Code__original_override_form_1099_c_event_code_KEY | original_override_form_1099_c_event_code_KEY | Form_1099_C_Option |
FK_Form_1099_C_Option__Form_1099_C_Event_Code__corrected_override_form_1099_c_event_code_KEY | corrected_override_form_1099_c_event_code_KEY | Form_1099_C_Option |