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

Custom script - pharmacy cleanup

Archive

Last Post by Anonymous 11 years ago

2 Posts

2 Users

0 Reactions

79 Views

RSS

dgoldsmith

(@dgoldsmith)

Posts: 38

Trusted Member

Topic starter

We are in the process of upgrading our EMR and implementing Kryptiq's eprescribing. As part of the prep, we're instructed to cleanup the pharmacy list. However, our pharmacy list is a mess. Instead of trying to clean it up by merging the pharmacies, etc., I would like to essentially start clean by deleting all pharmacies and pharmacy links to patients. Then I'd like to import the portion of surescript pharmacies that apply to our region and move forward. Has anyone done something similar? Does anyone have a script that could do this (delete the pt connection to pharmacies and then delete the pharmacies), or know of anyone that could create one. GE has indicated they cannot do it.

We are currently on the Oracle platform, but we're moving to SQL Server. We're upgrading & migrating first and then implementing eRx. So, most likely, the script would need to work with the sql server schema.

Thank you,

Diane Goldsmith

Somerset Family Practice

Clinical Systems Analyst

110 Rehill Avenue

Somerville, NJ 08876

[email protected]

908-685-2200 x3994

Posted : July 24, 2013 6:34 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

I could see deleting all the pharmacy's via SQL, but I haven't seen how to "bulk" load pharmacies from Kryptiq, so that would have to be investigated.

Also, keep in mind pharmacies are linked to patients, so if you nuke the list, you have to account for re-adding to each patient chart, and I'm not sure how that might change the medication/refill history view.

Posted : August 7, 2013 4:56 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 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