We went through the same thing here at Children’s, and it’s only worked out for us because we changed practice management vendors.
When we were sending coverages one-way to IDX through our old engine (Cerner OpenEngine Classic), we had to do it via translation proc that was basically a huge switch statement to translate the hospital payor/plans to practice payor/plans. Hopefully someone here gives you a more reasonable solution.
Our new practice management vendor (Epic) maintains the translation values within the payor/plan master files and the external values are looked up as the transaction is filed. So, in our case, it ends up being maintenance for our Applications Team and not the Integration Team.
