Notifications
Clear all
Topic starter
I have a chart where the patient status is obsolete and I am trying to figure out who changed the status. Is there an event for this and, if so, why not? It seems like an important thing to know
Posted : October 23, 2017 2:21 am
No, I don't think there is an audit event for that action.
We ended up turning on Change Data Capture for several of our database tables (this one included) because the auditing in Centricity is fairly limited. This allows us to see any change, delete, or addition made via the application, 3rd party applications, or users scripting ad hoc queries.
Posted : October 23, 2017 8:24 am
Topic starter
Thank you very much. That is most helpful!!!
Posted : October 23, 2017 8:47 am
Topic starter
another question or two
When I try to activate this feature I get the following message
Lookup Error - SQL Server Database Error: This instance of SQL Server is the Standard Edition (64-bit). Change data capture is only available in the Enterprise, Developer, and Enterprise Evaluation editions.
Is there a way around this? I would expect that we would have the Enterprise edition or that at least all versions of CPS would have the same edition.
Is the generic audit feature of CPS customizable at all? If so, what have you customized? What have you added via change data capture?
Thanks!
Posted : October 24, 2017 3:27 am
There are many editions of SQL Server (standard, developer, enterprise, express, etc.), and you do need the enterprise edition to use CDC. I don't think GE requires you to have a certain edition for normal application use.
The only customizations that GE gives you are under Administartion>System>Auditing (Clinical) where you can choose which audit events to capture. These events should already be turned on, but if not, I would suggest you have them all turned on. I bit of caution if you aren't the one the manages Centricity performance and storage, though. These events will be logged in the AUDIT_EVENT table, and if they aren't all on now, you will start to see a big increase in size on that table. It also can cause the EMR to slow down because it will be logging many actions users do within the EMR. These can always be turned back off if you find the system to be too sluggish.
Posted : October 24, 2017 3:48 am
Topic starter
According to a help I read on the subject, it said you need to execute the following to enable change data capture, and it's when running this that I get the message below
EXEC sys.sp_cdc_enable_db
GO
SQL Server Database Error: This instance of SQL Server is the Standard Edition (64-bit). Change data capture is only available in the Enterprise, Developer, and Enterprise Evaluation editions. Perhaps there is another way to activate it or perhaps I don't have the permission needed
Posted : October 24, 2017 3:58 am
