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

New Service Provider Entries Overwriting Old Entries

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

3 Posts

2 Users

0 Reactions

70 Views

RSS

vrdlc

(@vrdlc)

Posts: 135

Estimable Member

Topic starter

This isn't a question as much as documentation that this issue took place. If anyone has any experience with this, please let me know! It's pretty serious!

Last week, we had to add new outside service providers and organizations to our list. This is a pretty standard task, done in Administration. All new providers were entered using the various layers of "New" buttons.

Later that day, we received a call from someone that said that the service provider listed in old orders had changed to one of the names that we had just entered in. This order was from 2018, so there was no way that was possible.

Upon further investigation, we discovered three things:

The new Service Providers entered into the SERVPROV table had overwritten string values while keeping the same primary key ID. Instead of an INSERT statement, Centricity seemed to have run an UPDATE statement.
New entries into the SERVPROVORG table didn't overwrite old values, but instead changed the BISID (which connects tot he SERVPROVID in the SERVPROV table), which caused the order to be filed under a person, not an organization. Looking in Administration however, we were unable to see this connection. We only saw it in the database.
Orders that had long ago been signed and completed had their service provider data changed. That means that those chart documents are pulling live data. That's insane. This also means that we can never, ever remove an entry from the Service Provider list, because that will cascade through any order that that provider was sent.

Has anyone seen this before? I called our vendor and they weren't able to find any record of this happening before. Is this user error? Could we have messed something up in the entry that caused this issue? I wouldn't even mind it being my fault if it means there's an explanation!

Posted : November 25, 2019 6:55 am

aroberts

(@aroberts)

Posts: 176

Reputable Member

Yes- this is a table look up so if you change the service provider instead of adding a new, it does change the order if on admin hold or in process even though it is signed. If the order gets completed in the status, it shouldn't change though. Are you completing your orders (not signing them but completing them)?

Posted : November 25, 2019 7:23 am

vrdlc

(@vrdlc)

Posts: 135

Estimable Member

Topic starter

In our panic, we misread what was going on. You're right: once the order is marked Complete, new data doesn't pull into that field. We, unfortunately, do not tend to mark orders complete very well... Hence our confusion on that point.

Thanks!

Posted : November 25, 2019 9:42 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