Anyway to get UI for order without using activeorder awareness?

[John Macko]

Is there any way to get the UI for an order without using active order awareness? (We cant use "get_order" i.e. INIT,MAP,LOCAL,telemetryOrderUI,TO,get_order.ui.123456.1)

We mainly use CGI/perl scripting to pull "active" data into our iforms. WE want to pull the UI (Unique identifier) into our iform so we can use it to DC the order. 

Using something like:

Grab the UI via CGI,  and put it into "UIoforder" 

then

EDIT,IF,,cb_dcorder,EQ,1,THEN

EDIT,LOAD_ORDER,,,,"@DC_ORDER=UI='UIoforder^^^blah blah blah"

Is this possible?

Thanks in advance

[John Macko]

OK, Nevermind to the above question. I have it working.  Now I just need to see if I can get all of the orders for a particular OIS and DC all of them at once.

For example - If someone is on Warfarin 5 mg daily AND 2 mg daily, how do I construct the VGR to grab BOTH UI numbers?

[Michael Hudson]

John,

I have a technique that works to get the UI, but can you elaborate on what you are doing to get the UI?

TO get all UI of all orders (you will need to know how many you think could exist), just do something like this:

INIT,MAP,LOCAL,lovenoxEDui1,TO,get_order.ui.218198.1

INIT,MAP,LOCAL,lovenoxEDui2,TO,get_order.ui.218198.2

INIT,MAP,LOCAL,lovenoxEDui3,TO,get_order.ui.218198.3

EDIT,IF,,lovenoxEDui1,NE,"???",THEN

EDIT,SET,LOCAL,orderstring,CAT,"@DC_ORDER=UI=`lovenoxEDui1"

EDIT,IF,,lovenoxEDui2,NE,"???",THEN

EDIT,SET,LOCAL,orderstring,CAT,"@DC_ORDER=UI=`lovenoxEDui2"

EDIT,IF,,lovenoxEDui3,NE,"???",THEN

EDIT,SET,LOCAL,orderstring,CAT,"@DC_ORDER=UI=`lovenoxEDui3"

Thanks,

Michael

--
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/msgid/heo-iforms/8f75d303-0b33-4ceb-bdd6-3d53b2d159b9%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[John Macko]

Michael,

You know I "tried" that before and it didn't work. I tried it again and now it does. Probably forgot to copy an updated VGR file or something silly.

Thanks.

To get the UI - we have gone back to using: 

INIT,MAP,LOCAL,UInum,TO,get_order.ui.14000416.1

INIT,MAP,LOCAL,UInum2,TO,get_order.ui.14000416.2

like you and everyone else does. 

Don't know why the UI is so supersecret. I'd like to be able to grab all of the UI's for a patient thru a query and have all of  those values  available for DC'ing. 

That way I would not have to "know" ahead of time (by pre-placing the INIT,MAP,LOCAL,UInum,TO,get_order.ui.14000416.1 statements) in the VGR file. 

Anyway, thanks for the response!!!

And if anyone knows how to query for the UI, outside of the VGR let us know.

JM

[TWessel]

I believe that the "ui" is just the ORDER_ITEM_SEQ for the orderable.  You should be able to query the O_PAT table to get a list of all active orders for a particular patient encounter.  The PAT_SEQ field is the unique patient identifer pertinent to a particular patient encounter.

____________________

Tom Wessel, MD

CMIO

Spartanburg, SC

[Michael Hudson]

Tom,

Actually the UI is a dynamic number assigned to all orders during that order session. On O_PAT you can find the SSID of  an order and use that to discontinue, but if the order hasn't been written to O_PAT, no SSID exists. The orders do get written to stored_order table temporarily, but no SSID is assigned because they are not actual orders yet. In an order session, when you are using verbose mode, you will note that the UI of an order can change based on orders being added or discontinued in a previous order session.

Hope this clears something up! 

Michael

--
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/msgid/heo-iforms/7eea2eac-0a91-4cd0-8486-7f73c80a51d9%40googlegroups.com.

[John Macko]

The only unique identifier in O_PAT the would distinguish a specific order is the ORDER_SEQ. (That I can see) There is no SSID field, Unless its a concatenation of the SESSION_ID and the SUB_SEQ. 

In a related topic, are here any other parameters I can add to the:  LOAD_ORDER,,,,"@DC_ORDER=UI='UIoforder^^^???????? such that I could dc something at a future time. 

i.e. DC Heparin drip at 5 pm when I start rivaroxaban????

Thanks

J Macko

[Michael Hudson]

Sorry, the SSID is the SUB_SEQ, and can be used to discontinue orders if known:

@DC_ORDER=SS=4\IDCR=60

To view this discussion on the web visit https://groups.google.com/d/msgid/heo-iforms/78b25afa-e3ce-4ad1-9fb0-34d3ef6a3678%40googlegroups.com.