Table: dbo.W2_1099_User_Preference
Table used to store user preferences for W-2s and 1099s
Columns
Name | Type | Constraints | Description
user_preference_KEY | int (4) | NOT NULL |
w2_employee_sort_type_KEY | int (4) | NOT NULL | The order the employees w-2s are printed
vendor_1099_sort_type_KEY | int (4) | NOT NULL | The order the 1099s are printed.
form_1098_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1098 to print.
form_1098_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored.
form_1099A_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1099A to print.
form_1099A_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored.
form_1099B_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1099B to print.
form_1099B_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored.
form_1099Div_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1099Div to print.
form_1099Div_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored.
form_1099G_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1099G to print.
form_1099G_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored.
form_1099Int_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1099Int to print.
form_1099Int_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored.
form_1099Misc_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1099Misc to print.
form_1099Misc_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored.
form_1099Oid_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1099Oid to print.
form_1099Oid_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored.
form_1099Patr_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1099Patr to print.
form_1099Patr_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored.
form_1099R_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1099R to print.
form_1099R_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored.
form_1099S_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1099S to print.
form_1099S_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored.
form_1099Sa_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1099Sa to print.
form_1099Sa_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored.
form_5498_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 5498 to print.
form_5498_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored.
form_5498Sa_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 5498Sa to print.
form_5498Sa_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored.
w2_copy_a_w3__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all W-2 Copy A/W-3 forms
w2_employee_copy__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all W-2 Employee copy forms
w2__w2_1099_ordering_worksheet_client_option_KEY | int (4) | NOT NULL | This 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_KEY | int (4) | NOT NULL | This 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_KEY | int (4) | NOT NULL | Key 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_KEY | int (4) | NOT NULL | Key to the W3_Client_Copy_Type table for the client copy type to use for the W-3.
form_W2G_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored.
form_W2G_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the W-2G for it to print.
form_1098_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1098 Copy A/1096 forms
form_1098_recipient_copy__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1098 Recipient copy forms
form_1099_a_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-A Copy A/1096 forms
form_1099_b_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-B Copy A/1096 forms
form_1099_div_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-DIV Copy A/1096 forms
form_1099_g_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-G Copy A/1096 forms
form_1099_int_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-INT Copy A/1096 forms
form_1099_int_recipient_copy__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-INT Recipient copy forms
form_1099_misc_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-MISC Copy A/1096 forms
form_1099_misc_recipient_copy__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-MISC Recipient copy forms
form_1099_oid_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-OID Copy A/1096 forms
form_1099_patr_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-PATR Copy A/1096 forms
form_1099_r_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-R Copy A/1096 forms
form_1099_s_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-S Copy A/1096 forms
form_1099_sa_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-SA Copy A/1096 forms
form_5498_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 5498 Copy A/1096 forms
form_5498_sa_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 5498-SA Copy A/1096 forms
form_w2g_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all W-2G Copy A/1096 forms
push_w2s_to_employee_self_service | bit (1) | NOT NULL | Whether or not W-2s should be pushed to ESS during the print run.
form_1099_copy_a_client_copy_type_KEY | int (4) | NOT NULL | Key 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_KEY | int (4) | NOT NULL | Key to the Form_1096_Client_Copy_Type table for the client copy type to use for the 1096.
form_1099Misc_send_to_employee_self_service | bit (1) | NOT NULL | Override flag for sending independent contractor 1099MISC forms to ESS.
use_W3_as_separator_page | bit (1) | NOT NULL | Flag 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_page | bit (1) | NOT NULL | Flag which indicates if the separator page used when printing 1099s should be a 1096 copy instead of the standard separator page.
w2_separator_page_watermark_indicator | bit (1) | NOT NULL | Indicator on whether a watermark should appear on the separator page default value 0 (false)
w2_separator_page_watermark_text | nvarchar (100) | NOT NULL | Text of the watermark that will appear on the separator page
form_1099_separator_page_watermark_indicator | bit (1) | NOT NULL | Indicator on whether a watermark should appear on the separator page default value 0 (false)
form_1099_separator_page_watermark_text | nvarchar (100) | NOT NULL | Text of the watermark that will appear on the separator page
hide_1099_copy_a | bit (1) | NOT NULL | A bool flag to indicate whether to hide Copy A when processing 1099s.
hide_1099_copy_b | bit (1) | NOT NULL | A bool flag to indicate whether to hide Copy B when processing 1099s.
hide_1099_copy_c | bit (1) | NOT NULL | A bool flag to indicate whether to hide Copy C when processing 1099s.
hide_1099_copy_d | bit (1) | NOT NULL | A bool flag to indicate whether to hide Copy D when processing 1099s.
hide_1099_copy_1 | bit (1) | NOT NULL | A bool flag to indicate whether to hide Copy 1 when processing 1099s.
hide_1099_copy_2 | bit (1) | NOT NULL | A bool flag to indicate whether to hide Copy 2 when processing 1099s.
hide_1099_copy_b_2 | bit (1) | NOT NULL | A bool flag to indicate whether to hide Copy B/2 when processing 1099s.
hide_1099_1096 | bit (1) | NOT NULL | A bool flag to indicate whether to hide 1096 when processing 1099s.
form_1098E_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1098E to print.
form_1098E_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored.
form_1098_E_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1098-E Copy A/1096 forms.
form_1098C_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1098C to print.
form_1098C_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored.
form_1098C_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1098-C Copy A/1096 forms.
form_1099C_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1099C to print
form_1099C_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored.
form_1099_c_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-C Copy A/1096 forms.
form_1098T_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1098-T to print
form_1098T_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored.
form_1098_t_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1098-T Copy A/1096 forms.
vendor_1099_recipient_filter_type_KEY | tinyint (1) | NOT NULL | The selection to use for vendor 1099 recipient type.
push_w2s_to_workforce_hub | bit (1) | NOT NULL | Whether or not W-2s should be pushed to WorkforceHub during the print run.
form_1099Misc_send_to_workforce_hub | bit (1) | NOT NULL | Override flag for sending independent contractor 1099MISC forms to WorkforceHub.
form_1099Nec_printing_threshold | int (4) | NOT NULL | The minimum amount needed for the 1099-NEC to print
form_1099Nec_ignore_per_item_threshold_overrides | bit (1) | NOT NULL | Whether or not threshold overrides set on the bank transaction should be ignored
form_1099_nec_copy_a_1096__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-NEC Copy A forms.
form_1099_nec_recipient_copy__tax_form_filing_method_KEY | int (4) | NOT NULL | The filing method selection to use for all 1099-NEC Recipient copy forms.
form_1099Nec_send_to_employee_self_service | bit (1) | NOT NULL | Override flag for sending independent contractor 1099-NEC forms to ESS.
form_1099Nec_send_to_workforce_hub | bit (1) | NOT NULL | Override flag for sending independent contractor 1099-NEC forms to WorkforceHub.

Primary key
Name | Columns | Description
PK_W2_1099_User_Preference$user_preference_KEY | user_preference_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_W2_1099_User_Preference__Vendor_1099_Recipient_Filter_Type__vendor_1099_recipient_filter_type_KEY | vendor_1099_recipient_filter_type_KEY | Vendor_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_KEY | form_1098_E_copy_a_1096__tax_form_filing_method_KEY | Tax_Form_Filing_Method (tax_form_filing_method_KEY) |
FK_W2_1099_User_Preference__Form_1096_Client_Copy_Type__form_1096_client_copy_type_KEY | form_1096_client_copy_type_KEY | Form_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_KEY | form_1099_copy_a_client_copy_type_KEY | Form_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_KEY | form_1098_copy_a_1096__tax_form_filing_method_KEY | Tax_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_KEY | form_1098_recipient_copy__tax_form_filing_method_KEY | Tax_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_KEY | form_1099_a_copy_a_1096__tax_form_filing_method_KEY | Tax_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_KEY | form_1099_b_copy_a_1096__tax_form_filing_method_KEY | Tax_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_KEY | form_1099_div_copy_a_1096__tax_form_filing_method_KEY | Tax_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_KEY | form_1099_g_copy_a_1096__tax_form_filing_method_KEY | Tax_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_KEY | form_1099_int_copy_a_1096__tax_form_filing_method_KEY | Tax_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_KEY | form_1099_int_recipient_copy__tax_form_filing_method_KEY | Tax_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_KEY | form_1099_misc_copy_a_1096__tax_form_filing_method_KEY | Tax_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_KEY | form_1099_misc_recipient_copy__tax_form_filing_method_KEY | Tax_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_KEY | form_1099_oid_copy_a_1096__tax_form_filing_method_KEY | Tax_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_KEY | form_1099_patr_copy_a_1096__tax_form_filing_method_KEY | Tax_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_KEY | form_1099_r_copy_a_1096__tax_form_filing_method_KEY | Tax_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_KEY | form_1099_s_copy_a_1096__tax_form_filing_method_KEY | Tax_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_KEY | form_1098C_copy_a_1096__tax_form_filing_method_KEY | Tax_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_KEY | form_1099_sa_copy_a_1096__tax_form_filing_method_KEY | Tax_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_KEY | form_5498_copy_a_1096__tax_form_filing_method_KEY | Tax_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_KEY | form_5498_sa_copy_a_1096__tax_form_filing_method_KEY | Tax_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_KEY | form_w2g_copy_a_1096__tax_form_filing_method_KEY | Tax_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_KEY | w2_copy_a_w3__tax_form_filing_method_KEY | Tax_Form_Filing_Method (tax_form_filing_method_KEY) |
FK_W2_1099_User_Preference__Tax_Form_Filing_Method__w2_employee_copy__tax_form_filing_method_KEY | w2_employee_copy__tax_form_filing_method_KEY | Tax_Form_Filing_Method (tax_form_filing_method_KEY) |
FK_W2_1099_User_Preference__User_Preference__user_preference_KEY | user_preference_KEY | User_Preference (user_preference_KEY) |
FK_W2_1099_User_Preference__Vendor_1099_Sort_Type__vendor_1099_sort_type_KEY | vendor_1099_sort_type_KEY | Vendor_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_KEY | form_1099__w2_1099_ordering_worksheet_client_option_KEY | W2_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_KEY | w2__w2_1099_ordering_worksheet_client_option_KEY | W2_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_KEY | w2_copy_a_client_copy_type_KEY | W2_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_KEY | w2_employee_sort_type_KEY | W2_Employee_Sort_Type (w2_employee_sort_type_KEY) |
FK_W2_1099_User_Preference__W3_Client_Copy_Type__w3_client_copy_type_KEY | w3_client_copy_type_KEY | W3_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_KEY | form_1099_c_copy_a_1096__tax_form_filing_method_KEY | Tax_Form_Filing_Method (tax_form_filing_method_KEY) |
FK__W2_1099_U__form___5AA0D4D7 | form_1099_nec_copy_a_1096__tax_form_filing_method_KEY | Tax_Form_Filing_Method (tax_form_filing_method_KEY) |
FK__W2_1099_U__form___5B94F910 | form_1099_nec_recipient_copy__tax_form_filing_method_KEY | Tax_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_KEY | form_1098_t_copy_a_1096__tax_form_filing_method_KEY | Tax_Form_Filing_Method (tax_form_filing_method_KEY) |