Integration Scope
In line with the original purpose of the current exercise, the following integration scope is proposed.
Patients
Patient records flow should follow the following sequence:
Notes:
Patients will be identifed with the following data objects in each respective system: in QuickBooks Online: Customers Patient records shoult NOT be maintianed directly in DentalTap.
Dental Profiles
Despite the simplified Dental Profile maintneance sequence below, DentalTap Dental Profile for each Patient should be accessible at tooth level for furhter use in business proposals.
Treatment Catalog
Simimlar to Patient records, the master Catalog of Products/Services availble for offer to Patients should live (create/edit) primarily in CRM and then flow to DentalTap. QuickBooks Online does not hold a Product/Service level record as subeequent values in Invoices are aggregated at ‘Class’ level.
Notes:
As for Patient records, Product/Service records shoult NOT be maintianed directly in DentalTap.
Walk-In Appointments
Walk-in Appointments - defined as appointments booked for initial consultation prior to further substantial surgery planning - follow a flow optimised for fluiditiy and efficiency. It is expected that at no time during this flow should C32 staff have to generate ‘Affaires’, Quotes’ or ‘Commandes’ directly in CRM. However, for this flow to work effectively, the following sequence wil need to be ovserved very tightly.
Notes:
Initial steps in CRM for this flow - incl. Calendar booking - should secure the data link between CRM business data objects (Contact, Affaire, Devis, Commande) throughout the current flow and subsequent flows. Upon treatment care update, the Sales Order generated at appointment booking stage, which includes a product/service for Consultation shoulod be updated with actual Treatment activities and subsequent product/service pricing in order for Sales Order to be ready for Invoice conversion when Patient exits the treatment room. Each Treatment Plan should generate/update individual Quotes in CRM with respective product/service pricing. Quotes are different from the actual printable document, which will be generated from a click-button in CRM on a custom Rich-Text format.
Intervention Appointment Confirmation
Following an intial consultation during which a Treatment Plan is generated, a Patient will occasionally confirm the subsequent surgery proposal and book an appointment.
Surgery Intervention
Similar to the Walk-In Appointment flow above, Surgery Intervention should require actual treatment activities documentation in DentalTap for live integration update of the existing Sales Order and one-click conversion to invoice when the patient exits the treatment room.
DentalTap integration Requirements
The following requirements are expected to be met by DentalTap:
Patient Data Object
Ability to Create/Edit Patient data object from API. Response should include DentalTap ID of the patient Field availability to store an external ID (CRM ID) as a 20 character string over API POST/PUT/PATCH call Ability to query Patient data object in from API from its ID. All properties visible via the native DentalTap web interface should be returned in the response including Dental and Periodontal charts graphics URLs (readable from GET call). Treatment Data Object
Ability to Create/Edit Treatment data object from API. Response should include DentalTap ID of the treatment Field availability to store an external ID (CRM ID) as a 20 character string over API POST/PUT/PATCH call Ability to query Treatment data object in from API from its ID. All properties visible via the native DentalTap web interface should be returned in the response. Appointment Data Object
Ability to Create/Edit Appointment data object from API. Response should include DentalTap ID of the Appointment Field availability to store an external ID (CRM ID) as a 20 character string over API POST/PUT/PATCH call Live integration with Google Calendar for each dentist/surgeon Ability to query Patient Dental Profile down to tooth details either as a nested data set from the Appointment data object query call or a separate API call. Include URL for Dental/Periodontal chart graphics (PNG or SVG) linked to the appointment. Treatment Activity Data Object
Ability to query Treatment Activity from API based on its related Appointment ID. Returned data set should include nested activities related to respective Treatment ID. Abilityto trigger HTTP WebHook to external API endpoint upon Treatment Activity completion Treatment Plan Data Object
Ability to query Treatment Activity from API based on its ID. Returned data set should include nested activities related to respective Treatment ID. Ability to query Treatment Activity from API based on its related Appointment ID. Returned data set should include nested activities related to respective Treatment ID. Abilityto trigger HTTP WebHook to external API endpoint upon Treatment Plan updat or status update. General Settings/Features
Ability to set a master currency with subsequent name and/or symbol Ability to customise dental/periodontal charts background with custom graphics (Ideally SVG ; PNG acceptable)
Project Scope
Based on the above the following steps and tasks impacting both implementation timeline and budget should be considered:
Further details available on
Project Sequence
Based on the above and customer requirements for optimal transition, the following project sequence is proposed on the assumption of kicking-off the project on .
Project Budget
The following cost items should be factored in the project budget:
Project Implementation/Integration Fee from Paoma: for all Scope Items where identified as ‘Lead’: as per Quote Q-17982 on an ongoing Prepaid-Engineering basis for all Scope Items where identified as ‘Manage’ or ‘Contribute’: as per Quote Q-17983
Professional Services Fee from Paoma - subcontracted to DentalTap as per Quote Q-17987: Legacy data integration (from Julie) into DentalTap in 2 stages Onboarding online sessions for Surgeons
Professional Services Fee from Julie Solutions for 2-stage export of legacy data as per Julie Solurtions document
Monthly Licenses for DentalTap (1 license per Named Surgeon per month) as per Quote Q-17986: 2 seats until staging phase 2 4 seats as from staging phase Additional seats when adding further surgeons
Additional Zoho One Licenses for Suregons
Zoho Flow Tasks in excess of current Zoho One allowance charged from Zoho () Current allowance for 18 active users: 21,000 Taks per month Future allowance for 22 active users (4 additional surgeons): 25,000 Taks per month
Attachments
JU-MK-F02-14-E_modèle courrier export DSIO.pdf
185.2 kB