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

Report for Letters from print button

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

3 Posts

3 Users

0 Reactions

83 Views

RSS

gtr9675

(@gtr9675)

Posts: 34

Trusted Member

Topic starter

Has anyone build a report or have a report that can tell us how many times users have printed out the letter/

Posted : May 16, 2019 1:49 am

jbarta

(@jbarta)

Posts: 12

Active Member

I have not attempted this type of report before, but I was able to jump in and look at the AUDIT tables in the database and pull a query that might get you started on creating one. This is how I found them in our database using the AUDIT_EVENT, AUDIT_PROFILE, and AUDIT_EVENT_DETAIL tables. Give this a try. You can also find the patient the letter was printed for by joining the PatientProfile table using the PID in the AUDIT_EVENT table; I just didn't add that to the query. I only queried for letters printed after the beginning of this month. Hopefully this helps get you started.

Select ae.*
,ap.LOGINNAME
,ap.OS_USER_NAME
,adl.EVENT_VALUE_1 AS LetterName
From AUDIT_EVENT ae
LEFT JOIN AUDIT_PROFILE ap ON ae.PROFILE_ID = ap.PROFILE_ID
JOIN AUDIT_EVENT_DETAIL adl ON ae.EVENT_ID = adl.EVENT_ID AND adl.EVENT_PARAM = 'Report Description' AND adl.EVENT_VALUE_2 = 'Chart/Letters'
WHERE CAST(EVENT_TIMESTAMP AS DATE) >= '2019-05-01'
AND ae.EVENT_TYPE_ID = 111

Posted : May 16, 2019 3:38 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Here is a Crystal Report I use to find all Letters. If you are looking for only certain letters, you could add that logic. NOTE - it does not check if printed, only who has created the Letter. We thought about checking if something was printed, but then we still would not know if it was retrieved from printer, given/mailed to patient, etc...

Doc137 Letter Listing

Posted : May 16, 2019 6:58 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