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

Obsterm timestamp

MU, CQR, PQRS, etc.

Last Post by Anonymous 1 second ago

6 Posts

3 Users

0 Reactions

55 Views

RSS

cmahon

(@cmahon)

Posts: 111

Estimable Member

Topic starter

Is there anyway to see the time an obsterm was populated? I know the obsterm date/times default to the time the visit is opened, but is there a way to see the exact time the field was populated?

Posted : January 2, 2018 2:58 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

You could look at the DB_CREATE_DATE or DB_UPDATED_DATE in the OBS table in the database. Or, if you have clinical auditing turned on you could right click on the document and look at View Contributors List.

Posted : January 2, 2018 4:06 am

cmahon

(@cmahon)

Posts: 111

Estimable Member

Topic starter

Thank you David! I will look into that 🙂

Posted : January 2, 2018 6:50 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

Your profile says that you use CEMR (Oracle) so I can provide you with an oracle example. If you are on CPS/MSSQL let me know and I can make some changes to the code.

If you are comfortable with SQL you can use the OBSID column. It is a ge emr timestamp field but any ge timestamp field can be converted to a date. The below SQL should pull all of the WEIGHT obs values for the patientid 123456 along with the date they were entered. The sql query was written from memory and not tested as I am not currently connected to an EMR database at home.

select ml.convert_id_to_date(obs.obsid) obs_entered, obshead.name obsname, obs.obsvalue from obs inner join obshead on obshead.hdid = obs.hdid inner join person on person.pid = obs.pid where person.patientid = '123456' and obshead.name = 'WEIGHT' and obs.change = 2

Posted : January 2, 2018 2:58 pm

cmahon

(@cmahon)

Posts: 111

Estimable Member

Topic starter

Thank you so much! I do have EMR so I will definitely test this SQL query.

Thanks for your help

Posted : January 3, 2018 8:11 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

If you are like our clinic, we use EXTERNALID instead of patientid so our where clause would have something like this instead

PERSON.EXTERNALID = '123456789'

I tested the query just now and it works.

Posted : January 3, 2018 8:15 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