Table: dbo.Print_Destination_User_Preference
Store user preferences for print destinations and use them to populate various Print Options views.
Columns
Name | Type | Constraints | Description
print_destination_user_preference_KEY | int (4) | NOT NULL | Primary key for this table
user_preference_KEY | int (4) | NOT NULL | Foreign key to table User_Preference
print_job_type_KEY | int (4) | NOT NULL | Foreign key to table Print_Job_Type
printer__is_selected | bit (1) | NOT NULL | Is a printer selected for output?
printer__use_duplex | bit (1) | NOT NULL | For printer output, use duplex?
file_cabinet__is_selected | bit (1) | NOT NULL | Is File Cabinet selected for output?
file_cabinet__data_path | nvarchar (520) | NOT NULL | For File Cabinet output, what is the data path?
file_cabinet__send_to_netclient_document_presentation | bit (1) | NOT NULL | For File Cabinet output, send to NetClient CS Document Presentation?
engagement__is_selected | bit (1) | NOT NULL | Is Engagement CS selected for output?
file__is_selected | bit (1) | NOT NULL | Is file selected for output?
file__file_extension | nvarchar (8) | NOT NULL | For file output, what is the file extension?
file__open_file_when_complete | bit (1) | NOT NULL | For file output, open the file when complete?
file__data_path | nvarchar (520) | NOT NULL | For file output, what is the data path?
printer__is_tax_form_filing_copy_selected | bit (1) | NOT NULL | True if the user wants to print the filing copy of the tax form to printer.
printer__is_tax_form_client_copy_selected | bit (1) | NOT NULL | True if the user wants to print the client copy of the tax form to printer.
file_cabinet__is_tax_form_filing_copy_selected | bit (1) | NOT NULL | True if the user wants to print the filing copy of the tax form to file cabinet.
file_cabinet__is_tax_form_client_copy_selected | bit (1) | NOT NULL | True if the user wants to print the client copy of the tax form to file cabinet.
file__is_tax_form_filing_copy_selected | bit (1) | NOT NULL | True if the user wants to print the filing copy of the tax form to file.
file__is_tax_form_client_copy_selected | bit (1) | NOT NULL | True if the user wants to print the client copy of the tax form to file.
engagement__is_tax_form_filing_copy_selected | bit (1) | NOT NULL | True if the user wants to print the filing copy of the tax form to engagement.
engagement__is_tax_form_client_copy_selected | bit (1) | NOT NULL | True if the user wants to print the client copy of the tax form to engagement.
continue_page_numbering_across_reports | bit (1) | NOT NULL | Does the user want the page number restarted for each multi-page report in a report print run?
starting_page_number | int (4) | NOT NULL | Specified beginning page count number.
engagement_binder_include_pdf_annotations | bit (1) | NOT NULL | flag that indicates whether to include pdf annotations when printing engagement binder
engagement_binder_hide_empty_folders | bit (1) | NOT NULL | flag that indicates whether to hide empty folders when printing engagement binder
engagement_binder_hide_references | bit (1) | NOT NULL | flag that indicates whether to hide references when printing engagement binder
engagement_binder_output_folder | nvarchar (512) | NOT NULL | folder to output document in when printing engagement binder
engagement_binder_protect_against_modification | bit (1) | NOT NULL | flag that indicates whether or not to protect against modification when printing engagement binder
engagement_binder_output_to_pdf | bit (1) | NOT NULL | flag that indicates whether to output to pdf when printing engagement binder
engagement_binder_open_after_export | bit (1) | NOT NULL | flag that indicates whether to open after export when printing engagement binder
engagement_binder_output_to_file_cabinet | bit (1) | NOT NULL | flag that indicates whether to output to file cabinet when printing engagement binder
engagement_binder_send_to_portal | bit (1) | NOT NULL | flag that indicates whether to send to portal when printing engagement binder
engagement_binder_file_cabinet_data_path | nvarchar (512) | NOT NULL | path to file cabinet when printing engagement binder
engagement_binder_output_to_file | bit (1) | NOT NULL | flag that indicates whether to output to file when printing engagement binder
gfr__is_selected | bit (1) | NOT NULL | Represents if the we are printing a document to GoFileRoom
gfr__file_extension | nvarchar (16) | NOT NULL | Selected file extension for GoFileRoom output. This only applies if gfr__is_selected is true.
gfr__is_tax_form_filing_copy_selected | bit (1) | NOT NULL | True if the user wants to print the filing copy of the tax form to file (for GoFileRoom).
gfr__is_tax_form_client_copy_selected | bit (1) | NOT NULL | True if the user wants to print the client copy of the tax form to file (for GoFileRoom).
engagement_binder_output_to_gfr | bit (1) | NOT NULL | Flag that indicates whether to output to GoFileRoom when printing engagement binder.
onvio_documents__is_selected | bit (1) | NOT NULL | Represents if we are printing a document to Onvio Documents
onvio_documents__file_extension | nvarchar (8) | NOT NULL | Selected file extension for Onvio Documents output. This only applies if onvio_documents__is_selected is true.
onvio_documents__is_tax_form_filing_copy_selected | bit (1) | NOT NULL | True 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_selected | bit (1) | NOT NULL | True if the user wants to print the client copy of the tax form to file (for Onvio Documents).
engagement_binder_output_to_onvio_documents | bit (1) | NOT NULL | Flag that indicates whether to output to Onvio Documents when printing engagement binder.
for_complete_payroll_or_forms_output | bit (1) | NOT NULL | If true, then this record is for use during Complete Payroll Output (in Print Checks) or Complete Forms Output.

Primary key
Name | Columns | Description
PK_Print_Destination_User_Preference | print_destination_user_preference_KEY |
Unique constraints
Name | Columns | Description
UK_Print_Destination_User_Preference$user_preference_KEY$print_job_type_KEY$for_complete_payroll_or_forms_output | user_preference_KEY, print_job_type_KEY, for_complete_payroll_or_forms_output |

Foreign keys
Name | Columns | Referenced table | Description
FK_Print_Destination_User_Preference__Print_Job_Type__print_job_type_KEY | print_job_type_KEY | Print_Job_Type (print_job_type_KEY) |
FK_Print_Destination_User_Preference__User_Preference__user_preference_KEY | user_preference_KEY | User_Preference (user_preference_KEY) |