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

CAREPLAN_GOAL_LIST() pulling only specific data

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

5 Posts

2 Users

0 Reactions

111 Views

RSS

tosh

(@tosh)

Posts: 51

Trusted Member

Topic starter

Greetings,

The issue: We want to be able to print the active Care Management Goal List for parents/children who visit. But we don't want to have to sign clinical list changes or sign the note for the goals to show. Currently, the updated goals will not show in the histories until signed. We want to move away from this.

Looking at the text translation file, they have CAREPLAN_GOAL_LIST() to show the changes in the chart.

I want to add CAREPLAN_GOAL_LIST() to my letter so that it shows the updated goals that were made in the visit. This way, we can print a letter with the updated goals and hand to the parent before they finish the note.

We are pediatrics, and we need to be sensitive with the wording.

If I simply use CAREPLAN_GOAL_LIST()

it will show:

Changed Goal: child will remain safe and refrain from causing harm to self or others
Associated Problem: Anger ( R45.4 ), Major depressive disorder, single episode, severe with psychotic features ( F32.3 )
Health Concern: behavior
Status: Active
Start Date: 07/09/2020

Added Intervention: test 7.8.21
Goal Name: child will remain safe and refrain from causing harm to self or others
Status: Active
Start Date: 07/08/2021

I want to change this to where it says "Diagnosis" instead of "Problems"

Honestly, I don't even want to show that. I would like for it to just show just the second paragraph that says "Added Intervention: test 7.8.21
Goal Name: child will remain safe and refrain from causing harm to self or others
Status: Active
Start Date: 07/08/2021"

That is all!

But I can't seperate this.

Does anyone know how to work this CAREPLAN_GOAL_LIST() ?

THanks,

Tosh

Posted : July 8, 2021 4:49 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

You could try this:

sub(CAREPLAN_GOAL_LIST(),match(CAREPLAN_GOAL_LIST(),"Added Intervention"))

Posted : July 13, 2021 4:46 am

tosh

(@tosh)

Posts: 51

Trusted Member

Topic starter

It worked T_T

I'm crying because I am so happy.

Posted : July 13, 2021 5:04 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

Awww, always happy to help you out 🙂

Posted : July 13, 2021 5:19 am

tosh

(@tosh)

Posts: 51

Trusted Member

Topic starter

There is also (replacestr(CAREPLAN_GOAL_LIST(),"Problem","Diagnosis"))

This will keep the original format, but change the insensitive language.

Posted : July 13, 2021 6:22 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