| upr_id | int(11) | NO | | PRI | auto_increment | |
| upr_cus_id | int(11) | NO | 0 | MUL | | |
| upr_cli_id | int(11) | NO | 0 | MUL | | |
| upr_usr_id | int(11) | NO | 0 | MUL | | |
| upr_email_notifications | char(1) | NO | | | | |
| upr_admin | char(1) | NO | | | | |
| upr_emergency_access | char(1) | NO | | | | |
| upr_customer_search | char(1) | NO | | | | |
| upr_customer_list | char(1) | NO | | | | |
| upr_customer_details | char(1) | NO | | | | |
| upr_customer_defn | char(1) | NO | | | | |
| upr_customer_login | char(1) | NO | | | | |
| upr_client_search | char(1) | NO | | | | |
| upr_client_list | char(1) | NO | | | | |
| upr_client_details | char(1) | NO | | | | |
| upr_client_defn | char(1) | NO | | | | |
| upr_client_pricing | char(1) | NO | | | | |
| upr_client_login | char(1) | NO | | | | |
| upr_upload_photomicrographs | char(1) | NO | | | | |
| upr_patient_search | char(1) | NO | | | | |
| upr_patient_list | char(1) | NO | | | | |
| upr_patient_details | char(1) | NO | | | | |
| upr_patient_defn | char(1) | NO | | | | |
| upr_patient_disable | char(1) | NO | | | | |
| upr_patient_ins_verfication | char(1) | NO | | | | |
| upr_patient_handouts_view | char(1) | NO | | | | |
| upr_patient_handouts_add | char(1) | NO | | | | |
| upr_patient_handouts_edit | char(1) | NO | | | | |
| upr_patient_handouts_delete | char(1) | NO | | | | |
| upr_patient_portal_access_view | char(1) | NO | | | | |
| upr_patient_portal_access_add | char(1) | NO | | | | |
| upr_patient_portal_access_edit | char(1) | NO | | | | |
| upr_patient_portal_access_delete | char(1) | NO | | | | |
| upr_patient_show_sensitive_info | char(1) | NO | | | | |
| upr_patient_gen_statements | char(1) | NO | | | | |
| upr_donor_search | char(1) | NO | | | | |
| upr_donor_list | char(1) | NO | | | | |
| upr_donor_details | char(1) | NO | | | | |
| upr_donor_defn | char(1) | NO | | | | |
| upr_physician_search | char(1) | NO | | | | |
| upr_physician_list | char(1) | NO | | | | |
| upr_physician_details | char(1) | NO | | | | |
| upr_physician_schedule_add | char(1) | NO | | | | |
| upr_physician_schedule_delete | char(1) | NO | | | | |
| upr_physician_defn | char(1) | NO | | | | |
| upr_insurance_search | char(1) | NO | | | | |
| upr_insurance_list | char(1) | NO | | | | |
| upr_insurance_details | char(1) | NO | | | | |
| upr_insurance_defn | char(1) | NO | | | | |
| upr_insurance_add_duplicate_address | char(1) | NO | | | | |
| upr_encounter_search | char(1) | NO | | | | |
| upr_encounter_list | char(1) | NO | | | | |
| upr_encounter_details | char(1) | NO | | | | |
| upr_encounter_defn | char(1) | NO | | | | |
| upr_encounter_copy | char(1) | NO | 0 | | | |
| upr_encounter_auto_ready | char(1) | NO | | | | |
| upr_encounter_soap_details | char(1) | NO | | | | |
| upr_encounter_soap_sign | char(1) | NO | | | | |
| upr_encounter_soap_reviewer_sign | char(1) | NO | | | | |
| upr_encounter_soap_vitals | char(1) | NO | | | | |
| upr_encounter_soap_subjective | char(1) | NO | | | | |
| upr_encounter_soap_objective | char(1) | NO | | | | |
| upr_encounter_soap_assessment | char(1) | NO | | | | |
| upr_encounter_soap_plan | char(1) | NO | | | | |
| upr_encounters_soap_labels | char(1) | NO | | | | |
| upr_encounters_soap_labels_add | char(1) | NO | | | | |
| upr_encounters_soap_labels_edit | char(1) | NO | | | | |
| upr_encounters_soap_labels_delete | char(1) | NO | | | | |
| upr_encounter_templates_list | char(1) | NO | | | | |
| upr_encounter_templates_add | char(1) | NO | | | | |
| upr_encounter_templates_edit | char(1) | NO | | | | |
| upr_encounter_templates_delete | char(1) | NO | | | | |
| upr_encounter_templates_export | char(1) | NO | | | | |
| upr_encounter_template_library_manage | char(1) | NO | | | | |
| upr_encounter_amending | char(1) | NO | | | | |
| upr_nuance | char(1) | NO | | | | |
| upr_precert_search | char(1) | NO | | | | |
| upr_precert_list | char(1) | NO | | | | |
| upr_precert_details | char(1) | NO | | | | |
| upr_precert_defn | char(1) | NO | | | | |
| upr_precert_email_notifications | char(1) | NO | | | | |
| upr_precert_reports_employee_benchmark | char(1) | NO | | | | |
| upr_precert_reports_aging | char(1) | NO | | | | |
| upr_precert_reports_avg_days_approved | char(1) | NO | | | | |
| upr_precert_reports_phone_reminders | char(1) | NO | | | | |
| upr_location_search | char(1) | NO | | | | |
| upr_location_list | char(1) | NO | | | | |
| upr_location_details | char(1) | NO | | | | |
| upr_location_defn | char(1) | NO | | | | |
| upr_crm | char(1) | NO | | | | |
| upr_lead_search | char(1) | NO | | | | |
| upr_lead_list | char(1) | NO | | | | |
| upr_lead_details | char(1) | NO | | | | |
| upr_lead_defn | char(1) | NO | | | | |
| upr_contact_search | char(1) | NO | | | | |
| upr_contact_list | char(1) | NO | | | | |
| upr_contact_details | char(1) | NO | | | | |
| upr_contact_defn | char(1) | NO | | | | |
| upr_test_code_search | char(1) | NO | | | | |
| upr_test_code_list | char(1) | NO | | | | |
| upr_test_code_details | char(1) | NO | | | | |
| upr_test_code_defn | char(1) | NO | | | | |
| upr_feature_request_search | char(1) | NO | | | | |
| upr_feature_request_list | char(1) | NO | | | | |
| upr_feature_request_details | char(1) | NO | | | | |
| upr_feature_request_defn | char(1) | NO | | | | |
| upr_web_user_search | char(1) | NO | | | | |
| upr_web_user_list | char(1) | NO | | | | |
| upr_web_user_details | char(1) | NO | | | | |
| upr_web_user_defn | char(1) | NO | | | | |
| upr_web_user_group_view | char(1) | NO | | | | |
| upr_web_user_group_add | char(1) | NO | | | | |
| upr_web_user_group_edit | char(1) | NO | | | | |
| upr_web_user_group_delete | char(1) | NO | | | | |
| upr_order_search | char(1) | NO | | | | |
| upr_order_list | char(1) | NO | | | | |
| upr_order_details | char(1) | NO | | | | |
| upr_order_defn | char(1) | NO | | | | |
| upr_order_standing | char(1) | NO | | | | |
| upr_order_daily_manifest | char(1) | NO | | | | |
| upr_order_pending_report | char(1) | NO | | | | |
| upr_order_order_summary | char(1) | NO | | | | |
| upr_order_psc_report | char(1) | NO | | | | |
| upr_order_test_counts | char(1) | NO | | | | |
| upr_report_search | char(1) | NO | | | | |
| upr_report_new | char(1) | NO | | | | |
| upr_report_inhouse | char(1) | NO | | | | |
| upr_report_options | char(1) | NO | | | | |
| upr_missing_donor | char(1) | NO | | | | |
| upr_invalid_review | char(1) | NO | | | | |
| upr_mro_review | char(1) | NO | | | | |
| upr_infopdf_add | char(1) | NO | | | | |
| upr_infopdf_delete | char(1) | NO | | | | |
| upr_client_hipaa | char(1) | NO | | | | |
| upr_customer_hipaa | char(1) | NO | | | | |
| upr_ahi_hipaa | char(1) | NO | | | | |
| upr_report_cumulative | char(1) | NO | | | | |
| upr_ledger_summary_report | char(1) | NO | | | | |
| upr_invoice_list | char(1) | NO | | | | |
| upr_invoice_close_period | char(1) | NO | | | | |
| upr_billing_reports | char(1) | NO | | | | |
| upr_billing_reports_appointment_encounter_reconciliation_report | char(1) | NO | | | | |
| upr_billing_reports_list_all_encounters | char(1) | NO | | | | |
| upr_billing_reports_practice_analysis | char(1) | NO | | | | |
| upr_billing_reports_primary_insurance_aging | char(1) | NO | | | | |
| upr_billing_reports_secondary_insurance_aging | char(1) | NO | | | | |
| upr_billing_reports_tertiary_insurance_aging | char(1) | NO | | | | |
| upr_billing_reports_production_report | char(1) | NO | | | | |
| upr_billing_reports_credit_balance_report | char(1) | NO | | | | |
| upr_billing_reports_insurance_payments | char(1) | NO | | | | |
| upr_billing_reports_insurance_payments_analysis | char(1) | NO | | | | |
| upr_billing_reports_insurance_payments_report | char(1) | NO | | | | |
| upr_billing_reports_patient_aging | char(1) | NO | | | | |
| upr_billing_reports_patient_collection | char(1) | NO | | | | |
| upr_billing_reports_patient_birthday_report | char(1) | NO | | | | |
| upr_billing_reports_patient_email_report | char(1) | NO | | | | |
| upr_billing_reports_patient_summary | char(1) | NO | | | | |
| upr_billing_reports_collection_agency | char(1) | NO | | | | |
| upr_billing_reports_appointments_list | char(1) | NO | | | | |
| upr_billing_reports_appointments_list_detailed | char(1) | NO | | | | |
| upr_billing_reports_missed_appointments | char(1) | NO | | | | |
| upr_billing_reports_cancelled_appointments | char(1) | NO | | | | |
| upr_billing_reports_daily_trans_report | char(1) | NO | | | | |
| upr_billing_reports_cash_analysis_report | char(1) | NO | | | | |
| upr_billing_reports_daily_summary_report | char(1) | NO | | | | |
| upr_billing_reports_range_summary_report | char(1) | NO | | | | |
| upr_billing_reports_patient_payment_report | char(1) | NO | | | | |
| upr_billing_reports_cpt_analysis_report | char(1) | NO | | | | |
| upr_billing_reports_payments_reconciliation_report | char(1) | NO | | | | |
| upr_billing_reports_physician_referrals | char(1) | NO | | | | |
| upr_billing_reports_unapplied_payments | char(1) | NO | | | | |
| upr_billing_reports_cash_close_out_report_su | char(1) | NO | | | | |
| upr_billing_reports_cash_close_out_report_all | char(1) | NO | | | | |
| upr_billing_reports_provider_utilization_summary | char(1) | NO | | | | |
| upr_billing_reports_suppressed_patient_statements | char(1) | NO | | | | |
| upr_billing_reports_daily_deposit_summary_report | char(1) | NO | | | | |
| upr_billing_reports_new_encounters_summary | char(1) | NO | | | | |
| upr_billing_reports_combined_aging | char(1) | NO | | | | |
| upr_billing_reports_encounters_aging_report | char(1) | NO | | | | |
| upr_billing_reports_transaction_report | char(1) | NO | | | | |
| upr_billing_reports_production_analysis_rvu | char(1) | NO | | | | |
| upr_billing_reports_encounter_summary | char(1) | NO | | | | |
| upr_billing_reports_encounter_summary_aging | char(1) | NO | | | | |
| upr_billing_reports_dx_analysis_report | char(1) | NO | | | | |
| upr_billing_reports_supervising_phy_report | char(1) | NO | | | | |
| upr_billing_reports_encounter_dx_analysis_report | char(1) | NO | | | | |
| upr_close_periods | char(1) | NO | | | | |
| upr_devrequest_list | char(1) | NO | | | | |
| upr_devrequest_details | char(1) | NO | | | | |
| upr_devrequest_defn | char(1) | NO | | | | |
| upr_devrequest_actions | char(1) | NO | | | | |
| upr_payment_search | char(1) | NO | | | | |
| upr_payment_list | char(1) | NO | | | | |
| upr_payment_details | char(1) | NO | | | | |
| upr_payment_defn | char(1) | NO | | | | |
| upr_payment_defn_add | char(1) | NO | | | | |
| upr_payment_defn_edit | char(1) | NO | | | | |
| upr_payment_defn_delete | char(1) | NO | | | | |
| upr_payment_edi_logs | char(1) | NO | | | | |
| upr_payment_edi_remits | char(1) | NO | | | | |
| upr_unapplied_payment_search | char(1) | NO | | | | |
| upr_unapplied_payment_list | char(1) | NO | | | | |
| upr_unapplied_payment_details | char(1) | NO | | | | |
| upr_unapplied_payment_defn | char(1) | NO | | | | |
| upr_fee_schedule_override_price | char(1) | NO | | | | |
| upr_fee_schedule_search | char(1) | NO | | | | |
| upr_fee_schedule_list | char(1) | NO | | | | |
| upr_fee_schedule_details | char(1) | NO | | | | |
| upr_fee_schedule_defn | char(1) | NO | | | | |
| upr_scheduler_list | char(1) | NO | | | | |
| upr_scheduler_double_book | char(1) | NO | | | | |
| upr_scheduler_exceptions | char(1) | NO | | | | |
| upr_appointments_reminder_report | char(1) | NO | | | | |
| upr_resource_search | char(1) | NO | | | | |
| upr_resource_list | char(1) | NO | | | | |
| upr_resource_details | char(1) | NO | | | | |
| upr_resource_schedule_add | char(1) | NO | | | | |
| upr_resource_schedule_delete | char(1) | NO | | | | |
| upr_resource_defn | char(1) | NO | | | | |
| upr_apt_reason_search | char(1) | NO | | | | |
| upr_apt_reason_list | char(1) | NO | | | | |
| upr_apt_reason_details | char(1) | NO | | | | |
| upr_apt_reason_defn | char(1) | NO | | | | |
| upr_rcl_reason_search | char(1) | NO | | | | |
| upr_rcl_reason_list | char(1) | NO | | | | |
| upr_rcl_reason_details | char(1) | NO | | | | |
| upr_rcl_reason_defn | char(1) | NO | | | | |
| upr_events_view | char(1) | NO | | | | |
| upr_events_add | char(1) | NO | | | | |
| upr_events_edit | char(1) | NO | | | | |
| upr_events_delete | char(1) | NO | | | | |
| upr_task_category_search | char(1) | NO | | | | |
| upr_task_category | char(1) | NO | | | | |
| upr_task_category_details | char(1) | NO | | | | |
| upr_task_category_defn | char(1) | NO | | | | |
| upr_recall_list_search | char(1) | NO | | | | |
| upr_recall_list | char(1) | NO | | | | |
| upr_recall_list_details | char(1) | NO | | | | |
| upr_recall_list_defn | char(1) | NO | | | | |
| upr_clinical_alerts_view | char(1) | NO | | | | |
| upr_clinical_alerts_add | char(1) | NO | | | | |
| upr_clinical_alerts_edit | char(1) | NO | | | | |
| upr_clinical_alerts_delete | char(1) | NO | | | | |
| upr_clinical_reminders_view | char(1) | NO | | | | |
| upr_clinical_reminders_add | char(1) | NO | | | | |
| upr_clinical_reminders_edit | char(1) | NO | | | | |
| upr_clinical_reminders_delete | char(1) | NO | | | | |
| upr_encounter_soap_notes_view | char(1) | NO | | | | |
| upr_encounter_soap_notes_add | char(1) | NO | | | | |
| upr_encounter_soap_notes_edit | char(1) | NO | | | | |
| upr_encounter_soap_notes_delete | char(1) | NO | | | | |
| upr_patient_classes_view | char(1) | NO | | | | |
| upr_patient_classes_add | char(1) | NO | | | | |
| upr_patient_classes_edit | char(1) | NO | | | | |
| upr_patient_classes_delete | char(1) | NO | | | | |
| upr_patient_required_fields | char(1) | NO | | | | |
| upr_document_labels_view | char(1) | NO | | | | |
| upr_document_labels_add | char(1) | NO | | | | |
| upr_document_labels_edit | char(1) | NO | | | | |
| upr_document_labels_delete | char(1) | NO | | | | |
| upr_documents_view | char(1) | NO | | | | |
| upr_documents_add | char(1) | NO | | | | |
| upr_documents_edit | char(1) | NO | | | | |
| upr_documents_delete | char(1) | NO | | | | |
| upr_documents_folders_view | char(1) | NO | | | | |
| upr_documents_folders_add | char(1) | NO | | | | |
| upr_documents_folders_edit | char(1) | NO | | | | |
| upr_documents_folders_delete | char(1) | NO | | | | |
| upr_patient_documents_view | char(1) | NO | | | | |
| upr_patient_documents_add | char(1) | NO | | | | |
| upr_patient_documents_edit | char(1) | NO | | | | |
| upr_patient_documents_delete | char(1) | NO | | | | |
| upr_documents_sign | char(1) | NO | | | | |
| upr_faxes_view | char(1) | NO | | | | |
| upr_guarantor_search | char(1) | NO | | | | |
| upr_guarantor_list | char(1) | NO | | | | |
| upr_guarantor_details | char(1) | NO | | | | |
| upr_guarantor_defn | char(1) | NO | | | | |
| upr_custom_charge_search | char(1) | NO | | | | |
| upr_custom_charge_list | char(1) | NO | | | | |
| upr_custom_charge_details | char(1) | NO | | | | |
| upr_custom_charge_defn | char(1) | NO | | | | |
| upr_var | char(1) | NO | | | | |
| upr_hr_app_list | char(1) | NO | | | | |
| upr_client_encounters_stats | char(1) | NO | | | | |
| upr_client_system_stats | char(1) | NO | | | | |
| upr_client_apt_stats | char(1) | NO | | | | |
| upr_tickets | char(1) | NO | | | | |
| upr_erx | char(1) | NO | | | | |
| upr_tasks_view | char(1) | NO | | | | |
| upr_tasks_add | char(1) | NO | | | | |
| upr_tasks_reassign | char(1) | NO | | | | |
| upr_tasks_admin | char(1) | NO | | | | |
| upr_forms_view | char(1) | NO | | | | |
| upr_forms_add | char(1) | NO | | | | |
| upr_forms_edit | char(1) | NO | | | | |
| upr_forms_delete | char(1) | NO | | | | |
| upr_clinical_doc_attach | char(1) | NO | | | | |
| upr_roles_list | char(1) | NO | | | | |
| upr_roles_add | char(1) | NO | | | | |
| upr_roles_defn | char(1) | NO | | | | |
| upr_roles_delete | char(1) | NO | | | | |
| upr_cpoe | char(1) | NO | | | | |
| upr_cpoe_orders_view | char(1) | NO | | | | |
| upr_cpoe_orders_add | char(1) | NO | | | | |
| upr_cpoe_orders_edit | char(1) | NO | | | | |
| upr_cpoe_orders_delete | char(1) | NO | | | | |
| upr_cpoe_results_view | char(1) | NO | | | | |
| upr_cpoe_results_add | char(1) | NO | | | | |
| upr_cpoe_results_edit | char(1) | NO | | | | |
| upr_cpoe_results_delete | char(1) | NO | | | | |
| upr_cpoe_results_assign_supervising | char(1) | NO | | | | |
| upr_cpoe_results_attach_patient | char(1) | NO | | | | |
| upr_cpoe_results_archive | char(1) | NO | | | | |
| upr_cpoe_results_attach_order | char(1) | NO | | | | |
| upr_patient_history_delete | char(1) | YES | | | | |
| upr_cpoe_results_release_to_phr | char(1) | NO | | | | |
| upr_cpoe_orders_resend | char(1) | NO | | | | |
| upr_cpoe_orders_archive | char(1) | NO | | | | |
| upr_non_patient_list | char(1) | NO | | | | |
| upr_non_patient_search | char(1) | NO | | | | |
| upr_non_patient_details | char(1) | NO | | | | |
| upr_non_patient_defn | char(1) | NO | | | | |
| upr_poa_defn | char(1) | NO | | | | |
| upr_scheduler_interval | char(1) | NO | | | | |
| upr_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| upr_created | timestamp | YES | CURRENT_TIMESTAMP | | | |
| upr_imz_details | char(1) | NO | | | | |
| upr_imz_defn | char(1) | NO | | | | |
| upr_cpoe_rad | char(1) | NO | | | | |
| upr_cpoe_rad_orders_view | char(1) | NO | | | | |
| upr_cpoe_rad_orders_add | char(1) | NO | | | | |
| upr_cpoe_rad_orders_edit | char(1) | NO | | | | |
| upr_cpoe_rad_orders_delete | char(1) | NO | | | | |
| upr_cpoe_rad_orders_resend | char(1) | NO | | | | |
| upr_cpoe_rad_orders_archive | char(1) | NO | | | | |
| upr_cpoe_rad_results_view | char(1) | NO | | | | |
| upr_cpoe_rad_results_add | char(1) | NO | | | | |
| upr_cpoe_rad_results_edit | char(1) | NO | | | | |
| upr_cpoe_rad_results_delete | char(1) | NO | | | | |
| upr_cpoe_rad_results_assign_interpreting | char(1) | NO | | | | |
| upr_cpoe_rad_results_attach_patient | char(1) | NO | | | | |
| upr_cpoe_rad_results_archive | char(1) | NO | | | | |
| upr_cpoe_rad_results_attach_order | char(1) | NO | | | | |
| upr_cpoe_rad_results_release_to_phr | char(1) | NO | | | | |
| upr_clinical_interventions_view | char(1) | NO | | | | |
| upr_clinical_interventions_add | char(1) | NO | | | | |
| upr_clinical_interventions_edit | char(1) | NO | | | | |
| upr_clinical_interventions_disable | char(1) | NO | | | | |
| upr_clinical_interventions_reference_resource_view | char(1) | NO | | | | |
| upr_claim_rules_edit | char(1) | NO | | | | |
| upr_claim_rules_view | char(1) | NO | | | | |
| upr_billing_reports_cpt_dx_frequency_report | char(1) | NO | | | | |