View: dbo.User_Preference_View | |||
View definition | |||
create view dbo.User_Preference_View as select user_preference_KEY = UP.user_preference_KEY , staff_KEY = UP.staff_KEY , staff__staff_id = S1.staff_id , staff__staff_status_KEY = S1.staff_status_KEY , staff__office_KEY = S1.office_KEY , staff__supervisor__staff_KEY = S1.supervisor__staff_KEY , staff__contact_KEY = S1.contact_KEY , alternate_row_color = UP.alternate_row_color , enter_as_tab = UP.enter_as_tab , enter_as_save = UP.enter_as_save , startup_window = UP.startup_window , staff_dashboard_layout = coalesce(UP.staff_dashboard_layout, N'') , home_dashboard_layout = coalesce(UP.home_dashboard_layout, N'') , client_dashboard_layout = coalesce(UP.client_dashboard_layout, N'') , firm_dashboard_layout = coalesce(UP.firm_dashboard_layout, N'') , bank_feeds_dashboard_layout = coalesce(UP.bank_feeds_dashboard_layout, N'') , last_opened__client_KEY = UP.last_opened__client_KEY , time_clock_import_last_used_directory = UP.time_clock_import_last_used_directory , payroll_tax_form_filing_portlet_selected_location = UP.payroll_tax_form_filing_portlet_selected_location , payroll_tax_form_filing_portlet_selected_locality = UP.payroll_tax_form_filing_portlet_selected_locality , payroll_tax_form_filing_portlet_selected_form_group = UP.payroll_tax_form_filing_portlet_selected_form_group , display_implied_decimal_amounts = UP.display_implied_decimal_amounts , display_implied_decimal_units = UP.display_implied_decimal_units , excel_import_last_used_directory = UP.excel_import_last_used_directory , excel_import_last_used_template = UP.excel_import_last_used_template , eftps_use_transaction_date_rather_than_due_date_as_settlement_date = UP.eftps_use_transaction_date_rather_than_due_date_as_settlement_date , quick_books_import_file_location = UP.quick_books_import_file_location , disable_connect_alert_and_update_notifications = UP.disable_connect_alert_and_update_notifications , general_import_file_location = UP.general_import_file_location , engagement_dashboard_layout = coalesce(UP.engagement_dashboard_layout, N'') , workpapers_pdf_editor_settings_xml = UP.workpapers_pdf_editor_settings_xml , quick_books_export_file_location = UP.quick_books_export_file_location , workpapers_preview_settings_xml = UP.workpapers_preview_settings_xml , manage_impound_use_next_due_date_as_payment_date = UP.manage_impound_use_next_due_date_as_payment_date , processing_note_sort_order_KEY = UP.processing_note_sort_order_KEY , payroll_tax_form_reporting_agent_authorization_supress_form_8655 = UP.payroll_tax_form_reporting_agent_authorization_supress_form_8655 , payroll_tax_form_reporting_agent_authorization_supress_signature_date = UP.payroll_tax_form_reporting_agent_authorization_supress_signature_date , engagement_fieldwork_last_used_location = UP.engagement_fieldwork_last_used_location , engagement_fieldwork_return_last_used_location = UP.engagement_fieldwork_return_last_used_location , client_access_notification_portlet_grid_settings_xml = UP.client_access_notification_portlet_grid_settings_xml , enter_handwritten_payroll_check_include_inactive_employee = 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 UP left outer join dbo.Staff S1 on S1.staff_KEY = UP.staff_KEY | |||