Contents 1 Hospital and Medical Facility Status Management 1.1 Owner 1.2 Summary 1.2.1 Use Cases/User Stories/Scenario 1.3 Description and Constraints 1.4 Extra Credit 1.5 Resources 1.6 What’s Next and Sustainability 1.7 Current State and Solutions

[edit] Hospital and Medical Facility Status Management

[edit] Owner

Proposed by: Sahana Software Foundation

Contact: Mark Prutsalis, mark@sahanafoundation.org, irc #sahana on freenode nick: mprutsalis; IM: globaliist@gmail.com; skype: mark.prutsalis

Best way and times to contact during RHOK 2.0: e-mail, IRC, IM, Skype chat

[edit] Summary

To enable integration and interoperability between and Google's Resource Finder and standards-supporting systems like the Sahana Eden Hospital Management System (HMS).

[edit] Use Cases/User Stories/Scenario

• need to better track hospital information in Haiti, with a particular emphasis on being able to know which medical facilities are capable of providing treatment and care for cholera.
• need additional ability to track availability and need for antibiotics (in adult doses) and infusion supplies (in liters) per hospital (these are used in the treatment of cholera) within Resource Finder and Sahana Eden.
• need to easily identify those hospitals and medical facilities that can provide treatment and care for cholera victims from those that can not.

[edit] Description and Constraints

Sahana Eden’s Hospital Management System (HMS) was designed around the open EDXL-HAVE standard.

Google Resource Finder is not currently able to produce a standards-compliant feed of its data or to consume data provided to it via EDXL-HAVE or any other existing standard beyond a csv export (which is not currently working). To be able to pass data between Sahana Eden and Google Resource Finder, the following approaches might be attempted:

• an API for Google Resource Finder
• fix the csv export of Resource Finder data
• a fully EDXL-HAVE-compliant bi-directional feed from Resource Finder
• use of Tablecast to exchange data between RF and Sahana Eden and other sources of hospital's data
• use of spreadsheet importer tool from this past summers GSOC project to bring data into Sahana Eden from a fusion table, another spreadsheet or Google Resource Finder.
• Cholera care should be able to be covered by the Service Coverage Status element within EDXL-HAVE with limited difficulty (under infectious disease)..

A Google fusion table has been created with the data elements from the Travax system. (note: an updated table is now available with the MSPP and P-Code fields broken off into separate columns: Updated Google Fusion table) To this should be added the unique elements contained within the Sahana Eden HMS application as well as a review of Resource Finder (csv export currently failing) so we can begin to look at the commonalities and differences and provide a means to easily map the data. Note that the Health ID field contains two distinct unique ID elements that need to be parsed into separate fields. The first (prefixed by an “H: “) is the unique ID assigned by the Haitian Ministry of Health (MSPP); the second (prefixed by a “P: “) is a UN-assigned P-code. This information needs to be put into different fields without a pre-cursor such that they can function as a true unique identifier for the synchronization of data between different systems. It has been suggested that Refine can fix up data like this quickly and easily.

[edit] Extra Credit

Create full bi-directional synchronization of data between Resource Finder and Eden using EDXL-HAVE and/or APIs that allows for full REST and CRUD capabilities.

[edit] Resources

Google Resource Finder:

• Code: http://code.google.com/p/resourcefinder/
• User Help and Instructions: http://haiti.resource-finder.appspot.com/help
• Resource Finder discussion forum: https://sites.google.com/site/resourcefinderdiscussion/
• Pakistan Resource Finder (LIVE SITE): http://pakistan.resource-finder.appspot.com/
• Haiti Resource Finder (LIVE SITE): http://haiti.resource-finder.appspot.com/
• Fusion Table of Haiti Resource Finder Data: http://www.google.com/fusiontables/DataSource?snapid=109868
• Google Refine: http://code.google.com/p/google-refine/

Sahana Eden Hospital Management System:

• User guidelines and instructions: http://eden.sahanafoundation.org/wiki/UserGuidelinesHMS
• Demo/testing site: http://demo.eden.sahanafoundation.org
• Sahana Eden wiki: http://eden.sahanafoundation.org/wiki
• Sahana Eden code: http://launchpad.net/sahana-eden

EDXL-HAVE 1.0 standard: http://docs.oasis-open.org/emergency/edxl-have/v1.0/errata/edxl-have-v1.0-os-errata-os.html

Tablecast:

• Home Page: http://www.tablecast.org
• Draft Specification: http://tablecast.org/draft-0.1
• Working Group: http://groups.google.com/group/tablecast

Shoreland’s Travax System: https://www.travax.com/scripts/haitiaid/default.aspx?show=true

[edit] What’s Next and Sustainability

Code changes should be submitted to the Google Code site that hosts Resource Finder.

[edit] Current State and Solutions

The requirements have already been implemented (or are in progress of being implemented) within Sahana Eden, such as a simple checkbox to track hospitals with cholera care units has already been added to the codebase as a draft implementation. (see [sample screenshot] and [sample kml feed]). The service indicator for "infectious disease" is already contained in the Eden HMS and EDXL-HAVE, and for now, this additional resource is shared via EDXL-HAVE's resource availability elements as well as the kml feeds for easy mapping. This could be used for tracking the cholera treatment centers with some additional coding to make it functional as described. URL queries that differentiate between those facilities with a cholera treatment center and those without, using and generating an EDXL-HAVE or kml feed out of that query can be used for mapping purposes within or outside of Sahana Eden.