Notifications
Clear all
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
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
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
