Table: dbo.User_Preference
Columns
NameTypeConstraintsDescription
user_preference_KEYint (4)NOT NULLDatabase assigned primary key for this table.
staff_KEYint (4)Key of one of the Staff records; NULL if firm default record.
alternate_row_colorbit (1)NOT NULLPresents all lists and grids with alternating row colors when true
enter_as_tabbit (1)NOT NULLEnter key functions as Tab
startup_windownvarchar (200)NOT NULLScreen to open at startup
staff_dashboard_layoutnvarchar (-1)Layout of the Staff Dashboard stored as XML
client_dashboard_layoutnvarchar (-1)Layout of the Client Dashboard stored as XML
firm_dashboard_layoutnvarchar (-1)Layout of the Firm Dashboard stored as XML
home_dashboard_layoutnvarchar (-1)Layout of the Home Dashboard stored as XML
last_opened__client_KEYint (4)Holds the primary key value of the last client opened before application was exited.
time_clock_import_last_used_directorynvarchar (520)NOT NULL
display_implied_decimal_amountsbit (1)NOT NULLadd decimal to amount values
display_implied_decimal_unitsbit (1)NOT NULLadd decimal to other units such as hours, pieces, etc.
excel_import_last_used_directorynvarchar (520)NOT NULLLast used directory for the excel file in the Import Wizard
excel_import_last_used_templatenvarchar (120)NOT NULLLast used template name for the excel file in the Import Wizard
eftps_use_transaction_date_rather_than_due_date_as_settlement_datebit (1)NOT NULLProcess EFPTS payment tab option to either set the settlement date to be the transaction date or due date
quick_books_import_file_locationnvarchar (520)NOT NULLthe file location for the quickbooks file used in the Import Client Data Wizard
payroll_tax_form_filing_portlet_selected_locationnvarchar (60)NOT NULLThe current location used to filter out the forms for the payroll tax form filing information portlet.
payroll_tax_form_filing_portlet_selected_localitynvarchar (60)NOT NULLThe 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_groupnvarchar (60)NOT NULLThe type of form that has been selected to display in the payroll tax form filing information portlet.
disable_connect_alert_and_update_notificationsbit (1)NOT NULLShould we display CS Connect alert notices or not.
general_import_file_locationnvarchar (520)NOT NULL
engagement_dashboard_layoutnvarchar (-1)Contains XML data for window positions.
workpapers_pdf_editor_settings_xmlnvarchar (-1)Contains the user settings for the pdf editor used within Workpapers CS.
quick_books_export_file_locationnvarchar (520)NOT NULLThe quick books export file location used in the Export Client Data Wizard.
workpapers_preview_settings_xmlnvarchar (-1)NOT NULLContains the user settings for the pdf editor used to preview Workpapers.
manage_impound_use_next_due_date_as_payment_datebit (1)NOT NULLTrue if the user has selected to use next due date as the payment date in the manage impound system.
processing_note_sort_order_KEYint (4)NOT NULLThe 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_8655bit (1)NOT NULLTrue if the user has selected to supress form 8655 on the reporting agent list screen.
payroll_tax_form_reporting_agent_authorization_supress_signature_datebit (1)NOT NULLTrue if the user has selected to supress signature date on the reporting agent list screen.
engagement_fieldwork_last_used_locationnvarchar (512)NOT NULLUsed 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_locationnvarchar (512)NOT NULLThe 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_xmlnvarchar (-1)NOT NULLContains the user settings for the client access notification portlet grid columns.
enter_handwritten_payroll_check_include_inactive_employeebit (1)NOT NULLUsed to remember the user setting for including inactive employees on the enter handwritten payroll check screen.
view_account_activity_date_filter_value_type_KEYint (4)NOT NULLThe selected value in View Account Activity for Date.
view_account_activity_balance_type_KEYint (4)NOT NULLThe selected value in View Account Activity for Basis/Balance.
view_account_activity_journal_filter_value_type_KEYint (4)NOT NULLThe selected value in View Account Activity for Journal.
view_account_activity_begin_datedatetime (8, 3)The beginning date in View Account Activity for Date selection. Only filled for Single/Range values of DateFilterValueType.
view_account_activity_end_datedatetime (8, 3)The ending date in View Account Activity for Date selection. Only filled for Range values of DateFilterValueType.
view_account_activity_journal_descriptionnvarchar (60)NOT NULLThe 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_savebit (1)NOT NULLColumn 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_layoutnvarchar (-1)Contains XML data for views and portlets of the Bank Feeds Dashboard.
Primary key
NameColumnsDescription
PK_User_Preferenceuser_preference_KEY
Unique constraints
NameColumnsDescription
UK_User_Preference$staff_KEYstaff_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_User_Preference__Date_Filter_Value_Type__view_account_activity_date_filter_value_type_KEYview_account_activity_date_filter_value_type_KEYDate_Filter_Value_Type (date_filter_value_type_KEY)
FK_User_Preference__Balance_Type__view_account_activity_balance_type_KEYview_account_activity_balance_type_KEYBalance_Type (balance_type_KEY)
FK_User_Preference__Journal_Filter_Value_Type__view_account_activity_journal_filter_value_type_KEYview_account_activity_journal_filter_value_type_KEYJournal_Filter_Value_Type (journal_filter_value_type_KEY)
FK_User_Preference__Processing_Note_Sort_Order__processing_note_sort_order_KEYprocessing_note_sort_order_KEYProcessing_Note_Sort_Order (processing_note_sort_order_KEY)
FK_User_Preference__Staff__staff_KEYstaff_KEYStaff (staff_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Engagement_Workspace_Tab__User_Preference__user_preference_KEYuser_preference_KEYEngagement_Workspace_Tab
FK_Report_User_Preference__User_Preference__user_preference_KEYuser_preference_KEYReport_User_Preference
FK_User_Preference_Grid_Column_Screen_Option__User_Preference__user_preference_KEYuser_preference_KEYUser_Preference_Grid_Column_Screen_Option
FK_AP_Enter_Transaction_Option__User_Preference__user_preference_KEYuser_preference_KEYAP_Enter_Transaction_Option
FK_User_Screen_Option__User_Preference__user_preference_KEYuser_preference_KEYUser_Screen_Option
FK_User_Client_Preference_Grid_Column_Screen_Option__User_Preference__user_preference_KEYuser_preference_KEYUser_Client_Preference_Grid_Column_Screen_Option
FK_Form_1095_User_Preference__user_preference_KEYuser_preference_KEYForm_1095_User_Preference
FK_Printer_User_Preference__User_Preference__user_preference_KEYuser_preference_KEYPrinter_User_Preference
FK_W2_1099_User_Preference__User_Preference__user_preference_KEYuser_preference_KEYW2_1099_User_Preference
FK_Printer_User_Preference_By_Subtype__User_Preference__user_preference_KEYuser_preference_KEYPrinter_User_Preference_By_Subtype
FK_Print_Destination_User_Preference__User_Preference__user_preference_KEYuser_preference_KEYPrint_Destination_User_Preference
FK_Manage_AP_Payment_User_Preference__User_Preference__user_preference_KEYuser_preference_KEYManage_AP_Payment_User_Preference
FK_Manage_AP_Payment_Grid_User_Option__User_Preference__user_preference_KEYuser_preference_KEYManage_AP_Payment_Grid_User_Option
FK_Import_User_Preference__User_Preference__user_preference_KEYuser_preference_KEYImport_User_Preference
FK_Copy_From_VO_Destination_Path__User_Preference__user_preference_KEYuser_preference_KEYCopy_From_VO_Destination_Path
FK_AP_Enter_Transaction_List_View_Column_Option__User_Preference__user_preference_KEYuser_preference_KEYAP_Enter_Transaction_List_View_Column_Option
FK_Enter_Transaction_User_Preference__User_Preference__user_preference_KEYuser_preference_KEYEnter_Transaction_User_Preference

Schema diagram