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

Searching for a Pharmacy Script/Report

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

6 Posts

4 Users

0 Reactions

67 Views

RSS

cjames

(@cjames)

Posts: 58

Estimable Member

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

virtualHITman

(@virtualhitman)

Posts: 319

Reputable Member

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

cjames

(@cjames)

Posts: 58

Estimable Member

Topic starter

Thank you VirtualHITman! I will definitely try this.

Posted : August 18, 2016 6:33 am

vsokoln

(@vsokoln)

Posts: 35

Eminent Member

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

virtualHITman

(@virtualhitman)

Posts: 319

Reputable Member

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

DavidShower

(@davidshower)

Posts: 1255

Noble Member

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

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