Table: dbo.Form_1099_C_Option
Table for 1099-C form specific data
Columns
NameTypeConstraintsDescription
form_1099_KEYint (4)NOT NULLPrimary and Foreign Key
form_1099_c_event_code_KEYtinyint (1)NOT NULLIdentifiable Event Code key from Form_1099_C_Event_Code
date_of_eventdate (3)Date of Identifiable Event YYYY-MM-DD
debt_descriptionnvarchar (78)Description of the original of the event
personal_liability_indicatorbit (1)NOT NULLPersonal Liability Indicator
override_form_1099_c_event_code_KEYtinyint (1)Identifiable Event Code key override from Form_1099_C_Event_Code
date_of_event_overridedate (3)Date of Identifiable Event Override YYYY-MM-DD
debt_description_overridenvarchar (78)
personal_liability_indicator_overridebit (1)Personal Liability Indicator override
original_override_form_1099_c_event_code_KEYtinyint (1)Identifiable Event Code key original override from Form_1099_C_Event_Code
date_of_event_original_overridedate (3)Date of Identifiable Event original override YYYY-MM-DD
debt_description_original_overridenvarchar (78)Description of the original of the event original override
personal_liability_indicator_original_overridebit (1)Personal Liability Indicator original override
corrected_override_form_1099_c_event_code_KEYtinyint (1)Identifiable Event Code key corrected override from Form_1099_C_Event_Code
date_of_event_corrected_overridedate (3)Date of Identifiable Event corrected override YYYY-MM-DD
debt_description_corrected_overridenvarchar (78)Description of the original of the event corrected override
personal_liability_indicator_corrected_overridebit (1)Personal Liability Indicator corrected override
Primary key
NameColumnsDescription
PK_Form_1099_C_Option$form_1099_KEYform_1099_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Form_1099_C_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1099 (form_1099_KEY)
FK_Form_1099_C_Option__Form_1099_C_Event_Code__form_1099_c_event_code_KEYform_1099_c_event_code_KEYForm_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_KEYoverride_form_1099_c_event_code_KEYForm_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_KEYoriginal_override_form_1099_c_event_code_KEYForm_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_KEYcorrected_override_form_1099_c_event_code_KEYForm_1099_C_Event_Code (form_1099_c_event_code_KEY)

Schema diagram