140 likes | 162 Views
This research project focuses on transforming electronic medical records (EMR) systems by introducing a more user-friendly interface, enhanced database design, and improved text entries. The system utilizes open-source MySQL backend technology, implements a graphical user interface, and allows for efficient data entry through templates. The study explores various UI experiments, such as autocomplete features and PHP automation of template design. The goal is to create a modern and competitive EMR system by integrating a WYSIWYG editor for easy template creation and incorporating image upload capabilities for attaching scanned files.
E N D
Creating a Modern Electronic Medical Records (EMR) System TJHSST Senior Research Project Computer Systems Lab 2009-2010 Jeremy Chaikind Period 2
Introduction • Healthcare Reform – doctors have to change too • Paper charts → Electronic Charts • Electronic Medical Records – EMR • What's out there: • Constricting database designs • Text-heavy UI • Cost : ~$5000 – $15000 per physician
Mander EMR System • Open Source MySQL backend • ACID-compliant “transactions” • Highly expandable – Relational Model and Hierarchical Model • Graphical User Interface – browser based • Coded in HTML, CSS, Javascript, etc. • Graphical templates for data entry – based on paper templates • WYSIWYG use for text-based entry
Database Design • Relational Database Model • Data are divided into many specialized tables based on what set of attributes are stored • A single, unique ID # links all records for the same person
Templates Initially - Hard Coded template for Dr. Kern • Initially in hand-coded HTML, test inputs only
UI Experiments • Autocomplete • Compare with Practice Partners' “Quick Texts” feature • Begin typing and the program will read from the database and return the words that you could be typing
UI Experiments • JSON Autocomplete • Based on a set of functions by Jason Koenig (Pd. 5) • Implements Javascript Object Notation to return suggestions as an array • Enables better manipulation of returned data • Semicolon-spliced suggestions
Templates (again) • PHP automation of template design • Approximate a coding language for templates • Cleaner to read than hand-coded HTML • Easy use of tables for organization • Logical next step (after the school year): integration with a WYSIWYG to allow easy template creation
Templates (again) • The test: use the PHP library to create another template • Dr. Faye Rosenbaum, neurology • Tab-based vs. Table-based • Difference in Coding Time
Alternate Entry Modes WYSIWYG [what you see is what you get] using TinyMCE to allow formatted note entry Image upload for attaching scanned files
So What? • Is it ready to compete in the marketplace? • But: • Relational model/hierarchical model → greater expandability • GUI features like autocomplete • Graphical Templates – hand-coded to function-based • AND text-style notes • ?a modern EMR prototype