Notifications
Clear all
Topic starter
Has anyone developed a script/report that shows "who" added a pharmacy through Registration. I often send reminders for staff not to enter pharmacies through Registration but it is still being done.
Posted : August 18, 2016 2:10 am
Christine,
we do not have a report, but here is the SQL query that can be run against the database to pull this information:
SELECT dbo_PatientRelationship.LastModified, dbo_PatientRelationship.LastModifiedBy, dbo_PatientProfile.PatientId, dbo_PatientProfile.First, dbo_PatientProfile.Last, dbo_PatientRelationship.Description
FROM dbo_PatientRelationship INNER JOIN dbo_PatientProfile ON dbo_PatientRelationship.PatientProfileId = dbo_PatientProfile.PatientProfileId
WHERE (((dbo_PatientRelationship.Description)="Pharmacy"))
ORDER BY dbo_PatientRelationship.LastModified DESC;
The query above will return all of the events related to adding or modifying a pharmacy during patient registration in descending order (i.e. the most recent events will be at the top of the list). The patient name and user account that made the change/addition is also provided.
You could run this query against your database in SQL server or build a custom report in Crystal Reports or MS Access based on the query logic above.
Posted : August 18, 2016 5:23 am
Topic starter
Thank you VirtualHITman! I will definitely try this.
Posted : August 18, 2016 6:33 am
Do you have a version that works with Centricity EMR (Oracle)? We are on EMR 9.8.11.
Posted : August 19, 2016 6:13 am
Christine, I responded to an email from someone else on your team (Scott Clayton) about that. I instructed him to remove the schema prefix "dbo_" occurrences in the above script and try it again. Not sure what the outcome was. If that doesn't work, I'd be happy to connect with you guys offline and take a look at it with you. Just shoot me an email to let me know how you would like to proceed.
Posted : August 19, 2016 6:28 am
I don't think you can get this information in CEMR. The pharmacy information is kept in the BUSINESS table and it looks like there isn't a field with an identifier on who added/modified, just a datetimestamp. The relationship of the patient to the pharmacy is kept in the RELBUSS table
Posted : August 23, 2016 1:00 pm
