Table: dbo.Report_User_Preference
Columns
NameTypeConstraintsDescription
user_preference_KEYint (4)NOT NULLPrimary key and foreign key to user preference table
save_report_optionsbit (1)NOT NULLWhen 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_idbit (1)NOT NULLWhen set to true, the Client ID will be printed in the header on all reports.
print_detailed_report_optionsbit (1)NOT NULLA true value will print the selected report options in the header on all reports.
print_staff_idbit (1)NOT NULLWhen set to true, the Staff ID will be printed in the footer in all reports
print_system_date_timebit (1)NOT NULLThe current date and time will be printed in the footer on all reports when set to true.
print_page_numberbit (1)NOT NULLThe page number will be printed in the footer on all reports when set to true.
center_page_numberbit (1)NOT NULLWhen set to true, page numbers will be printed in the center position instead of right justified in the footer.
collate_checks_by_clientbit (1)NOT NULLUser setting to collate checks by client; defaults to true
collate_reports_by_clientbit (1)NOT NULLUser setting to collate reports by client; defaults to true
date_formatnvarchar (40)NOT NULLUser-specified date fomat.
time_formatnvarchar (40)NOT NULLUser-specified time fomat.
customize_client_idnvarchar (500)NOT NULLUser-customized client id to control the actual text and format of the output.
customize_staff_idnvarchar (500)NOT NULLUser-customized staff id to control the actual text and format of the output.
customize_system_date_timenvarchar (500)NOT NULLUser-customized system date and time to control the actual text and format of the output.
customize_page_numbernvarchar (500)NOT NULLUser-customized page number to control the actual text and format of the output.
customize_detailed_optionsnvarchar (500)NOT NULLUser-customized detailed options to control the actual text and format printed in the header of all reports.
print_checks_use_due_date_as_payment_datebit (1)NOT NULLUser 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_documentsbit (1)NOT NULLUser setting to output report profiles to file, email, and FileCabinet CS as individual documents; defaults to false.
separate_processed_electronic_forms_reports_by_clientbit (1)NOT NULLIndicates if processed electronic forms reports should separated by client when print previewing
separate_managed_electronic_forms_reports_by_clientbit (1)NOT NULLIndicates if managed electronic forms reports should separated by client when print previewing
print_invoices_use_fee_date_as_invoice_datebit (1)NOT NULLUser setting to use a fee date as the invoice date for fee and billing invoices.
print_invoices_separate_invoices_per_originating_clientbit (1)NOT NULLUser setting to separate invoices per originating client for fee and billing invoices.
separate_processed_internet_magnetic_media_reports_by_clientbit (1)NOT NULLIndicates if processed internet magnetic media file reports should separated by client when print previewing
separate_managed_internet_magnetic_media_reports_by_clientbit (1)NOT NULLIndicates if managed internet magnetic media file reports should separated by client when print previewing
suppress_form_8879_preview_signature_datebit (1)NOT NULLTrue 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_sheetbit (1)NOT NULLUser 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_mergingbit (1)NOT NULL1 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_wrappingbit (1)NOT NULLDetermines whether report text that is too large to fit in its column will be wrapped or clipped.
Primary key
NameColumnsDescription
PK_Report_User_Preference$user_preference_KEYuser_preference_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Report_User_Preference__User_Preference__user_preference_KEYuser_preference_KEYUser_Preference (user_preference_KEY)

Schema diagram