Notifications
Clear all
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
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
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...
Posted : May 16, 2019 6:58 am
