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

audit of change to patient status

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

6 Posts

2 Users

0 Reactions

120 Views

RSS

kalevine

(@kalevine)

Posts: 70

Estimable Member

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

mikeseale

(@mikeseale)

Posts: 344

Reputable Member

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

kalevine

(@kalevine)

Posts: 70

Estimable Member

Topic starter

Thank you very much. That is most helpful!!!

Posted : October 23, 2017 8:47 am

kalevine

(@kalevine)

Posts: 70

Estimable Member

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

mikeseale

(@mikeseale)

Posts: 344

Reputable Member

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

kalevine

(@kalevine)

Posts: 70

Estimable Member

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

Share:

24 Forums
9,940 Topics
39.9 K Posts
2 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