SharePoint and SQL are great partners. By customizing SharePoint to integrate with a SQL database, it is possible to combine the excellent UI with modern pages that SharePoint offers with a structured database toolkit offering full SQL transaction processing.
SoHo’s client, Northwell Health, is a nonprofit integrated healthcare network that is New York State’s largest healthcare provider and private employer, with more than 74,000 employees in 2020. To provide quality follow-up care, healthcare professionals require ready access to their patient’s records and a collaborative workflow to collect input from other medical professionals.
Northwell Health was determined to improve the performance in their preventative patient activity with a “Value-based Gaps in Care” project initiative. This initiative aimed to leverage automated aspects of the care chain to identify gaps in patient contact with Northwell’s doctors and clinicians, such as visits and proactive patient care. The existing workflow process was handled via Excel exports, macros, and manual reports.
The Solution
SoHo extended the existing SharePoint implementation and automated data synchronization with SharePoint and SQL using SharePoint lists (tasks). Doctors and medical professionals were able to update and complete forms (tasks). SoHo stored the data in a SQL database storage system.
The UI was built with front-end forms with custom front-end scripting JavaScript. The data collected from these tasks are updated back to the SQL database.
The SQL-stored data was then queried according to the business logic to segment groups of patients who would benefit from clinical recall or outreach.
The Outcome
Northwell’s hospitals and clinics are now able to offer proactive care for patients with chronic conditions with their patient-recall initiative Northwell’s goals for leveraging their SharePoint investment further were met, and their system of record allowed staff to:
- Exchange of discrete data elements between systems to enable clinical decision support, analytics, and alerting
- Transmit physician narratives for smooth transitions of care
- Store and manage patient data records in a secure, mobile-accessible site
- Edit and update patient care records from anywhere, on any device.
- Manage patient recall procedures
- Collect metrics on the efficacy of the recall procedures
This project was a logical extension of Northwell’s digital workplace journey, proving again that a SharePoint investment offers an excellent ROI due to its excellent customization and integration potential.
