We have a provider, let's say Dr. Test that is in the TW provider dictionary. This provider worked at our clinic. Then, left to go work at a hospital that we interface with. Let's say the hospital provider's name is Dr. Test - MPS. In TW provider dictionary would have the following entries:
EntryCode IsInactiveFlag NPI
2076 N 1234567890 This would be Dr. Test
2094 N 1234567890 This would be Dr. Test - MPS
We have to leave both of these active for 90 days in case a result comes back that was ordered before Dr. Test left the clinic. In this case the result should get tasked to the provider code of 2076 (Dr. Test). The script looks for active providers in the TW Provider SQL table based on the NPI. It just returns the top 1. Due to this issue the task goes to the wrong provider (2094 - the new code).
Has anyone encountered this issue? Any suggestions on how to fix this?