Cox approached us in November to begin working on merging their portal’s old information with their updated Cerner System. Of course, we were eager to sink our teeth into this project.

We are proud to announce that, after only a few minor setbacks, we were able to complete the project and deliver code that would meet their needs. Here is a small list of a few features we added for them:

  • Merged medications from Cerner with Centricity data
  • Displayed the medications in a rad grid
  • Developed a new call for processing renewals and deactivation requests

The tricky part of this project was in getting the correct information out of Cerner so that it could be easily merged with the Centricity data. We were able to write a few stored procedures that used OpenQuery to call a linked Cerner server (thus mixing Microsoft SQL with Oracle) to get the data we needed.

We’re glad we can put this project to bed, and look forward to additional projects with Cox in the future.