140 likes | 161 Views
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
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