Displaying HED charted items on an iForm

[Joe Stark]

Does anyone know how to display HED charted values on an iForm via a label seq?

[Scott Morris FMC]

As I understand it, you can set up a new HEO Lab Concept (it was built for labs, but doesn't necessarily need to be a lab to pass), then tie your LABEL_SEQ(s) to the new lab concept and call it using the patient.lab_result methods.  What kind of thing(s) are you looking for?

[Joe Stark]

We are trying to display the LACE score on the discharge form. The LACE score is basically their chances for readmission. We have mapped the label seq to a lab concept but I am still getting None Available as a result.

 

[Scott Morris]

Since having posted the answer above, I've found out that there's an issue with the way that HEO builds these custom connections that requires you to make an update to the database (you need to update a field that's not available via the UI).

In the table CCDEV.FS_RESULT_MAP, the RESULT_LIST_PARAM needs to be set to 5; I believe by default it's left null.  If you're not able to (or not comfortable) with updating the database, you can likely have someone from McKesson do it for you.  (Make sure that it gets done in your toolkit/lconfig environment. If you only do it in train, it's likely to get overwritten during a release.)

[C.E. Coleman]

Does this same thing work when displaying previous orders on an iform?  I am having to create a DC for a certain set of orders and I need to display then existing orders in the iform and then allow a checkbox DC. I have run across this before and I think I can dc orders in the VGR, but not sure how to map existing orders into the iform itself. We do map some lab results and patient demographics in most forms.

C. E. Coleman

[Scott Morris]

No, mapping the lab concepts is a different "thing" than doing what's called "Active Order Awareness."  You can "get" information about active orders, but only if you know the OIS that you're looking for. As far as I know, there's no method to get "all active orders" into an iForm if that's what you're looking for, but if you know the OIS, you can check to see if there is an active order present and, once you've found it, you can D/C it via VGR.

[C.E. Coleman]

Arrggghhh..and they requested to show all the orders for a patient in a certain category (potassium orders) along with a checkbox to DC them. I know I can dc them in the VGR, but I guess we can't get them displayed on the iform?

[Scott Morris]

What they're asking is not impossible; you'd just have to get all of the orders that they're asking about by their OIS numbers.  If there are a dozen of them, then you would just need to do the lookup for each of the 12 orders individually.

[Russ Garlow]

I would LOVE a "get all function" that's really at the top of my wish list. 

How many orders are you talking about C.E. ? Like Scott said, totally doable, but it's not something you'd want to do a lot or have them thinking you'll do it on every form because it can get time intensive. 

The only places I've done this are on the Vent settings form, IV fluids, and Diet I think. Where else has everyone applied this?

[C.E. Coleman]

That is exactly what I ended up doing, there were only about 5 so it wasn't horrible. On another note, I ran into a random sheet of notes about supported lab results that tell me you can display an graph in an iform using graph_url variable. I would be very interested in hearing anyone's take on that and if they have used it, etc.

[Jason Murray]

I think you would write @@patient.lab_result.lab_abbreviation.graph_url@@ in order to get the url. You just need the list of lab abbreviations. To get the Creatinine lab value you could write:

<img src="@@patient.lab_result.Creat.graph_url@@" />

I haven't actually tested this, just found it in my notes. Does that help?

Jason Murray

________________________________

--
You received this message because you are subscribed to the Google Groups "HEO iForms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to heo-iforms+...@googlegroups.com.
To post to this group, send email to heo-i...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/heo-iforms/-/ZyYveSJ4MokJ.
For more options, visit https://groups.google.com/groups/opt_out.

[Scott Morris]

While I'm not sure whether you need to create a local VGR variable or whether you can reference it directly in your HTML, I'm pretty sure that the graphs only work for the McKesson-provided "canned concepts" and don't work for custom-built ones.

That's what I've heard and, as so far as I've tried, it's never worked for a custom-built one for me.

[Jason Murray]

I need to write lab values on an IForm.

My documentation says that lab values should be available as a session context variable. I can't get anything to work, though.

Anyone know how to get this to work? Lab value always returns "None available". I guess it's also possible that my lab abbreviations are wrong/outdated. My VGR documentation is from 2005, after all.

For a Creatinine lab, the docs say I should be able to write:
Lab Value: @@patient.lab_result.Creat.value@@

Lab Date: @@patient.lab_result.Creat.date@@

Graph Url: @@patient.lab_result.Creat.graph_url@@

Last is Normal: @@patient.lab_result.Creat.last_is_normal@@

Last is High: @@patient.lab_result.Creat.last_is_high@@

Last is Low: @@patient.lab_result.Creat.last_is_low@@

Jason Murray




________________________________

From: heo-i...@googlegroups.com on behalf of Scott Morris
Sent: Tue 2/12/2013 3:09 PM
To: heo-i...@googlegroups.com
Subject: Re: Displaying HED charted items on an iForm

While I'm not sure whether you need to create a local VGR variable or whether you can reference it directly in your HTML, I'm pretty sure that the graphs only work for the McKesson-provided "canned concepts" and don't work for custom-built ones.

That's what I've heard and, as so far as I've tried, it's never worked for a custom-built one for me.

--
You received this message because you are subscribed to the Google Groups "HEO iForms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to heo-iforms+...@googlegroups.com.
To post to this group, send email to heo-i...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/heo-iforms/-/ZhubX4jLE9gJ.

[Michael Hudson]

Jason,

Most of those will work, if they are returning none available, it is due to your lab results aging out. In order result mapping there is Lab Result Age, most of the McKesson delivered concepts are set to age out at 7 days. So if you patient in you are testing on, does not have a result within it's set parameter, it will display "None Available"

Michael

[Jason Murray]

Thanks, Michael. That's helpful. The lab I'm trying to test is from an hour ago, though. I can see it in HEO.

Jason

________________________________

To unsubscribe from this group and stop receiving emails from it, send an email to heo-iforms+...@googlegroups.com <mailto:heo-iforms%2Bunsu...@googlegroups.com> .

To post to this group, send email to heo-i...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/heo-iforms/-/ZhubX4jLE9gJ.
For more options, visit https://groups.google.com/groups/opt_out.



--
You received this message because you are subscribed to the Google Groups "HEO iForms" group.

To unsubscribe from this group and stop receiving emails from it, send an email to heo-iforms+...@googlegroups.com <mailto:heo-iforms%2Bunsu...@googlegroups.com> .

[Michael Hudson]

Jason,

Can you share the actual lab you are looking to display? For example:

To display calcium      @@patient.lab_result.Ca.value@@

[Scott Morris]

When you say that you can see it in HEO, do you mean that there is an orderable that has the Creat lab "attached" to it?  (That is to say, when you go to place the order, it shows "Creat = xx" with some value)

If so, is it showing as exactly Creat or is it spelled differently?

[Jason Murray]

Hi Michael-

Creatinine

@@patient.lab_result.Creat.value@@

To unsubscribe from this group and stop receiving emails from it, send an email to heo-iforms+...@googlegroups.com <mailto:heo-iforms%2Bunsu...@googlegroups.com> <mailto:heo-iforms%2Bunsu...@googlegroups.com <mailto:heo-iforms%252Buns...@googlegroups.com> > .

To post to this group, send email to heo-i...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/heo-iforms/-/ZhubX4jLE9gJ.
For more options, visit https://groups.google.com/groups/opt_out.



--
You received this message because you are subscribed to the Google Groups "HEO iForms" group.

To unsubscribe from this group and stop receiving emails from it, send an email to heo-iforms+...@googlegroups.com <mailto:heo-iforms%2Bunsu...@googlegroups.com> <mailto:heo-iforms%2Bunsu...@googlegroups.com <mailto:heo-iforms%252Buns...@googlegroups.com> > .

[Jason Murray]

Sorry... I meant that I see the lab results on the Lab tab. It's abbreviated there as CRE, which didn't work either.

________________________________

From: heo-i...@googlegroups.com on behalf of Scott Morris
Sent: Wed 2/13/2013 2:41 PM
To: heo-i...@googlegroups.com
Subject: Re: Displaying HED charted items on an iForm

When you say that you can see it in HEO, do you mean that there is an orderable that has the Creat lab "attached" to it? (That is to say, when you go to place the order, it shows "Creat = xx" with some value)

If so, is it showing as exactly Creat or is it spelled differently?

--
You received this message because you are subscribed to the Google Groups "HEO iForms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to heo-iforms+...@googlegroups.com.
To post to this group, send email to heo-i...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/heo-iforms/-/4RduSVYFlIwJ.

[Scott Morris]

It's possible that your lab result hasn't been properly mapped to the HEO Lab Concept.  Do you know how to check and/or troubleshoot this?

[Jason Murray]

No, I have no idea. Would you be able to walk me through that?

Much appreciated.

________________________________

From: heo-i...@googlegroups.com on behalf of Scott Morris
Sent: Wed 2/13/2013 2:54 PM
To: heo-i...@googlegroups.com
Subject: Re: Displaying HED charted items on an iForm

It's possible that your lab result hasn't been properly mapped to the HEO Lab Concept. Do you know how to check and/or troubleshoot this?

--
You received this message because you are subscribed to the Google Groups "HEO iForms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to heo-iforms+...@googlegroups.com.
To post to this group, send email to heo-i...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/heo-iforms/-/2naT3KSMjpcJ.

[Scott Morris]

Yeah, I can help you out; I've emailed you my contact information.

[Peter Shin]

I agree with scott that your problem is likely in the lab concept mapping. One of our IT people is looking into this because I had the same problem.

Ill let you know if I get it to work.

[Scott Morris]

Yeah, I walked through it with him on the phone and the mapping wasn't completed yet.  They're working with McKesson to get it done.

[Jason Murray]

I don't have it working yet, but I think I have the mapping completed. It's possible at this point that I'm using the wrong label_seq number.

Something I'm unclear on...

When I create a rule using a mapped lab value in a standard iform, I get an alert when opening the iform in HEO that says "This order utilizes resulted lab values to provided decision support."

But, when I use lab results in a vgr iform I get no so message. I've tried using

@@patient.lab_result.Creat.value@@

type syntax, as well as trying vgr such as

INIT,MAP,LOCAL,creattext_local,TO,patient.lab_result.Creat.value

Still not getting an alert when I open the vgr iform. Which has me thinking I'm doing something wrong in the vgr, or that mapped lab values are not supported at all in VGR. I'm not using a custom lab concept, either (which don't appear to be supported)

Besides the fact that I can't actually pull in a value yet, should I be getting that alert message on my vgr iforms?

TIA-

Jason Murray

________________________________

From: heo-i...@googlegroups.com on behalf of Scott Morris
Sent: Thu 2/14/2013 3:13 PM
To: heo-i...@googlegroups.com
Subject: Re: Displaying HED charted items on an iForm

Yeah, I walked through it with him on the phone and the mapping wasn't completed yet. They're working with McKesson to get it done.

--
You received this message because you are subscribed to the Google Groups "HEO iForms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to heo-iforms+...@googlegroups.com.
To post to this group, send email to heo-i...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/heo-iforms/-/hX5vLwke2d4J.

[Scott Morris]

1. No, VGR iForms don't alert the user when using lab results.  I suppose that could be seen as a pro or con, depending on how you feel about the alert.

2. Since "Creat" is a McKesson built-in (or "canned") lab concept, it should work to just inject the @@patient.lab_result.Creat.value@@ in your HTML.  Custom concepts need to be mapped via VGR variables like you state below (canned concepts can be mapped via VGR, too, but they don't need to be).

3a. After performing the mapping in your toolkit, you'll need to run an HEO_MAPPED_RESULTS release in your environment before it will work.  

3b. If it doesn't work, check the lab result units and compare them to the units listed in the lab concept.  If they do not match (case sensitive), there will need to be a record in the ccdev.unit_conv table to specify the unit conversion. Contact your DBA that has access to your Horizon database to check this.

3c. If it still doesn't work after this point, contact your DBA again and make sure that each of your mapped results have the result_list_param set to 5. This is a common bug with new mapping that will leave this field blank and will prevent the mapping from working.

[Jason Murray]

That's great, thanks Scott.

I think I have everything covered except verifying that result_list_param is set to 5. Where should I ask them to look for that?

Jason

________________________________

From: heo-i...@googlegroups.com on behalf of Scott Morris
Sent: Thu 2/14/2013 3:47 PM
To: heo-i...@googlegroups.com
Subject: Re: Displaying HED charted items on an iForm

--
You received this message because you are subscribed to the Google Groups "HEO iForms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to heo-iforms+...@googlegroups.com.
To post to this group, send email to heo-i...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/heo-iforms/-/QZhK_IcvnS8J.

[Scott Morris]

The lab results are records in the ccdev.fs_result_map table with cl_cfg_id = 15000 and should have result_list_param = 5. If result_list_param IS NULL, it will not cross correctly.

[Jason Murray]

Scott-

Would you mind sending me that SQL? The person I'm asking for help with this can't find that table.

To view this discussion on the web visit https://groups.google.com/d/msg/heo-iforms/-/QZhK_IcvnS8J <https://groups.google.com/d/msg/heo-iforms/-/QZhK_IcvnS8J> .
For more options, visit https://groups.google.com/groups/opt_out <https://groups.google.com/groups/opt_out> .

--
You received this message because you are subscribed to the Google Groups "HEO iForms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to heo-iforms+...@googlegroups.com.
To post to this group, send email to heo-i...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/heo-iforms/-/yi3fkEhwFhAJ.