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

Unsigned observation value

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

14 Posts

7 Users

0 Reactions

87 Views

RSS

ken.takenaka

(@ken-takenaka)

Posts: 212

Reputable Member

Topic starter

I am trying to pull an unsigned value for an observation term from one update into another. Is this possible? I thought using LASTOBSVALUE but I am not able to pull it.

Posted : May 17, 2017 10:21 am

dcarpenter

(@dcarpenter)

Posts: 323

Reputable Member

If a document is opened and has Obs terms, but is not signed, then no other document has access to those terms. It has caused some headaches for us as well, but we changed our workflows to minimize this happening. now it is a once in a blue moon problem. :/

Posted : May 17, 2017 10:45 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

Only signed values from previous visits can be retrieved via MEL, not unsigned.

Posted : May 17, 2017 10:48 am

ken.takenaka

(@ken-takenaka)

Posts: 212

Reputable Member

Topic starter

I was afraid that would be the answer 🙂 / 🙁

Posted : May 17, 2017 10:50 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

....not via MEL, but a SQL query can be executed against the database to retrieve the value. This is not trivial but doable. Contact me directly if you would like to see this approach.

Posted : May 17, 2017 10:53 am

amaskey

(@amaskey)

Posts: 88

Estimable Member

LIST_OBS(obsTerm, "Pencil", "","") return all obs including unsigned but you will have to loop through the result to get the unsigned value.

Posted : May 17, 2017 12:45 pm

ken.takenaka

(@ken-takenaka)

Posts: 212

Reputable Member

Topic starter

Pencil will give you unsigned observation values, but only from within the same update.

Posted : May 18, 2017 3:40 am

amaskey

(@amaskey)

Posts: 88

Estimable Member

In that case you might have to go to the database. There might be something in meldef files to access database

https://centricityusers.com/forum/old-obs-and-assessment/

Posted : May 18, 2017 2:25 pm

DavidShower

(@davidshower)

Posts: 1255

Noble Member

You can use the _MelCurObs object from the mldef files to retrieve obs dated after the update was started/in another update.

Posted : May 19, 2017 12:21 pm

gibsonmi

(@gibsonmi)

Posts: 827

Prominent Member

I think this is the right answer. There are a few different meldef objects you can use to the pull the data. We have done it successfully for years. You have to loop through the rows though and if you don't exit your loops when you should it can slow down your encounter a lot, like 20-30 seconds for larger charts.

You could also use sql for a more direct lookup, that's what we do now. If you are interested in learning how that could work check out my product in the marketplace.

Posted : May 22, 2017 5:06 am

jwoods

(@jwoods)

Posts: 3

New Member

is there then a away to sign the obs value without signing the visit?

Posted : September 7, 2017 7:57 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

End the update and when putting it on hold, check the box for signing the clinical list changes.

Posted : September 7, 2017 8:04 am

jwoods

(@jwoods)

Posts: 3

New Member

I thought that too, but that's not working.

Posted : September 7, 2017 8:07 am

ken.takenaka

(@ken-takenaka)

Posts: 212

Reputable Member

Topic starter

Unfortunately no. Even by signing the clinical list changes in an update, it does not populate into the flowsheet until the document has been signed.

Posted : September 7, 2017 8:56 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