View: dbo.User_Preference_View
View definition
CREATE VIEW dbo.User_Preference_View
AS
SELECT
UP.user_preference_KEY
, UP.staff_KEY
, S1.staff_id AS staff__staff_id
, S1.staff_status_KEY AS staff__staff_status_KEY
, S1.office_KEY AS staff__office_KEY
, S1.supervisor__staff_KEY AS staff__supervisor__staff_KEY
, S1.contact_KEY AS staff__contact_KEY
, UP.alternate_row_color
, UP.enter_as_tab
, UP.enter_as_save
, UP.startup_window
, UP.automatically_signout_upon_exit
, COALESCE(UP.staff_dashboard_layout, N'') AS staff_dashboard_layout
, COALESCE(UP.home_dashboard_layout, N'') AS home_dashboard_layout
, COALESCE(UP.client_dashboard_layout, N'') AS client_dashboard_layout
, COALESCE(UP.firm_dashboard_layout, N'') AS firm_dashboard_layout
, COALESCE(UP.bank_feeds_dashboard_layout, N'') AS bank_feeds_dashboard_layout
, UP.last_opened__client_KEY
, UP.time_clock_import_last_used_directory
, UP.payroll_tax_form_filing_portlet_selected_location
, UP.payroll_tax_form_filing_portlet_selected_locality
, UP.payroll_tax_form_filing_portlet_selected_form_group
, UP.display_implied_decimal_amounts
, UP.display_implied_decimal_units
, UP.excel_import_last_used_directory
, UP.excel_import_last_used_template
, UP.eftps_use_transaction_date_rather_than_due_date_as_settlement_date
, UP.quick_books_import_file_location
, UP.disable_connect_alert_and_update_notifications
, UP.general_import_file_location
, COALESCE(UP.engagement_dashboard_layout, N'') AS engagement_dashboard_layout
, UP.workpapers_pdf_editor_settings_xml
, UP.quick_books_export_file_location
, UP.workpapers_preview_settings_xml
, UP.manage_impound_use_next_due_date_as_payment_date
, UP.processing_note_sort_order_KEY
, UP.payroll_tax_form_reporting_agent_authorization_supress_form_8655
, UP.payroll_tax_form_reporting_agent_authorization_supress_signature_date
, UP.engagement_fieldwork_last_used_location
, UP.engagement_fieldwork_return_last_used_location
, UP.client_access_notification_portlet_grid_settings_xml
, UP.enter_handwritten_payroll_check_include_inactive_employee
, UP.view_account_activity_date_filter_value_type_KEY
, UP.view_account_activity_balance_type_KEY
, UP.view_account_activity_journal_filter_value_type_KEY
, UP.view_account_activity_begin_date
, UP.view_account_activity_end_date
, UP.view_account_activity_journal_description
FROM
dbo.User_Preference AS UP
LEFT OUTER JOIN
dbo.Staff AS S1 ON S1.staff_KEY = UP.staff_KEY;