On Sun, 14 Mar 2004, Elpidio Latorilla wrote:
...
> But my original query was based on my wish to have a
> "behind-the-scene-app-to-app" dialog.
Elpidio,
What's the difference between an application talking to OIO vs. a human
user? :-)
...
> If I create an interface that wants to get a set of patient data stored in
> OIO, how should this interface do it?
1) query OIO's patient id module to obtain the patient's unique OIO id
2) query OIO's archived_forms table to retrieve table of contents of all
forms
2) query OIO's formname_values table(s) to retrieve data
> Does the interface need to query your database directly?
That's one way to do it. Or, you can submit a HTTP request and OIO can
return an XML document.
> If yes, how can I know the entity relationship?
The "entity relationship" takes only a few words to describe:
Each form is described by 2 tables:
formname_items: contains a list of questions
formname_itemtypes: contains a list of responses
Data collected via each form are stored in a formname_values table.
So, a progress_note form may have the following:
progress_note_items table
name | prompt | itemtype | ...
-------------------------------------------------------------
date | Visit Date | date
history | History | free_text
physical | Physcial Exam | free_text
assessment | Assessment | free_text
plan | Plan | free_text
billable | Billable Time | minutes
progress_note_itemtypes
date
text_box
minutes
progress_note_values
pt | date | history | physical | assessment | plan | billable
------------------------------------------------------------------------
123 |2004/3/1 | xyz | abc | pain | whatever | 25
456 |2004/3/2 | zyx | cba | flu | whatever | 45
> Could you kindly give me a link to the ER docs that might be relevant to
> patient data?
I hope the information above satisfies your needs. If not, please let me
know.
Best regards,
Andrew
---
Andrew P. Ho, M.D.
OIO: Open Infrastructure for Outcomes
www.TxOutcome.Org
