I absolutely need access to the DATA that is in the database. The reporting capabilities of AC are OK, but the implementation is very limited, and, shall we say, quirky.
For instance, I can search for certain lab results, such as hemoglobin A1c. I have to indicate a value of the result to filter on in order for the search to work (for instance I can search for all hemoglobin A1c results. But in order To do so I have to put in "look for a result say greater than 0.1, a nonsense number), in which case I get the results for all determinations) however the report has no indication as to the date of that lab draw. There are numerous other examples as well where the date of either the note or the result or the medication or the order is not available in the report when it is run.
I have no desire in any way, manner, or form to add to, or change the database. But I really do want to get my hands on the data.
I've had to create an interface that captures the inbound laboratory HL-7 files prior to upload through the interface to amazing charts, parses the files, and put the results in an Access database for my reporting purposes.
We asked for access to the database once upon a time. I will try to do so again.
