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. |
Primary key | |||
Name | Columns | Description | |
PK_User_Preference | user_preference_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_User_Preference$staff_KEY | staff_KEY |