\n<\/strong><\/span><\/h3>\nFor the clinicians, a different approach was needed. The clinicians would need to have access, while out in the field, to all of the information for their upcoming patients. With many of the nurses being semi-retired, or in some cases fully retired \u2013 an easy-to-use interface was critical in order to get the data into their hands as efficiently and painlessly as possible. As such, this element was the perfect candidate for a mobile Power Apps canvas application.
\n<\/strong><\/span>
\n<\/p>\nSVNA’s mobile canvas Power Apps application, used by its nursing staff to set their current availability, view details of their upcoming appointments, and complete vaccinations
\n<\/strong><\/em><\/span><\/p>\nThe application holds many useful features for clinicians out in the field and, as with all Power Apps, is available to them directly from their mobile phone or tablet device.
\n<\/span><\/p>\n\n- \n
From the <\/span>Main Menu<\/span>, clinicians can immediately see how many vaccinations they have on hand and choose to navigate to different areas in the application.
\n<\/span><\/div>\n<\/li>\n- \n
The <\/span>My Profile<\/span> section allows nurses to toggle whether they are flagged as available for assignment and provide an availability comment to the admin staff.
\n<\/span><\/div>\n<\/li>\n- \n
The <\/span>Clinic Assignments<\/span> section allows nurses to view the date and location of the upcoming clinics they have been assigned to.
\n<\/span><\/div>\n<\/li>\n- \n
The <\/span>Appointments <\/span>section shows details of all the patients the clinician is due to see during their shift, with the ability to filter the data and to see, from within the gallery view, key information about each patient.
\n<\/span><\/div>\n<\/li>\n- \n
The <\/span>Appointments Detail<\/span> screen provides, for each patient, all the information that was entered into the system during registration and allows the clinician to confirm the shot was delivered.
\n<\/span><\/div>\n<\/li>\n<\/ul>\nSince the application was built on top of Dataverse, the nurses have access to the data immediately; patients can come to the clinic, book an appointment right from their vehicle, and immediately be registered on the nurses’ applications. Additionally, all information about the nurses’ availability and the shot completion is automatically fed back into Dataverse to be able to be viewed by the admin staff.
\n<\/span><\/p>\n
\n<\/strong><\/span><\/p>\nAdministrative layer \u2013 model-driven Power Apps
\n<\/strong><\/span><\/h3>\nFor the admin staff, a more data-focused direction was required. Admins would need to see large swathes of data, understand them immediately, and be able to act on them \u2013 for this a Power Apps model-driven app was the perfect medium.
\n<\/strong><\/span>
\n
\n<\/strong><\/span><\/p>\nSVNA’s model-driven Power App allowing administrative staff the ability to manage clinic sites, nursing staff, and billing<\/em>
\n<\/strong><\/span><\/p>\nWith this app, the admin staff are able to add new clinic sites, assign nurses to clinics depending on their availability, set up unique private patient registration sites for specific companies’ employees, see all patients registration responses and data, process billing for completed vaccinations, and track trends \u2013 such as seeing which locations are most popular at which particular times of day, and information on the distribution of available vaccinations between nurses.
\n<\/strong><\/span><\/p>\nSolution Architecture
\n<\/strong><\/span><\/h2>\nTo summarize, the solution is built entirely using Microsoft Dataverse as its central data repository and consists of three main parts:
\n<\/span><\/p>\n\n- \n
A public facing website for patients to book appointments \u2013 this is a custom website that uses the <\/span>Microsoft Dataverse SDK<\/span> to retrieve clinic site data and save back information about incoming patients and their bookings.
\n<\/span><\/div>\n<\/li>\n- \n
A ‘Clinician’s app’ \u2013 this is a <\/span>Power Apps canvas app<\/span> used by clinicians in the field. It surfaces the data stored in Dataverse in a user-friendly manner and allows nurses to immediately save the vaccination completion data back into the data store.
\n<\/span><\/div>\n<\/li>\n- \n
An admin app \u2013 this is a <\/span>Power Apps model-driven app<\/span> for admin users to get direct views and manipulate the data in Dataverse. It also allows managing the various entities involving in the system, for example, adding new clinic sites.
\n<\/span><\/div>\n<\/li>\n<\/ul>\nAdditionally, <\/span>Power Automate cloud flows<\/span> are used within the solution to reach out to patients, automatically sending confirmation bookings on receipt of their registration along with a private link to reschedule their appointment. Other stages utilize Power Automate to streamline the process, with flows being used to sanitize incoming data and to automate parts of the billing process.
\n<\/strong><\/span><\/p>\n<\/p>\n
High level solution architecture – information fed into Dataverse from the custom website is surfaced and edited in Power Apps, with Power Automate used for notifications and data processing<\/span><\/em><\/p>\nAs a secure, relational data store, Dataverse provided a strong backbone for the solution, allowing SVNA to responsibly capture and store sensitive patient information, safe in the knowledge that it was being held securely and access could be controlled. The customisable views of the data-rich entities allowed Signetic to configure all data displays to the exact needs of SVNA’s admin staff, and the ability to create relationships between different entities provided a rich data backdrop that will enable meaningful insights for years to come.
\n<\/span><\/p>\nDynamics 365 Healthcare Accelerator
\n<\/strong><\/span><\/h3>\nSince the time frame for development of the solution was so tight \u2013 as the flu season rapidly approached \u2013 the team at Signetic recognized the benefits of starting off the engagement by installing Microsoft’s Healthcare Accelerator for Dynamics 365. This template pre-populated SVNA’s Dataverse environment with healthcare-specific data definitions and relationships (such as those between patient and practitioner), giving the team at Signetic a platform to jump-start the data modelling process. In particular, the Accelerator’s pre-made ‘Patients’ and ‘Appointments’ tables were used to rapidly develop the tables that would become the building blocks of the custom website and canvas app solution.
\n<\/span><\/p>\nHaving the accelerator installed enabled the team to focus on the custom requirements needed to get SVNA back to work faster instead of having to ‘re-invent the wheel’ by re-creating a healthcare data model. It is this rapid development that is at the heart of the accelerator program, which includes a whole suite for extending the Common Data Model and tailoring it across multiple different industries.
\n<\/strong><\/span><\/p>\nImpact and benefits
\n<\/strong><\/span><\/h2>\nWithin a matter of months, SVNA has revolutionized its vaccination delivery system, enabling its clinicians to be out in the field protecting their patients while remaining safe from the threat of COVID-19.
\n<\/span><\/p>\nPatients can be vaccinated contact-free from within their own vehicle:
\n<\/span><\/p>\n\n- \n
Efficient and distanced vaccination delivery reduces the risk of contamination.
\n<\/span><\/div>\n<\/li>\n- \n
The shift to vaccinating families together, as opposed to the parents at their place of employment and children at their schools, has also seen the process become much more streamlined for the patients, who have remarkably noted that this year’s vaccinations have been ‘the easiest yet’. Additionally, having parental support for children, especially young children, makes vaccinations less intimidating and leads to a much better experience overall.
\n<\/span><\/div>\n<\/li>\n<\/ul>\nStaff can use their own phone or tablet to interact with the solution, eliminating the need to share paper:
\n<\/span><\/p>\n\n- \n
No sharing of paper or shared devices means fewer shared surfaces, which in turns leads to lower risk of infection. The fact that nurses can use their own devices helps keep costs down for SVNA and gives nurses the familiarity and ‘any-time access’ they require.
\n<\/span><\/div>\n<\/li>\n<\/ul>\nAll the information about the patient is available from the very beginning of the process:
\n<\/span><\/p>\n\n- \n
Nurses can see in advance the details of the patients they will be treating, crucially allowing them to prepare for young children, disabled individuals, or the elderly, who may have different requirements.
\n<\/span><\/div>\n<\/li>\n<\/ul>\nEasy to use<\/span>:
\n<\/span><\/p>\n\n- \n
SVNA managed to rotate as many nurses as possible through their pilot site to get them familiar with the application, but as the number of patients ramped up from 10 in the first day, to 100 by the end of the week, to 1000 and then 10,000 in the following weeks, some of the nurses who did not come onto the program until later needed to dive straight into using the app at a busy clinic. Other nurses who were already familiar with the software were able to teach their newer colleagues how to use the app and by the first 5 patients they had the hang of it.
\n<\/span><\/div>\n<\/li>\n<\/ul>\n
\n<\/strong><\/span><\/p>\nJake’s original vision was not just confined to making the process work in a time of COVID. Similarly, the benefits have spread further than simply allowing SVNA to practice safely during the pandemic:
\n<\/span><\/p>\n\n- \n
Patients are processed faster, with SVNA seeing an improvement of 90% in vaccination throughput
\n<\/span><\/div>\n<\/li>\n- \n
Removed the need for chasing patients for missing information on their paper forms by requiring mandatory information for successful registration
\n<\/span><\/div>\n<\/li>\n- \n
Admins have instant access to patient data from the moment the vaccination has been marked as complete rather than having to wait for information in transit
\n<\/span><\/div>\n<\/li>\n- \n
Insurance claims can be made daily without needing much manual interference
\n<\/span><\/div>\n<\/li>\n- \n
Administrators have seen the time taken to schedule vaccinations cut significantly