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

GET_FLOWSHEET_VALUES for an OB flowsheet

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

5 Posts

3 Users

0 Reactions

109 Views

RSS

suefox51

(@suefox51)

Posts: 113

Estimable Member

Topic starter

Good morning all and Happy Holidays.
I'm trying to use the GET_FLOWSHEET_VALUES to bring in the values from our OB flowsheet into a letter. Not getting anywhere!
Can anyone shed some insight on how this works? I've placed the "flowsheet" into the Printing folder where it should be, but all I get is the MEL language when I preview my letter.

Thanks,
Sue

Posted : December 1, 2014 5:25 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Not sure what you mean by that function.

We utilize logic like the following to place OBS values in letters:
Cholesterol Tests
Cholesterol   {LAST_SIGNED_OBS_VALUE('cholesterol')}   {LAST_SIGNED_OBS_DATE('cholesterol')}
HDL (good chol)   {LAST_SIGNED_OBS_VALUE('hdl')}   {LAST_SIGNED_OBS_DATE('hdl')}
Triglyceride   {LAST_SIGNED_OBS_VALUE('triglyceride')}   {LAST_SIGNED_OBS_DATE('triglyceride')}
LDL (bad chol)   {LAST_SIGNED_OBS_VALUE('LDL')}   {LAST_SIGNED_OBS_DATE('LDL')}

Posted : December 1, 2014 6:11 am

suefox51

(@suefox51)

Posts: 113

Estimable Member

Topic starter

My issue is that they don't want just the last signed, they want ALL of the values!
Any ideas?

Posted : December 1, 2014 7:30 am

blackmanb

(@blackmanb)

Posts: 268

Reputable Member

Here is a way to do it..

1) You would need to call LIST_OBS(...) for each obsterm.
2) Also, since you are printing different obsterms,
it would be nice to have them lined up next to each other in columns. To do this, we can use MS Excel to create the MEL code in grids then copy and paste the excel table/grid into your EMR Letter Template.

Example: 2 obsterms WEIGHT and BMI

In excel column A, row 1 put the name of the obsterm: WEIGHT
In excel column A, row 2 put:
{LIST_OBS("WEIGHT","Signed","list","valuedate")}

For Column B put: BMI
{LIST_OBS("BMI","Signed","list","valuedate")}

Now you will want to format these so they show up nice in the letter
You can apply formatting to the obsterm names in row 1 (bold or underline)
then
Select the 2 rows and columns (only 2 not the whole line), right click and choose "Format Cells"
Select these values for the following Format tabs
Number: General
Alignment: [x] Wrap text You can choose what you like for text alignment
Font: whatever you like
Border: Choose 5: Top line, bottom line, left line, right line, center line. This creates the grid.
Fill: choose [No Color]
Select [OK]

Copy the 2 rows and columns only (not the whole line)

Open your Letter Template in Centricity and Edit it.
Paste in the excel grid.
Resize it to make the columns about the size of your expected data

Test this letter

My test letter looked like this:

- Beverly

Posted : December 1, 2014 9:05 am

suefox51

(@suefox51)

Posts: 113

Estimable Member

Topic starter

Beverly - thanks so much for that - I'm going to give it a try - what your letter shows is just what we are looking for.

Sue

Posted : December 2, 2014 4:05 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
2 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