Table: dbo.W2_1099_User_Preference
Table used to store user preferences for W-2s and 1099s
Columns
NameTypeConstraintsDescription
user_preference_KEYint (4)NOT NULL
w2_employee_sort_type_KEYint (4)NOT NULLThe order the employees w-2s are printed
vendor_1099_sort_type_KEYint (4)NOT NULLThe order the 1099s are printed.
form_1098_printing_thresholdint (4)NOT NULLThe minimum amount needed for the 1098 to print.
form_1098_ignore_per_item_threshold_overridesbit (1)NOT NULLWhether or not threshold overrides set on the bank transaction should be ignored.
form_1099A_printing_thresholdint (4)NOT NULLThe minimum amount needed for the 1099A to print.
form_1099A_ignore_per_item_threshold_overridesbit (1)NOT NULLWhether or not threshold overrides set on the bank transaction should be ignored.
form_1099B_printing_thresholdint (4)NOT NULLThe minimum amount needed for the 1099B to print.
form_1099B_ignore_per_item_threshold_overridesbit (1)NOT NULLWhether or not threshold overrides set on the bank transaction should be ignored.
form_1099Div_printing_thresholdint (4)NOT NULLThe minimum amount needed for the 1099Div to print.
form_1099Div_ignore_per_item_threshold_overridesbit (1)NOT NULLWhether or not threshold overrides set on the bank transaction should be ignored.
form_1099G_printing_thresholdint (4)NOT NULLThe minimum amount needed for the 1099G to print.
form_1099G_ignore_per_item_threshold_overridesbit (1)NOT NULLWhether or not threshold overrides set on the bank transaction should be ignored.
form_1099Int_printing_thresholdint (4)NOT NULLThe minimum amount needed for the 1099Int to print.
form_1099Int_ignore_per_item_threshold_overridesbit (1)NOT NULLWhether or not threshold overrides set on the bank transaction should be ignored.
form_1099Misc_printing_thresholdint (4)NOT NULLThe minimum amount needed for the 1099Misc to print.
form_1099Misc_ignore_per_item_threshold_overridesbit (1)NOT NULLWhether or not threshold overrides set on the bank transaction should be ignored.
form_1099Oid_printing_thresholdint (4)NOT NULLThe minimum amount needed for the 1099Oid to print.
form_1099Oid_ignore_per_item_threshold_overridesbit (1)NOT NULLWhether or not threshold overrides set on the bank transaction should be ignored.
form_1099Patr_printing_thresholdint (4)NOT NULLThe minimum amount needed for the 1099Patr to print.
form_1099Patr_ignore_per_item_threshold_overridesbit (1)NOT NULLWhether or not threshold overrides set on the bank transaction should be ignored.
form_1099R_printing_thresholdint (4)NOT NULLThe minimum amount needed for the 1099R to print.
form_1099R_ignore_per_item_threshold_overridesbit (1)NOT NULLWhether or not threshold overrides set on the bank transaction should be ignored.
form_1099S_printing_thresholdint (4)NOT NULLThe minimum amount needed for the 1099S to print.
form_1099S_ignore_per_item_threshold_overridesbit (1)NOT NULLWhether or not threshold overrides set on the bank transaction should be ignored.
form_1099Sa_printing_thresholdint (4)NOT NULLThe minimum amount needed for the 1099Sa to print.
form_1099Sa_ignore_per_item_threshold_overridesbit (1)NOT NULLWhether or not threshold overrides set on the bank transaction should be ignored.
form_5498_printing_thresholdint (4)NOT NULLThe minimum amount needed for the 5498 to print.
form_5498_ignore_per_item_threshold_overridesbit (1)NOT NULLWhether or not threshold overrides set on the bank transaction should be ignored.
form_5498Sa_printing_thresholdint (4)NOT NULLThe minimum amount needed for the 5498Sa to print.
form_5498Sa_ignore_per_item_threshold_overridesbit (1)NOT NULLWhether or not threshold overrides set on the bank transaction should be ignored.
w2_copy_a_w3__tax_form_filing_method_KEYint (4)NOT NULLThe filing method selection to use for all W-2 Copy A/W-3 forms
w2_employee_copy__tax_form_filing_method_KEYint (4)NOT NULLThe filing method selection to use for all W-2 Employee copy forms
w2__w2_1099_ordering_worksheet_client_option_KEYint (4)NOT NULLThis is how the client information will be displayed on the W-2 ordering worksheet. It will be one if no client detail should be displayed, two for the client list, and three for the client detail.
form_1099__w2_1099_ordering_worksheet_client_option_KEYint (4)NOT NULLThis is how the client information will be displayed on the 1099 ordering worksheet. It will be one if no client detail should be displayed, two for the client list, and three for the client detail.
w2_copy_a_client_copy_type_KEYint (4)NOT NULLKey to the W2_Copy_A_Client_Copy_Type table for the client copy type to use for the W-2 Copy A.
w3_client_copy_type_KEYint (4)NOT NULLKey to the W3_Client_Copy_Type table for the client copy type to use for the W-3.
form_W2G_ignore_per_item_threshold_overridesbit (1)NOT NULLWhether or not threshold overrides set on the bank transaction should be ignored.
form_W2G_printing_thresholdint (4)NOT NULLThe minimum amount needed for the W-2G for it to print.
form_1098_copy_a_1096__tax_form_filing_method_KEYint (4)NOT NULLThe filing method selection to use for all 1098 Copy A/1096 forms
form_1098_recipient_copy__tax_form_filing_method_KEYint (4)NOT NULLThe filing method selection to use for all 1098 Recipient copy forms
form_1099_a_copy_a_1096__tax_form_filing_method_KEYint (4)NOT NULLThe filing method selection to use for all 1099-A Copy A/1096 forms
form_1099_b_copy_a_1096__tax_form_filing_method_KEYint (4)NOT NULLThe filing method selection to use for all 1099-B Copy A/1096 forms
form_1099_div_copy_a_1096__tax_form_filing_method_KEYint (4)NOT NULLThe filing method selection to use for all 1099-DIV Copy A/1096 forms
form_1099_g_copy_a_1096__tax_form_filing_method_KEYint (4)NOT NULLThe filing method selection to use for all 1099-G Copy A/1096 forms
form_1099_int_copy_a_1096__tax_form_filing_method_KEYint (4)NOT NULLThe filing method selection to use for all 1099-INT Copy A/1096 forms
form_1099_int_recipient_copy__tax_form_filing_method_KEYint (4)NOT NULLThe filing method selection to use for all 1099-INT Recipient copy forms
form_1099_misc_copy_a_1096__tax_form_filing_method_KEYint (4)NOT NULLThe filing method selection to use for all 1099-MISC Copy A/1096 forms
form_1099_misc_recipient_copy__tax_form_filing_method_KEYint (4)NOT NULLThe filing method selection to use for all 1099-MISC Recipient copy forms
form_1099_oid_copy_a_1096__tax_form_filing_method_KEYint (4)NOT NULLThe filing method selection to use for all 1099-OID Copy A/1096 forms
form_1099_patr_copy_a_1096__tax_form_filing_method_KEYint (4)NOT NULLThe filing method selection to use for all 1099-PATR Copy A/1096 forms
form_1099_r_copy_a_1096__tax_form_filing_method_KEYint (4)NOT NULLThe filing method selection to use for all 1099-R Copy A/1096 forms
form_1099_s_copy_a_1096__tax_form_filing_method_KEYint (4)NOT NULLThe filing method selection to use for all 1099-S Copy A/1096 forms
form_1099_sa_copy_a_1096__tax_form_filing_method_KEYint (4)NOT NULLThe filing method selection to use for all 1099-SA Copy A/1096 forms
form_5498_copy_a_1096__tax_form_filing_method_KEYint (4)NOT NULLThe filing method selection to use for all 5498 Copy A/1096 forms
form_5498_sa_copy_a_1096__tax_form_filing_method_KEYint (4)NOT NULLThe filing method selection to use for all 5498-SA Copy A/1096 forms
form_w2g_copy_a_1096__tax_form_filing_method_KEYint (4)NOT NULLThe filing method selection to use for all W-2G Copy A/1096 forms
push_w2s_to_employee_self_servicebit (1)NOT NULLWhether or not W-2s should be pushed to ESS during the print run.
form_1099_copy_a_client_copy_type_KEYint (4)NOT NULLKey to the Form_1099_Copy_A_Client_Copy_Type table for the client copy type to use for the 1099 Copy A.
form_1096_client_copy_type_KEYint (4)NOT NULLKey to the Form_1096_Client_Copy_Type table for the client copy type to use for the 1096.
form_1099Misc_send_to_employee_self_servicebit (1)NOT NULLOverride flag for sending independent contractor 1099MISC forms to ESS.
use_W3_as_separator_pagebit (1)NOT NULLFlag which indicates if the separator page used when printing W2s should be a W3 copy instead of the standard separator page.
use_1096_as_separator_pagebit (1)NOT NULLFlag which indicates if the separator page used when printing 1099s should be a 1096 copy instead of the standard separator page.
exclude_2D_barcodebit (1)NOT NULLFlag which indicates if the 2D barcode should be excluded when printing W2s and W3s.
w2_separator_page_watermark_indicatorbit (1)NOT NULLIndicator on whether a watermark should appear on the separator page default value 0 (false)
w2_separator_page_watermark_textnvarchar (100)NOT NULLText of the watermark that will appear on the separator page
form_1099_separator_page_watermark_indicatorbit (1)NOT NULLIndicator on whether a watermark should appear on the separator page default value 0 (false)
form_1099_separator_page_watermark_textnvarchar (100)NOT NULLText of the watermark that will appear on the separator page
hide_1099_copy_abit (1)NOT NULLA bool flag to indicate whether to hide Copy A when processing 1099s.
hide_1099_copy_bbit (1)NOT NULLA bool flag to indicate whether to hide Copy B when processing 1099s.
hide_1099_copy_cbit (1)NOT NULLA bool flag to indicate whether to hide Copy C when processing 1099s.
hide_1099_copy_dbit (1)NOT NULLA bool flag to indicate whether to hide Copy D when processing 1099s.
hide_1099_copy_1bit (1)NOT NULLA bool flag to indicate whether to hide Copy 1 when processing 1099s.
hide_1099_copy_2bit (1)NOT NULLA bool flag to indicate whether to hide Copy 2 when processing 1099s.
hide_1099_copy_b_2bit (1)NOT NULLA bool flag to indicate whether to hide Copy B/2 when processing 1099s.
hide_1099_1096bit (1)NOT NULLA bool flag to indicate whether to hide 1096 when processing 1099s.
form_1098E_printing_thresholdint (4)NOT NULLThe minimum amount needed for the 1098E to print.
form_1098E_ignore_per_item_threshold_overridesbit (1)NOT NULLWhether or not threshold overrides set on the bank transaction should be ignored.
form_1098_E_copy_a_1096__tax_form_filing_method_KEYint (4)NOT NULLThe filing method selection to use for all 1098-E Copy A/1096 forms.
form_1098C_printing_thresholdint (4)NOT NULLThe minimum amount needed for the 1098C to print.
form_1098C_ignore_per_item_threshold_overridesbit (1)NOT NULLWhether or not threshold overrides set on the bank transaction should be ignored.
form_1098C_copy_a_1096__tax_form_filing_method_KEYint (4)NOT NULLThe filing method selection to use for all 1098-C Copy A/1096 forms.
form_1099C_printing_thresholdint (4)NOT NULLThe minimum amount needed for the 1099C to print
form_1099C_ignore_per_item_threshold_overridesbit (1)NOT NULLWhether or not threshold overrides set on the bank transaction should be ignored.
form_1099_c_copy_a_1096__tax_form_filing_method_KEYint (4)NOT NULLThe filing method selection to use for all 1099-C Copy A/1096 forms.
form_1098T_printing_thresholdint (4)NOT NULLThe minimum amount needed for the 1098-T to print
form_1098T_ignore_per_item_threshold_overridesbit (1)NOT NULLWhether or not threshold overrides set on the bank transaction should be ignored.
form_1098_t_copy_a_1096__tax_form_filing_method_KEYint (4)NOT NULLThe filing method selection to use for all 1098-T Copy A/1096 forms.
vendor_1099_recipient_filter_type_KEYtinyint (1)NOT NULLThe selection to use for vendor 1099 recipient type.
push_w2s_to_workforce_hubbit (1)NOT NULLWhether or not W-2s should be pushed to Workforce Hub during the print run.
form_1099Misc_send_to_workforce_hubbit (1)NOT NULLOverride flag for sending independent contractor 1099MISC forms to Workforce Hub.
form_1099Nec_printing_thresholdint (4)NOT NULLThe minimum amount needed for the 1099-NEC to print
form_1099Nec_ignore_per_item_threshold_overridesbit (1)NOT NULLWhether or not threshold overrides set on the bank transaction should be ignored
form_1099_nec_copy_a_1096__tax_form_filing_method_KEYint (4)NOT NULLThe filing method selection to use for all 1099-NEC Copy A forms.
form_1099_nec_recipient_copy__tax_form_filing_method_KEYint (4)NOT NULLThe filing method selection to use for all 1099-NEC Recipient copy forms.
form_1099Nec_send_to_employee_self_servicebit (1)NOT NULLOverride flag for sending independent contractor 1099-NEC forms to ESS.
form_1099Nec_send_to_workforce_hubbit (1)NOT NULLOverride flag for sending independent contractor 1099-NEC forms to Workforce Hub.
Primary key
NameColumnsDescription
PK_W2_1099_User_Preference$user_preference_KEYuser_preference_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_W2_1099_User_Preference__Vendor_1099_Recipient_Filter_Type__vendor_1099_recipient_filter_type_KEYvendor_1099_recipient_filter_type_KEYVendor_1099_Recipient_Filter_Type (vendor_1099_recipient_filter_type_KEY)
FK_W2_1099_User_Preference__Tax_Form_Filing_Method__form_1098_E_copy_a_1096__tax_form_filing_method_KEYform_1098_E_copy_a_1096__tax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)
FK_W2_1099_User_Preference__Form_1096_Client_Copy_Type__form_1096_client_copy_type_KEYform_1096_client_copy_type_KEYForm_1096_Client_Copy_Type (form_1096_client_copy_type_KEY)
FK_W2_1099_User_Preference__Form_1099_Copy_A_Client_Copy_Type__form_1099_copy_a_client_copy_type_KEYform_1099_copy_a_client_copy_type_KEYForm_1099_Copy_A_Client_Copy_Type (form_1099_copy_a_client_copy_type_KEY)
FK_W2_1099_User_Preference__Tax_Form_Filing_Method__form_1098_copy_a_1096__tax_form_filing_method_KEYform_1098_copy_a_1096__tax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)
FK_W2_1099_User_Preference__Tax_Form_Filing_Method__form_1098_recipient_copy__tax_form_filing_method_KEYform_1098_recipient_copy__tax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)
FK_W2_1099_User_Preference__Tax_Form_Filing_Method__form_1099_a_copy_a_1096__tax_form_filing_method_KEYform_1099_a_copy_a_1096__tax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)
FK_W2_1099_User_Preference__Tax_Form_Filing_Method__form_1099_b_copy_a_1096__tax_form_filing_method_KEYform_1099_b_copy_a_1096__tax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)
FK_W2_1099_User_Preference__Tax_Form_Filing_Method__form_1099_div_copy_a_1096__tax_form_filing_method_KEYform_1099_div_copy_a_1096__tax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)
FK_W2_1099_User_Preference__Tax_Form_Filing_Method__form_1099_g_copy_a_1096__tax_form_filing_method_KEYform_1099_g_copy_a_1096__tax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)
FK_W2_1099_User_Preference__Tax_Form_Filing_Method__form_1099_int_copy_a_1096__tax_form_filing_method_KEYform_1099_int_copy_a_1096__tax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)
FK_W2_1099_User_Preference__Tax_Form_Filing_Method__form_1099_int_recipient_copy__tax_form_filing_method_KEYform_1099_int_recipient_copy__tax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)
FK_W2_1099_User_Preference__Tax_Form_Filing_Method__form_1099_misc_copy_a_1096__tax_form_filing_method_KEYform_1099_misc_copy_a_1096__tax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)
FK_W2_1099_User_Preference__Tax_Form_Filing_Method__form_1099_misc_recipient_copy__tax_form_filing_method_KEYform_1099_misc_recipient_copy__tax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)
FK_W2_1099_User_Preference__Tax_Form_Filing_Method__form_1099_oid_copy_a_1096__tax_form_filing_method_KEYform_1099_oid_copy_a_1096__tax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)
FK_W2_1099_User_Preference__Tax_Form_Filing_Method__form_1099_patr_copy_a_1096__tax_form_filing_method_KEYform_1099_patr_copy_a_1096__tax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)
FK_W2_1099_User_Preference__Tax_Form_Filing_Method__form_1099_r_copy_a_1096__tax_form_filing_method_KEYform_1099_r_copy_a_1096__tax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)
FK_W2_1099_User_Preference__Tax_Form_Filing_Method__form_1099_s_copy_a_1096__tax_form_filing_method_KEYform_1099_s_copy_a_1096__tax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)
FK_W2_1099_User_Preference__Tax_Form_Filing_Method__form_1098C_copy_a_1096__tax_form_filing_method_KEYform_1098C_copy_a_1096__tax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)
FK_W2_1099_User_Preference__Tax_Form_Filing_Method__form_1099_sa_copy_a_1096__tax_form_filing_method_KEYform_1099_sa_copy_a_1096__tax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)
FK_W2_1099_User_Preference__Tax_Form_Filing_Method__form_5498_copy_a_1096__tax_form_filing_method_KEYform_5498_copy_a_1096__tax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)
FK_W2_1099_User_Preference__Tax_Form_Filing_Method__form_5498_sa_copy_a_1096__tax_form_filing_method_KEYform_5498_sa_copy_a_1096__tax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)
FK_W2_1099_User_Preference__Tax_Form_Filing_Method__form_w2g_copy_a_1096__tax_form_filing_method_KEYform_w2g_copy_a_1096__tax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)
FK_W2_1099_User_Preference__Tax_Form_Filing_Method__w2_copy_a_w3__tax_form_filing_method_KEYw2_copy_a_w3__tax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)
FK_W2_1099_User_Preference__Tax_Form_Filing_Method__w2_employee_copy__tax_form_filing_method_KEYw2_employee_copy__tax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)
FK_W2_1099_User_Preference__User_Preference__user_preference_KEYuser_preference_KEYUser_Preference (user_preference_KEY)
FK_W2_1099_User_Preference__Vendor_1099_Sort_Type__vendor_1099_sort_type_KEYvendor_1099_sort_type_KEYVendor_1099_Sort_Type (vendor_1099_sort_type_KEY)
FK_W2_1099_User_Preference__W2_1099_Ordering_Worksheet_Client_Option__form_1099__w2_1099_ordering_worksheet_client_option_KEYform_1099__w2_1099_ordering_worksheet_client_option_KEYW2_1099_Ordering_Worksheet_Client_Option (w2_1099_ordering_worksheet_client_option_KEY)
FK_W2_1099_User_Preference__W2_1099_Ordering_Worksheet_Client_Option__w2__w2_1099_ordering_worksheet_client_option_KEYw2__w2_1099_ordering_worksheet_client_option_KEYW2_1099_Ordering_Worksheet_Client_Option (w2_1099_ordering_worksheet_client_option_KEY)
FK_W2_1099_User_Preference__W2_Copy_A_Client_Copy_Type__w2_copy_a_client_copy_type_KEYw2_copy_a_client_copy_type_KEYW2_Copy_A_Client_Copy_Type (w2_copy_a_client_copy_type_KEY)
FK_W2_1099_User_Preference__W2_Employee_Sort_Type__w2_employee_sort_type_KEYw2_employee_sort_type_KEYW2_Employee_Sort_Type (w2_employee_sort_type_KEY)
FK_W2_1099_User_Preference__W3_Client_Copy_Type__w3_client_copy_type_KEYw3_client_copy_type_KEYW3_Client_Copy_Type (w3_client_copy_type_KEY)
FK_W2_1099_User_Preference__Tax_Form_Filing_Method__form_1099_c_copy_a_1096__tax_form_filing_method_KEYform_1099_c_copy_a_1096__tax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)
FK__W2_1099_U__form___54E7FB81form_1099_nec_copy_a_1096__tax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)
FK__W2_1099_U__form___55DC1FBAform_1099_nec_recipient_copy__tax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)
FK_W2_1099_User_Preference__Tax_Form_Filing_Method__form_1098_t_copy_a_1096__tax_form_filing_method_KEYform_1098_t_copy_a_1096__tax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)

Schema diagram