Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

SQL Stored Procedure results in Patient Banner

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

4 Posts

4 Users

0 Reactions

79 Views

RSS

AChess

(@achess)

Posts: 4

Active Member

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

cliffstark

(@cliffstark)

Posts: 194

Reputable Member

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

dvdgnzlz

(@dvdgnzlz)

Posts: 17

Active Member

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

virtualHITman

(@virtualhitman)

Posts: 319

Reputable Member

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

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0