Notifications
Clear all
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
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
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
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
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
