| 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; | |||