Table: dbo.Form_1099_C_Option
Table for 1099-C form specific data
Columns
Name | Type | Constraints | Description
form_1099_KEY | int (4) | NOT NULL | Primary and Foreign Key
form_1099_c_event_code_KEY | tinyint (1) | NOT NULL | Identifiable Event Code key from Form_1099_C_Event_Code
date_of_event | date (3) |  | Date of Identifiable Event YYYY-MM-DD
debt_description | nvarchar (78) |  | Description of the original of the event
personal_liability_indicator | bit (1) | NOT NULL | Personal Liability Indicator
override_form_1099_c_event_code_KEY | tinyint (1) |  | Identifiable Event Code key override from Form_1099_C_Event_Code
date_of_event_override | date (3) |  | Date of Identifiable Event Override YYYY-MM-DD
debt_description_override | nvarchar (78) |  |
personal_liability_indicator_override | bit (1) |  | Personal Liability Indicator override
original_override_form_1099_c_event_code_KEY | tinyint (1) |  | Identifiable Event Code key original override from Form_1099_C_Event_Code
date_of_event_original_override | date (3) |  | Date of Identifiable Event original override YYYY-MM-DD
debt_description_original_override | nvarchar (78) |  | Description of the original of the event original override
personal_liability_indicator_original_override | bit (1) |  | Personal Liability Indicator original override
corrected_override_form_1099_c_event_code_KEY | tinyint (1) |  | Identifiable Event Code key corrected override from Form_1099_C_Event_Code
date_of_event_corrected_override | date (3) |  | Date of Identifiable Event corrected override YYYY-MM-DD
debt_description_corrected_override | nvarchar (78) |  | Description of the original of the event corrected override
personal_liability_indicator_corrected_override | bit (1) |  | Personal Liability Indicator corrected override

Primary key
Name | Columns | Description
PK_Form_1099_C_Option$form_1099_KEY | form_1099_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Form_1099_C_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1099 (form_1099_KEY) |
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_Event_Code (form_1099_c_event_code_KEY) |
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_Event_Code (form_1099_c_event_code_KEY) |
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_Event_Code (form_1099_c_event_code_KEY) |
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_Event_Code (form_1099_c_event_code_KEY) |