Table: dbo.Report_User_Preference
Columns
Name | Type | Constraints | Description
user_preference_KEY | int (4) | NOT NULL | Primary key and foreign key to user preference table
save_report_options | bit (1) | NOT NULL | When set to true, any changes made to the options of a report are automatically saved to the database when the user exists the options dialog.
print_client_id | bit (1) | NOT NULL | When set to true, the Client ID will be printed in the header on all reports.
print_detailed_report_options | bit (1) | NOT NULL | A true value will print the selected report options in the header on all reports.
print_staff_id | bit (1) | NOT NULL | When set to true, the Staff ID will be printed in the footer in all reports
print_system_date_time | bit (1) | NOT NULL | The current date and time will be printed in the footer on all reports when set to true.
print_page_number | bit (1) | NOT NULL | The page number will be printed in the footer on all reports when set to true.
center_page_number | bit (1) | NOT NULL | When set to true, page numbers will be printed in the center position instead of right justified in the footer.
collate_checks_by_client | bit (1) | NOT NULL | User setting to collate checks by client; defaults to true
collate_reports_by_client | bit (1) | NOT NULL | User setting to collate reports by client; defaults to true
date_format | nvarchar (40) | NOT NULL | User-specified date fomat.
time_format | nvarchar (40) | NOT NULL | User-specified time fomat.
customize_client_id | nvarchar (500) | NOT NULL | User-customized client id to control the actual text and format of the output.
customize_staff_id | nvarchar (500) | NOT NULL | User-customized staff id to control the actual text and format of the output.
customize_system_date_time | nvarchar (500) | NOT NULL | User-customized system date and time to control the actual text and format of the output.
customize_page_number | nvarchar (500) | NOT NULL | User-customized page number to control the actual text and format of the output.
customize_detailed_options | nvarchar (500) | NOT NULL | User-customized detailed options to control the actual text and format printed in the header of all reports.
print_checks_use_due_date_as_payment_date | bit (1) | NOT NULL | User setting to use due date as payment date in Print Checks when creating and printing payments for liabilities; defaults to false
output_report_profiles_as_individual_documents | bit (1) | NOT NULL | User setting to output report profiles to file, email, and FileCabinet CS as individual documents; defaults to false.
separate_processed_electronic_forms_reports_by_client | bit (1) | NOT NULL | Indicates if processed electronic forms reports should separated by client when print previewing
separate_managed_electronic_forms_reports_by_client | bit (1) | NOT NULL | Indicates if managed electronic forms reports should separated by client when print previewing
print_invoices_use_fee_date_as_invoice_date | bit (1) | NOT NULL | User setting to use a fee date as the invoice date for fee and billing invoices.
print_invoices_separate_invoices_per_originating_client | bit (1) | NOT NULL | User setting to separate invoices per originating client for fee and billing invoices.
separate_processed_internet_magnetic_media_reports_by_client | bit (1) | NOT NULL | Indicates if processed internet magnetic media file reports should separated by client when print previewing
separate_managed_internet_magnetic_media_reports_by_client | bit (1) | NOT NULL | Indicates if managed internet magnetic media file reports should separated by client when print previewing
suppress_form_8879_preview_signature_date | bit (1) | NOT NULL | True if the user has selected to suppress signature date when previewing form 8879-EMP from the Process Electronic Forms screen or the Manage Electronic Files dialog.
print_duplex_with_blank_sheet | bit (1) | NOT NULL | User setting to output blank sheets to the last page of odd-page-numbered reports when printing duplex, defaults to false.
output_to_excel_with_cell_merging | bit (1) | NOT NULL | 1 means the report will be output to excel with cell merging turned on; 0 the report will be output to excel without cell merging turned on.
output_with_text_wrapping | bit (1) | NOT NULL | Determines whether report text that is too large to fit in its column will be wrapped or clipped.

Primary key
Name | Columns | Description
PK_Report_User_Preference$user_preference_KEY | user_preference_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Report_User_Preference__User_Preference__user_preference_KEY | user_preference_KEY | User_Preference (user_preference_KEY) |