| Project Case Study - EMR - Healthcare Application |
|
| The client was a healthcare provider (multi-location hospital) for the local resident patients having sleeping disorders. Option Matrix's scope of consulting was for their Seattle, Washington, USA based operations and expected to extend the services to other USA states and globally, later. |
|
| Please fill up the form below and we will submit a proposal for your project. Alternatively, you can send
email to contact@optionm.net with the project
requirements. |
|
|
|
|
|
 |
| Project Description |
|
|
| The application was an appointment scheduler that maintains a list of doctors, clinics and resources. Doctors have availability slots for each workday and off-days that must be factored while recording appointments. Information from patient database must be auto-populated in lookup fields and forms while recording appointments. The appointment history and schedule can be reported for any time period as per the chosen criteria. Appointments can be viewed and managed in an integrated way across all clinics (currently two, but this must be scalable). The client was a healthcare provider (multi-location hospital) for the local resident patients having sleeping disorders. Option Matrix's scope of consulting was for their Seattle, Washington, USA based operations and expected to extend the services to other USA states and globally, later. |
|
|
|
| Click here to submit your project requirements to Option Matrix, India. |
| Back to top |
 |
| Capability Analysis |
|
|
| In this section we have attempted a comprehensive list of application features both at the level of user capabilities as well as integration requirements. Hence we have listed the features under the following sub-sections: |
|
| User Capabilities |
| Login, Change Password and Logout |
| Update Own Profile |
| Maintain Patient Profiles - Add / Edit / Delete the list of Patients and their profiles |
| Add an appointment for a patient by linking to an available timeslot, available doctor, available location (clinic) and available resource (optional). Appointments was also linked to reported problems and have a remarks field. Provide edit (reschedule) and delete facility for managing appointments. Each appointment has a status that can be updated. User friendly GUI must be provided a convenient interface with day, week and month view and a calendar to navigate across dates |
| Search for appointment using application wide criteria including name of doctor, name of patient, date booked, date of appointment, associated properties, specialty and time slot among others. Must be comprehensive |
| Manage a Wait list of patients who need appointment for a particular doctor that was overbooked or not temporarily available at the time preferred by patient |
|
| Admin Capabilities |
| Login, Change Password and Logout |
| Manage User Profiles |
| Manage User Access Rights |
| Maintain List of Clinics |
| Maintain Doctor (Provider) Profiles - Add / Edit / Delete the list of Doctors and their profiles |
| Manage the list of specialties associated with doctors |
| Define availability Schedule of each doctor |
| Manage the list of Locations (associated with a clinic) |
| Associate doctors with locations |
| Define availability schedule for each location |
| Manage the list of resources |
| Associate multiple user definable properties with resources |
| Associate doctors with resources |
| Define availability schedule for each resource |
| Update and Print Super Bill (Summary of Clinical Charges) |
| Manage the list of reported problems. These was the types of ailments that patients mention while asking for an appointment |
| Export data related to appointments, doctors, clinics, locations, patients and resources to a delimited text file |
| Backup and Restore Database as per a configurable schedule |
|
| Reporting Capabilities |
| Lists |
| Appointment List |
| Break List |
| Patient List |
| Provider List |
| Resource List |
| Reason List |
| Patient Recall |
| Super Bill Tracking List |
|
| Appointment Status |
| No Show Report |
| Print Appointment Grid by time period, doctor (provider), resource, location, clinic, reported problem or by patient |
| Print Super Bills |
| Appointment Analysis |
|
| Appointment Wait List |
|
| Connection with Patient EMR Database - Connect to the tables of existing EMR database for lookup fields related to patients or referring / primary care providers and ABILITY TO ADD A PATIENT / REFERRING CARE PROVIDER (Capability 32) |
|
|
|
| Click here to submit your project requirements to Option Matrix, India. |
| Back to top |
 |
| Solution Architecture |
|
|
| This section describes the server configuration and application linkages to any external applications. The application was built using VB.Net with MS SQL Server 2005 as RDBMS. This application was run on Windows 2003 Server and we suggested that the database should reside on a separate dedicated computer, preferably running on Windows 2003 server with at least 1 GB RAM and 500 GB hard disk. |
|
| Using the enhanced SQL database, MS Windows (Dot Net & WinForms), other reporting (RDLC & Crystal reports) and networking technologies improved the processes involved in Electronic Medical Records (EMR) , Reports generation and processing & mail correspondence & task and appointment management. |
|
| In Phase 2, a web interface may be added to make the reports and analysis features accessible via a browser. That will require the server to have a Static IP address. |
|
|
|
| Back to top |
 |
| Business Benefits |
|
|
| The easiness in record maintenance and report generation along with appointment handling at various locations |
| Synchronized information at the run time had made the solution more robust and resulted in increased number of patients treated with the same hospital infrastructure. Hence increase in the market share for the client. |
| Powerful features had made the application administrators' job easier and hence increased his productivity with the lesser effort. |
| The business managed with future based technology solution provided by Option Matrix to handle all its needs. This has decreased the constant budget allocation for enhancements and hence increased the client's profit margin significantly. |
| The client's installations were pronounced as a paper less hospital and document processing premises. |
|
|
|
|
| Click here to submit your project requirements to Option Matrix, India. |
| Back to top |
|
