Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

add an OBS term to 12k patients

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

7 Posts

4 Users

0 Reactions

91 Views

RSS

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

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

jsander

(@jsander)

Posts: 108

Estimable Member

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.

hl7message_Populate_Obs

Posted : February 3, 2016 4:12 am

Marketing Committee

(@marketing_committee)

Posts: 358

Reputable Member

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

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

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

DavidShower

(@davidshower)

Posts: 1255

Noble Member

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

Marketing Committee

(@marketing_committee)

Posts: 358

Reputable Member

Thanks great on the matching. I think HL7 is the way to go for this.

Posted : February 4, 2016 4:56 pm

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

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

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0