Notifications
Clear all
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
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
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
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
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
