Table: dbo.User_Preference
Columns
Name | Type | Constraints | Description
user_preference_KEY | int (4) | NOT NULL | Database assigned primary key for this table.
staff_KEY | int (4) |  | Key of one of the Staff records; NULL if firm default record.
alternate_row_color | bit (1) | NOT NULL | Presents all lists and grids with alternating row colors when true
enter_as_tab | bit (1) | NOT NULL | Enter key functions as Tab
startup_window | nvarchar (200) | NOT NULL | Screen to open at startup
staff_dashboard_layout | nvarchar (-1) |  | Layout of the Staff Dashboard stored as XML
client_dashboard_layout | nvarchar (-1) |  | Layout of the Client Dashboard stored as XML
firm_dashboard_layout | nvarchar (-1) |  | Layout of the Firm Dashboard stored as XML
home_dashboard_layout | nvarchar (-1) |  | Layout of the Home Dashboard stored as XML
last_opened__client_KEY | int (4) |  | Holds the primary key value of the last client opened before application was exited.
time_clock_import_last_used_directory | nvarchar (520) | NOT NULL |
display_implied_decimal_amounts | bit (1) | NOT NULL | add decimal to amount values
display_implied_decimal_units | bit (1) | NOT NULL | add decimal to other units such as hours, pieces, etc.
excel_import_last_used_directory | nvarchar (520) | NOT NULL | Last used directory for the excel file in the Import Wizard
excel_import_last_used_template | nvarchar (120) | NOT NULL | Last used template name for the excel file in the Import Wizard
eftps_use_transaction_date_rather_than_due_date_as_settlement_date | bit (1) | NOT NULL | Process EFPTS payment tab option to either set the settlement date to be the transaction date or due date
quick_books_import_file_location | nvarchar (520) | NOT NULL | the file location for the quickbooks file used in the Import Client Data Wizard
payroll_tax_form_filing_portlet_selected_location | nvarchar (60) | NOT NULL | The current location used to filter out the forms for the payroll tax form filing information portlet.
payroll_tax_form_filing_portlet_selected_locality | nvarchar (60) | NOT NULL | The locality selected for a specific state used to filter out the forms for the payroll tax form filing information portlet.
payroll_tax_form_filing_portlet_selected_form_group | nvarchar (60) | NOT NULL | The type of form that has been selected to display in the payroll tax form filing information portlet.
disable_connect_alert_and_update_notifications | bit (1) | NOT NULL | Should we display CS Connect alert notices or not.
general_import_file_location | nvarchar (520) | NOT NULL |
engagement_dashboard_layout | nvarchar (-1) |  | Contains XML data for window positions.
workpapers_pdf_editor_settings_xml | nvarchar (-1) |  | Contains the user settings for the pdf editor used within Workpapers CS.
quick_books_export_file_location | nvarchar (520) | NOT NULL | The quick books export file location used in the Export Client Data Wizard.
workpapers_preview_settings_xml | nvarchar (-1) | NOT NULL | Contains the user settings for the pdf editor used to preview Workpapers.
manage_impound_use_next_due_date_as_payment_date | bit (1) | NOT NULL | True if the user has selected to use next due date as the payment date in the manage impound system.
processing_note_sort_order_KEY | int (4) | NOT NULL | The sort order this user has selected to be used in the Client Processing Notes and Process Payroll Tax Forms Notes dialogs.
payroll_tax_form_reporting_agent_authorization_supress_form_8655 | bit (1) | NOT NULL | True if the user has selected to supress form 8655 on the reporting agent list screen.
payroll_tax_form_reporting_agent_authorization_supress_signature_date | bit (1) | NOT NULL | True if the user has selected to supress signature date on the reporting agent list screen.
engagement_fieldwork_last_used_location | nvarchar (512) | NOT NULL | Used to store the last used file location used in Send For Fieldwork feature. This will be the default location the next time the user decides to Send For Fieldwork.
engagement_fieldwork_return_last_used_location | nvarchar (512) | NOT NULL | The last used file location in the Return from fieldwork wizard. Will be used as the default the next time the wizard is opened.
client_access_notification_portlet_grid_settings_xml | nvarchar (-1) | NOT NULL | Contains the user settings for the client access notification portlet grid columns.
enter_handwritten_payroll_check_include_inactive_employee | bit (1) | NOT NULL | Used to remember the user setting for including inactive employees on the enter handwritten payroll check screen.
view_account_activity_date_filter_value_type_KEY | int (4) | NOT NULL | The selected value in View Account Activity for Date.
view_account_activity_balance_type_KEY | int (4) | NOT NULL | The selected value in View Account Activity for Basis/Balance.
view_account_activity_journal_filter_value_type_KEY | int (4) | NOT NULL | The selected value in View Account Activity for Journal.
view_account_activity_begin_date | datetime (8, 3) |  | The beginning date in View Account Activity for Date selection. Only filled for Single/Range values of DateFilterValueType.
view_account_activity_end_date | datetime (8, 3) |  | The ending date in View Account Activity for Date selection. Only filled for Range values of DateFilterValueType.
view_account_activity_journal_description | nvarchar (60) | NOT NULL | The selected value in View Account Activity for the Journal. This is cross-client, and if a client doesnt have it, then the ALL selection is defaulted to.
enter_as_save | bit (1) | NOT NULL | Column that determines if Enter key can be used to save a transaction. ["BR"] This is a sub-option of enter_as_tab option and will have an effect only if enter_as_tab is enabled
bank_feeds_dashboard_layout | nvarchar (-1) |  | Contains XML data for views and portlets of the Bank Feeds Dashboard.
automatically_signout_upon_exit | bit (1) | NOT NULL | If 1, the user will be automatically signed out from their Thomson Reuters Account upon exiting the application. When 0 no such sign out occurs.
workpaper_roll_forward_treatment_KEY | int (4) | NOT NULL | Foreign key to Workpaper_Roll_Forward_Treatment table to indicate the user preference for workpaper roll forward treatment.

Primary key
Name | Columns | Description
PK_User_Preference | user_preference_KEY |
Unique constraints
Name | Columns | Description
UK_User_Preference$staff_KEY | staff_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_User_Preference__Date_Filter_Value_Type__view_account_activity_date_filter_value_type_KEY | view_account_activity_date_filter_value_type_KEY | Date_Filter_Value_Type (date_filter_value_type_KEY) |
FK_User_Preference__Balance_Type__view_account_activity_balance_type_KEY | view_account_activity_balance_type_KEY | Balance_Type (balance_type_KEY) |
FK_User_Preference__Journal_Filter_Value_Type__view_account_activity_journal_filter_value_type_KEY | view_account_activity_journal_filter_value_type_KEY | Journal_Filter_Value_Type (journal_filter_value_type_KEY) |
FK_User_Preference__workpaper_roll_forward_treatment_KEY__Workpaper_Roll_Forward_Treatment | workpaper_roll_forward_treatment_KEY | Workpaper_Roll_Forward_Treatment (workpaper_roll_forward_treatment_KEY) |
FK_User_Preference__Processing_Note_Sort_Order__processing_note_sort_order_KEY | processing_note_sort_order_KEY | Processing_Note_Sort_Order (processing_note_sort_order_KEY) |
FK_User_Preference__Staff__staff_KEY | staff_KEY | Staff (staff_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Engagement_Workspace_Tab__User_Preference__user_preference_KEY | user_preference_KEY | Engagement_Workspace_Tab |
FK_Report_User_Preference__User_Preference__user_preference_KEY | user_preference_KEY | Report_User_Preference |
FK_User_Preference_Grid_Column_Screen_Option__User_Preference__user_preference_KEY | user_preference_KEY | User_Preference_Grid_Column_Screen_Option |
FK_AP_Enter_Transaction_Option__User_Preference__user_preference_KEY | user_preference_KEY | AP_Enter_Transaction_Option |
FK_User_Screen_Option__User_Preference__user_preference_KEY | user_preference_KEY | User_Screen_Option |
FK_User_Client_Preference_Grid_Column_Screen_Option__User_Preference__user_preference_KEY | user_preference_KEY | User_Client_Preference_Grid_Column_Screen_Option |
FK_Printer_User_Preference_By_Subtype__User_Preference__user_preference_KEY | user_preference_KEY | Printer_User_Preference_By_Subtype |
FK_Form_1095_User_Preference__user_preference_KEY | user_preference_KEY | Form_1095_User_Preference |
FK_Printer_User_Preference__User_Preference__user_preference_KEY | user_preference_KEY | Printer_User_Preference |
FK_W2_1099_User_Preference__User_Preference__user_preference_KEY | user_preference_KEY | W2_1099_User_Preference |
FK_Print_Destination_User_Preference__User_Preference__user_preference_KEY | user_preference_KEY | Print_Destination_User_Preference |
FK_Manage_AP_Payment_User_Preference__User_Preference__user_preference_KEY | user_preference_KEY | Manage_AP_Payment_User_Preference |
FK_Manage_AP_Payment_Grid_User_Option__User_Preference__user_preference_KEY | user_preference_KEY | Manage_AP_Payment_Grid_User_Option |
FK_Import_User_Preference__User_Preference__user_preference_KEY | user_preference_KEY | Import_User_Preference |
FK_Copy_From_VO_Destination_Path__User_Preference__user_preference_KEY | user_preference_KEY | Copy_From_VO_Destination_Path |
FK_AP_Enter_Transaction_List_View_Column_Option__User_Preference__user_preference_KEY | user_preference_KEY | AP_Enter_Transaction_List_View_Column_Option |
FK_Enter_Transaction_User_Preference__User_Preference__user_preference_KEY | user_preference_KEY | Enter_Transaction_User_Preference |