Notifications
Clear all
Topic starter
I am very new to Centricity and MEL and I am hoping for some advice.
I have created a stored procedure on our Centricity SQL server. The stored procedure takes a single Patient PID and returns either 'high', 'medium', or 'low' by querying a custom View table.
Ideally I would like this stored procedure to run in the patient banner.
Does anyone have any general advice on how I should approach this?
Posted : June 11, 2018 9:12 am
The problem with the patient banner that comes with CPS is it can't be changed. You can make your own banner and use it but it's not the same as the default one. We've tried switching to a custom banner and using more functionality but always end up going back to the default because there are some things that just don't work correctly on custom banners.
Not sure that answers your question but just some info.
Posted : June 11, 2018 9:46 am
There are probably many ways to accomplish this, but have you looked at calling the stored procedure via a shell script? If that could work in your environment, you may want to look at the MEL data symbol RunTextProcess (which you can read about in the Centricity EMR help file). It can take the value returned from the shell script (i.e., stored procedure) and push it to an obs term (or some other place in the EMR where you can make use of it, if desired).
Posted : June 11, 2018 10:00 am
I'm in agreement with Cliff. I have found that your mileage varies when it comes to customization of the patient banner. I've seen it work fine for a while and then all of a sudden it will be blank for certain users. This is a known issue with banner customization and is still an issue as far as I know. Regardless, we had to revert back to the default banner for several of our providers because it was just too unreliable. I'm working on a custom banner in HTML that will display on all of our custom HTML forms. This approach works reliably but requires you to add this component to all of your custom forms. Of course you can't see this banner from the Chart Summary screen which appears to be what you are trying to accomplish. I suspect more options will open up when they move more to an HTML environment. I would like to see them make the banner an HTML encoded component. This would make CPS more extensible.
Posted : June 12, 2018 3:31 am
