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