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

Data change logs

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

5 Posts

3 Users

0 Reactions

71 Views

RSS

rcarolus

(@rcarolus)

Posts: 14

Eminent Member

Topic starter

Is there a log in the database where I can see the values that have changed? I need to know who changed it, when it changed, what column was changed, the old value, and the new value.

Does this exist in the DB?

Posted : June 19, 2017 7:27 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

If you are referring to changes that happened in a chart note, you can use the DOCCONTB table which gives you all of the information listed other than the "column". I don't think something like this exists within the DB but I could be wrong.

If you are looking for a DB answer, it might be helpful if you specified your DB vendor. Your profile says you have both CEMR and CPS/PM, and one runs on Oracle and the other MSSQL.

Posted : June 19, 2017 11:44 am

rcarolus

(@rcarolus)

Posts: 14

Eminent Member

Topic starter

We're using MSSQL.

I would really like to know if an old value / new value log exists. I hope so!

Thanks.

Posted : June 20, 2017 1:09 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

If you are referring to chart updates, like I said, you need to look at the DOCCONTB table.

Posted : June 20, 2017 1:38 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

SQL Server does have some ability to do some auditing but it isn't anything that is turned on by default. Your DBA would have had to enable it. Would probably make a Centricity DB get quite large. You can also view inside the chart by right-clicking on a document and viewing View Contributors List. Same info as the previously mentioned DOCCONTB table but there isn't going to much there if didn't have auditing turned on inside Centricity.

Posted : June 20, 2017 12:00 pm

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