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

Link OBS table to ORDERS Table

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

6 Posts

3 Users

0 Reactions

51 Views

RSS

rdritchie

(@rdritchie)

Posts: 8

Active Member

Topic starter

I am trying to run a SQL query that will allow me to grab any OBS values for a given time frame based on Visits. I use VISITS as my starting point. I had been able to join OBS based on PID and OBSdate to PID and Visitdate. This seemed to be working great until it relates to Tests. Because they may come back with a different OBSdate than the original Visit. I believe there is a way to use the DOCUMENT table in order to join them and get the result I am looking for. So far I have not had any luck. For full disclosure, I am by far a SQL expert, more of a novice. Any insight would be greatly appreciated. I can provide a sample of my Query if that would help.

Thanks,

Don

Posted : February 11, 2015 12:01 pm

acantu

(@acantu)

Posts: 722

Prominent Member

You can use the SDID column, which will link to your DOCUMENT table's SDID

Posted : February 11, 2015 12:03 pm

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

This will get you started.

Posted : February 11, 2015 1:03 pm

rdritchie

(@rdritchie)

Posts: 8

Active Member

Topic starter

Thank You for the responses and both of these work with the exception that the SDID from ORDERS to DOCUMENT can change if the DOCUMENT comes back at a later date.

For Example: I have an office Visit on 3/10/14 SDID:*7760 (I shortened the number for ease). Associated with this office visit is a Lab order on 3/10/14 SDID:*7760.

Now is where my confusion comes in. The Office Visit DOCUMENT SDID is *7760, so yes it links easily, but the LAB SDID is *8180 because it came back on a different date.

Then both SDID #'s link to the OBS table records with their associated SDID's. My question is how do I get the Labs to link back to the original order since they have different SDID and DATES associated with them. Maybe I am over thinking the issue. Any help would be appreciated.

Thanks,

Posted : February 13, 2015 4:22 am

acantu

(@acantu)

Posts: 722

Prominent Member

Really, the SDID should never change if it came from that DOCUMENT. That is how it is linked to that DOCUMENT. And the OBS Table's SDID should also be the same as the DOCUMENT SDID. If they are Lab orders Results, you are talking about, then those do not link directly to your DOCUMENT as usually they create their own NEW DOCUMENT when the DTS imports them in.

Posted : February 13, 2015 4:25 am

rdritchie

(@rdritchie)

Posts: 8

Active Member

Topic starter

acantu - Thank You, that is where I was over thinking it. I was so focused on getting the dates to match up. When all I have to do on my filters is key on the OBSdate instead of the visit date. Thanks for all of the help.

Posted : February 13, 2015 5:22 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