Table: dbo.Form_1095_User_Preference
This table form 1095 user preferences.
Columns
NameTypeConstraintsDescription
user_preference_KEYint (4)NOT NULLThe primary key.
w2_employee_sort_type_KEYint (4)NOT NULLThe W2 employee sort type.
form_1094C__tax_form_filing_method_KEYint (4)NOT NULLThe 1094C tax form filing method.
form_1095C__tax_form_filing_method_KEYint (4)NOT NULLThe 1095C tax form filing method.
form_1095C_send_to_employee_self_servicebit (1)NOT NULLFlag to indicate if the 1095C should be sent to ESS.
use_1094C_as_separator_pagebit (1)NOT NULLFlag which indicates if the separator page used when printing 1095-Cs should be a 1094-C copy instead of the standard separator page.
form_1095C_separator_page_watermark_indicatorbit (1)NOT NULLIndicator whether a watermark should appear on the separator page. Default value 0 (false).
form_1095C_separator_page_watermark_textnvarchar (100)NOT NULLText of the watermark that will appear on the separator page.
form_1095BC_send_to_workforce_hubbit (1)NOT NULLFlag to indicate if the 1095B and 1095C should be sent to Workforce Hub.
Primary key
NameColumnsDescription
PK_Form_1095_User_Preference$user_preference_KEYuser_preference_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Form_1095_User_Preference__user_preference_KEYuser_preference_KEYUser_Preference (user_preference_KEY)
FK_Form_1095_User_Preference__w2_employee_sort_type_KEYw2_employee_sort_type_KEYW2_Employee_Sort_Type (w2_employee_sort_type_KEY)
FK_Form_1095_User_Preference__form_1094C__tax_form_filing_method_KEYform_1094C__tax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)
FK_Form_1095_User_Preference__form_1095C__tax_form_filing_method_KEYform_1095C__tax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)

Schema diagram