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 log

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

4 Posts

2 Users

0 Reactions

61 Views

RSS

sharansunkara

(@sharansunkara)

Posts: 83

Estimable Member

Topic starter

Hello Everybody,
Is there a query i can run in SQL for an Audit trail for one of our providers? He is claiming that he finished the HPI and ROS for a patient but its not showing up on the note and I looked in Contributors List and it didn't look like he even started the HPI or ROS. So i wanted to double check in SQL.

Posted : February 25, 2016 5:19 am

acantu

(@acantu)

Posts: 722

Prominent Member

Is the note signed or unsigned?

Posted : February 25, 2016 5:32 am

sharansunkara

(@sharansunkara)

Posts: 83

Estimable Member

Topic starter

Its signed.

Posted : February 25, 2016 5:34 am

acantu

(@acantu)

Posts: 722

Prominent Member

The only thing you can really do it look at the OBS table, which stores the data for HPI and ROS, depending on what form you used (CCC or Custom) and what OBS Term was used. There will be a few things you will need:
1. SDID - this is a unique ID for the document in the DOCUMENT table for the Chart Note in question.
2. HDID - this is a unique ID for the OBS Term that the data was stored into.

To get the SDID, you can run the following: Input the patient id where stated

SELECT * FROM DOCUMENT WHERE PID = (SELECT PID FROM PatientProfile WHERE PatientId = 'INPUT PATIENT ID HERE') AND STATUS = 'S' ORDER BY dbo.Convert_ID_to_date(CLINICALDATE) DESC

Search through the records using the VISDOCID to match the one in the chart. Once you got the SDID, you now need the HDID, hopefully you know what OBS term is being used for those records. Run this script to see the data that was signed off:

SELECT * FROM OBS WHERE SDID = 'INPUT SDID HERE' AND (SELECT COUNT(*) FROM OBSHEAD WHERE HDID = OBS.HDID AND NAME = 'INPUT OBS TERM HERE') > 0

or you can just run this to see everything that had been saved into the OBS for that document:

SELECT (SELECT NAME FROM OBSHEAD WHERE HDID = OBS.HDID) AS OBSTERM, OBS.* FROM OBS WHERE SDID = 'INPUT SDID HERE'

if you need anymore assistance, please let me know.

Posted : February 25, 2016 5:50 am

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