Hi, one question related to measurements:

In Admin - Custumize oscarMeasurements, there is an option: Add Measurement Style Sheet ......is anybody using this function, what is it for?

Cheers,
Santiago.

On Fri, Jun 18, 2010 at 5:09 PM, David Page <drpage@shawbiz.ca> wrote:
Thanks to the help on this.
Thought I would give a quick summary on the topic.
LOINC stands for Logical Observation Identifiers Names and Codes and appears
to be an opensource project out of Indiana Medical School.
It has been developed in an attempt to unify transfer of information
electronically and appears to be an "ICD 9" coding for information like lab
results but extends to clinical content as well.

So how to map values in OSCAR.
1) Check that what you want to map is in measurements- there are a lot of
values already there because of flowsheets so look carefully.
If the item is not in measurements, create it
****we should probably think about a database of standard terms in OSCAR****
For example I have just created: Ca , Phos, iPTH, TSAT  - it would be useful
if everyone used the same nomenclature.

2)
Go to Admin
Customise measurements
View mapping
FOR EXAMPLE
Choose Hemoglobin in the long list
Here you will see a choice of two: 5794-3 and 718-7
*Work out which is the correct one (in this case 718-7, the other one is Hb
in urine)*
Click the "map" next to 718-7
Select measurement "Hb"
Update measurement mapping
>From now on, all the CBC hemoglobins arriving will end up in measurements as
well.(NOTE: this will not move previous lab values into measurements, only
new arrivals)

3) Now we can suck these values into eForms using the special tags:
oscarDB=m$EGFR#value
oscarDB=m$EGFR#dateObserved
oscarDB=m$EGFR#comments
Change the EGFR into the item you are importing from measurements (eg Ca or
Phos etc from (1) above)


*So the BIG issue is working out which is the correct item to map.
I have requested that both FHA and BC bio send me their lists of Loinc codes
as David suggested (and will post if I get anything).
Google searches can help.
The link below that Darius recommended is helpful.
I have downloaded the LOINC/REMLA engine and found that if I search by NAME
and not Loinc that I can find things (eg search on hemoglobin gives the
attached readout).
Searching by Loinc code is done by pdf searches as per Darius.
Interesting Transferrin saturation although it shows up in our OSCAR list of
choices, shows up on a Google search, DOES NOT show up in the REMLA
utility... so there is some incompleteness and clumsiness in all of this.

There was a question on how to create a new measurement:
Go to Admin
Customise measurements
Add measurement type
You are allowed up to four letters to name
So I just use the same 4 in all the fields as I am lazy:
iPTH
iPTH
iPTH
iPTH
And then choose the range of possible values (in this case a numeric value
from 0-100 (although I am not sure what the highest iPTH can be?)
Add and you are done.

Any comments on all this would be great.

So now a question....
I messed up on the TSAT mapping (transferring saturation) and it is mapped
to 6796-7 as well as X464
I think that the 6796-7 is the correct one (X means it is not suitable for a
Loinc code).
The system is working so I am not wanting to break anything, but there is a
"Remove measurement mapping button" which gives the option of Delete or
remap.
Anyone understand what these do (does delete totally remove the
item...probably not a good idea?) I tried remap but not sure what I was
remapping.....

Bottom line is be careful and don't map without knowing that you are doing
the correct thing!!!

DavidP


-----Original Message-----
From: Darius Opensource [mailto:darius.opensource@yahoo.com]
Sent: June 17, 2010 5:22 PM
To: The OSCAR UserGroup list
Subject: Re: [Oscarmcmaster-bc-users] Mapping

greetings,
You may find the following useful as an alternative to RELMA though not as
comprehensive:
http://loinc.org/usage/orders/common-lab-orders-value-set.pdf
It is sorted alphabetically. It is searchable however it does have a quirk.
When searching on code, e.g. 718-7, search on 718 not 718-7. Though 718-7
exists in the document, searching on 718-7 will fail but searching on 718
will succeed.

--- On Thu, 6/17/10, David Page <drpage@shawbiz.ca> wrote:

> From: David Page <drpage@shawbiz.ca>
> Subject: Re: [Oscarmcmaster-bc-users] Mapping
> To: "'The OSCAR UserGroup list'"
<oscarmcmaster-bc-users@lists.sourceforge.net>
> Date: Thursday, June 17, 2010, 7:51 PM
> Before I waste time I am wondering if
> there is a quick answer.
> I am trying to learn how to do the mapping.... and will
> document if I find
> out how.
> It seems straight forward to do in Admin.
> The issue is choosing the correct code.
>
> For example there are 2 hemoglobins listed, 718-7 and
> 5794-3
>
> I have downloaded the LOINC and REMLA tools and can't
> figure out how to use
> them (I admit I have not read the manual)- the Oscar
> suggestion is to use
> them
> So has anyone read the manual and can give me the 2 second
> version of how to
> use the REMLA tool?
> They talk about Microsoft Access data bases and importing
> values from my
> system which I have not done...which is probably why this
> is not working.
>
> I went ahead and mapped Hb to 718-7 as I am impatient and I
> think that this
> is the correct one.
>
> DavidP
>
>
>
>
----------------------------------------------------------------------------
--
> ThinkGeek and WIRED's GeekDad team up for the Ultimate
> GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
> lucky parental unit.  See the prize list and enter to
> win:
> http://p.sf.net/sfu/thinkgeek-promo
> _______________________________________________
> Oscarmcmaster-bc-users mailing list
> Oscarmcmaster-bc-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-bc-users
>





----------------------------------------------------------------------------
--
ThinkGeek and WIRED's GeekDad team up for the Ultimate
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
lucky parental unit.  See the prize list and enter to win:
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Oscarmcmaster-bc-users mailing list
Oscarmcmaster-bc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-bc-users

------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
lucky parental unit.  See the prize list and enter to win:
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Oscarmcmaster-bc-users mailing list
Oscarmcmaster-bc-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-bc-users