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

Is there a way to have a document variable go to two separate obs terms? Or assign a value from one obs term to another?

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

6 Posts

4 Users

0 Reactions

85 Views

RSS

hintona

(@hintona)

Posts: 36

Trusted Member

Topic starter

Is there a way to have a document variable go to two separate obs terms? Or assign a value from one obs term to another? Here's the debacle: We have two separate forms that are collecting a date as an observation value for what is ultimately the same thing, but they were inadvertantly set to go to two separate obs terms. Both obs terms have a ton of patients that have data going to them, so clean up would be a nightmare.
I know that I can assign a variable to another variable with this: {DOCUMENT.VARIABLE1 = DOCUMENT.VARIABLE2}, but it doesn't appear to work with obs terms replacing the variables.

Any other thoughts on the best way to handle this?

Posted : January 7, 2016 2:51 am

gibsonmi

(@gibsonmi)

Posts: 827

Prominent Member

You could do


{OBSNOW("OBSTERM1",OBSNOW("OBSTERM2"))}

Or...


{OBSNOW("OBSTERM1",DOCUMENT.VARIABLE1)}

{OBSNOW("OBSTERM2",DOCUMENT.VARIABLE1)}

Good Luck!

Posted : January 7, 2016 4:11 am

hintona

(@hintona)

Posts: 36

Trusted Member

Topic starter

I used option 2! Thanks so much Michael!

Posted : January 7, 2016 5:30 am

gpincomb

(@gpincomb)

Posts: 278

Reputable Member

I know that you said clean up would be a nightmare, but have you considered doing clean up with an SQL script? I have moved more than one set of values from one Obs Term to another Obs Term and we have a 600 GB database and it processes real quick.

update o

set o.HDID = '22766'

from OBS o

where o.HDID = '70586'

I just placed in 2 numbers at random, but the 22766 represents the HDID of the Obs Term you want to move all of your values to and the 70586 represents the HDID of the Obs Term you want to move the values from.

Posted : January 7, 2016 5:45 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

The first approach is the simplest and safest. You must be very comfortable executing an update query on your production data base, and if you are very conservative, create a backup of the database, execute the query in off hours. In any event, ....... the key is to change your obs terms to a single term.

Posted : January 7, 2016 6:21 am

hintona

(@hintona)

Posts: 36

Trusted Member

Topic starter

Thank you, all, I appreciate the help! I will talk to my director about the clean up option, but for now, I've at least got the value going to both obs terms. 🙂 Thanks again!

Posted : January 7, 2016 6:27 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 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