Notifications
Clear all
Topic starter
DB question here.
We just joined an ACO starting in January and we need a way to mark which patients (12,000 so far) are part of the ACO. We decided on an OBS term and I was about to add obs values to each of the patients charts in the list when I realized that OBS are linked to specific documents. These are values I would like to update on a quarterly basis. Will an OBS work if it is not attached to a specific document? Should I insert an entry into the DOCUMENTS table and use that to put the obs value in? If I do that I will also need to have an entry into the DOCDATA table.
Maybe I am approaching this all wrong. Perhaps I should have it dump an HL7 file to accomplish this? If so I am not sure where to start with it. I am thinking about grabbing a simple HL7 file out of linklogic and modifying the appropriate fields and trying that.
Posted : February 2, 2016 4:36 pm
I always create an HL7 file to put in obs terms. I got my hand slapped by GE once and was warned to stay out of the database or risk voiding our support agreement. I made a mistake and broke something once, too, so it's a good practice. 🙂 It's also good to have documentation for any changes to PHI. Here's an attempt to attach a sample Crystal Report.
Posted : February 3, 2016 4:12 am
HL7 would be the safest option but I don't see why this couldn't be done in the database. I think your biggest problem will be matching all the patients. On lists we get from insurance companies there are plenty of errors. LinkLogic can help with that though.
Posted : February 3, 2016 6:57 pm
Topic starter
My only issue with entering them directly is that I think I would also need to add a document for them and that goes a little beyond what I want to program for as I would have to add the document, record the SDID then add the obs to that SDID. I have inserted obs terms via sql before but they went to existing documents. (adding Mammo obs terms to existing mammo reports in the system)
The patient matching was not bad. Out of 11,800+ patients, less than 300 could not be matched on HIC Num and DOB combined. Of those 300, only 17 could not be matched on FNAME, LNAME, DOB. The lists are coming from medicare and the one piece of bad data they are sending on some accounts is the HIC number.(some of them start with a curly bracket "{") and are missing characters from the scanned in cards we have on file.
Posted : February 3, 2016 7:07 pm
If you have Qvera, that program can take a CSV and turn it into a batch of HL7 files. I don't know the mechanics of it but we do that here quite often.
Posted : February 4, 2016 12:28 pm
Thanks great on the matching. I think HL7 is the way to go for this.
Posted : February 4, 2016 4:56 pm
Topic starter
I ended up writing an hl7 interface in QIE for it. It was much easier than I anticipated. Part of the interface does a database query to try and find the patients externalid based on the values in the file.
Posted : February 11, 2016 10:34 am
