Table: dbo.Print_Destination_User_Preference
Store user preferences for print destinations and use them to populate various Print Options views.
Columns
NameTypeConstraintsDescription
print_destination_user_preference_KEYint (4)NOT NULLPrimary key for this table
user_preference_KEYint (4)NOT NULLForeign key to table User_Preference
print_job_type_KEYint (4)NOT NULLForeign key to table Print_Job_Type
printer__is_selectedbit (1)NOT NULLIs a printer selected for output?
printer__use_duplexbit (1)NOT NULLFor printer output, use duplex?
file_cabinet__is_selectedbit (1)NOT NULLIs File Cabinet selected for output?
file_cabinet__data_pathnvarchar (520)NOT NULLFor File Cabinet output, what is the data path?
file_cabinet__send_to_netclient_document_presentationbit (1)NOT NULLFor File Cabinet output, send to NetClient CS Document Presentation?
engagement__is_selectedbit (1)NOT NULLIs Engagement CS selected for output?
file__is_selectedbit (1)NOT NULLIs file selected for output?
file__file_extensionnvarchar (8)NOT NULLFor file output, what is the file extension?
file__open_file_when_completebit (1)NOT NULLFor file output, open the file when complete?
file__data_pathnvarchar (520)NOT NULLFor file output, what is the data path?
printer__is_tax_form_filing_copy_selectedbit (1)NOT NULLTrue if the user wants to print the filing copy of the tax form to printer.
printer__is_tax_form_client_copy_selectedbit (1)NOT NULLTrue if the user wants to print the client copy of the tax form to printer.
file_cabinet__is_tax_form_filing_copy_selectedbit (1)NOT NULLTrue if the user wants to print the filing copy of the tax form to file cabinet.
file_cabinet__is_tax_form_client_copy_selectedbit (1)NOT NULLTrue if the user wants to print the client copy of the tax form to file cabinet.
file__is_tax_form_filing_copy_selectedbit (1)NOT NULLTrue if the user wants to print the filing copy of the tax form to file.
file__is_tax_form_client_copy_selectedbit (1)NOT NULLTrue if the user wants to print the client copy of the tax form to file.
engagement__is_tax_form_filing_copy_selectedbit (1)NOT NULLTrue if the user wants to print the filing copy of the tax form to engagement.
engagement__is_tax_form_client_copy_selectedbit (1)NOT NULLTrue if the user wants to print the client copy of the tax form to engagement.
continue_page_numbering_across_reportsbit (1)NOT NULLDoes the user want the page number restarted for each multi-page report in a report print run?
starting_page_numberint (4)NOT NULLSpecified beginning page count number.
engagement_binder_include_pdf_annotationsbit (1)NOT NULLflag that indicates whether to include pdf annotations when printing engagement binder
engagement_binder_hide_empty_foldersbit (1)NOT NULLflag that indicates whether to hide empty folders when printing engagement binder
engagement_binder_hide_referencesbit (1)NOT NULLflag that indicates whether to hide references when printing engagement binder
engagement_binder_output_foldernvarchar (512)NOT NULLfolder to output document in when printing engagement binder
engagement_binder_protect_against_modificationbit (1)NOT NULLflag that indicates whether or not to protect against modification when printing engagement binder
engagement_binder_output_to_pdfbit (1)NOT NULLflag that indicates whether to output to pdf when printing engagement binder
engagement_binder_open_after_exportbit (1)NOT NULLflag that indicates whether to open after export when printing engagement binder
engagement_binder_output_to_file_cabinetbit (1)NOT NULLflag that indicates whether to output to file cabinet when printing engagement binder
engagement_binder_send_to_portalbit (1)NOT NULLflag that indicates whether to send to portal when printing engagement binder
engagement_binder_file_cabinet_data_pathnvarchar (512)NOT NULLpath to file cabinet when printing engagement binder
engagement_binder_output_to_filebit (1)NOT NULLflag that indicates whether to output to file when printing engagement binder
gfr__is_selectedbit (1)NOT NULLRepresents if the we are printing a document to GoFileRoom
gfr__file_extensionnvarchar (16)NOT NULLSelected file extension for GoFileRoom output. This only applies if gfr__is_selected is true.
gfr__is_tax_form_filing_copy_selectedbit (1)NOT NULLTrue if the user wants to print the filing copy of the tax form to file (for GoFileRoom).
gfr__is_tax_form_client_copy_selectedbit (1)NOT NULLTrue if the user wants to print the client copy of the tax form to file (for GoFileRoom).
engagement_binder_output_to_gfrbit (1)NOT NULLFlag that indicates whether to output to GoFileRoom when printing engagement binder.
onvio_documents__is_selectedbit (1)NOT NULLRepresents if we are printing a document to Onvio Documents
onvio_documents__file_extensionnvarchar (8)NOT NULLSelected file extension for Onvio Documents output. This only applies if onvio_documents__is_selected is true.
onvio_documents__is_tax_form_filing_copy_selectedbit (1)NOT NULLTrue if the user wants to print the filing copy of the tax form to file (for Onvio Documents).
onvio_documents__is_tax_form_client_copy_selectedbit (1)NOT NULLTrue if the user wants to print the client copy of the tax form to file (for Onvio Documents).
engagement_binder_output_to_onvio_documentsbit (1)NOT NULLFlag that indicates whether to output to Onvio Documents when printing engagement binder.
for_complete_payroll_or_forms_outputbit (1)NOT NULLIf true, then this record is for use during Complete Payroll Output (in Print Checks) or Complete Forms Output.
Primary key
NameColumnsDescription
PK_Print_Destination_User_Preferenceprint_destination_user_preference_KEY
Unique constraints
NameColumnsDescription
UK_Print_Destination_User_Preference$user_preference_KEY$print_job_type_KEY$for_complete_payroll_or_forms_outputuser_preference_KEY, print_job_type_KEY, for_complete_payroll_or_forms_output
Foreign keys
NameColumnsReferenced tableDescription
FK_Print_Destination_User_Preference__Print_Job_Type__print_job_type_KEYprint_job_type_KEYPrint_Job_Type (print_job_type_KEY)
FK_Print_Destination_User_Preference__User_Preference__user_preference_KEYuser_preference_KEYUser_Preference (user_preference_KEY)

Schema diagram