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 for Patients Marked as Deceased

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

4 Posts

3 Users

0 Reactions

101 Views

RSS

Palko

(@palko)

Posts: 132

Estimable Member

Topic starter

We have a situation where 2 patients were marked as deceased by someone in the db and do not know how to audit this information. Patients are not deceased. This apparently comes from the DATEOFDEATH column in the PERSON table and we need to figure out who did this. Any help is greatly appreciated.

Posted : September 7, 2016 5:03 am

tpierson

(@tpierson)

Posts: 10

Active Member

There may be a clue in the activity log in the patient's registration form. Look either under the "Historical Data" tab or select VIEW > Activity Log. I can see who last changed the registration data, but in my system I don't know if it was the person who clicked "Deceased" in the patient status field in the patient's registration.

Tim

Posted : September 8, 2016 7:08 am

Palko

(@palko)

Posts: 132

Estimable Member

Topic starter

Thanks Tim. We are not on CPS. I am familiar with this in that version. We are on EMR only 9.8.12.

Posted : September 8, 2016 7:31 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

I marked a patient deceased in my CEMR Evaluation install and the only thing that showed up in the Audit report was accessing a normal chart. I looked at the PERSON table for the patient and in this case, the DATEOFDEATH field was the same as DB_UPDATED_DATE, so I know it probably wasn't updated after I had done the update by marking the patient's status as Deceased. The USRID field in the PERSON table is the person who last updated the record. It is the PVID from the USRINFO view, if that helps any.

Posted : September 8, 2016 2:06 pm

Share:

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