The explosion of the number of facts has been my biggest concern with the med modifiers as well. With 115 million medication rows, a 10x increase would give us double our existing number of facts. At UTSW, I¹ve populated the data for many of these modifiers into the observation_blob column in a flat XML schema. This allows me to use them in my ETL for the PCORI CDM. But it doesn¹t allow me to query on them in i2b2. It would be nice if i2b2 could be modified to allow me use that XML data in a query, but for now, it¹s meeting my needs. However with the SHRINE work we are doing, I might be forced to populate them as modifiers.
Phillip On 3/20/17, 10:37 AM, "Gpc-dev on behalf of Dan Connolly" <gpc-dev-boun...@listserv.kumc.edu on behalf of dconno...@kumc.edu> wrote: >As to who is going to look at them: i2p-transform (i.e. software to build >PCORNet CDM from i2b2) consumes these modifiers. > >As to 11x: how many modifiers are you currently storing? You're already >storing RX_BASIS, RX_FREQUENCY, RX_DAYS_SUPPLY, RX_QUANTITY, and >RX_REFILLS somehow, yes? > >UNMC was proposing adding RX_STRENGTH, RX_ROUSE, RX_DOSE, and RX_SIG, but >in discussion it emerged that "justification for including route, dose >and detail modifiers ... is weakest in terms of use cases" > >I count 9 total modifiers in the proposal, 5 of which KUMC (and >presumably the other 8 sites using the i2p-transform code) are already >loading, and 3 of which could (from discussion so far) be removed without >much objection. So to me, it looks like this is a proposal to go from 5 >to 6 modifiers. > >-- >Dan > >________________________________________ >From: Debbie Yoshihara [dlyos...@wisc.edu] >Sent: Monday, March 20, 2017 10:09 AM >To: gpc-dev@listserv.kumc.edu; Thomas Mish; campb...@unmc.edu; >huhick...@nebraskamed.com; Dan Connolly; Russ Waitman >Cc: jeff.kl...@mgh.harvard.edu >Subject: RE: [gpc-informatics] #280: Medication ontology orgainzed by >ingredient > >I have looked over these explosion of modifiers. >For the med modifiers if you populated all of them that would make the >facts 11x bigger for the med facts. >Who is going to look at all of these? Or even populate them if they have >them? > >The only other question I have is for the lab_mod, what is the difference >between stat and expedite? > >--- Debbie Yoshihara > > > >-----Original Message----- >From: Gpc-dev [mailto:gpc-dev-boun...@listserv.kumc.edu] On Behalf Of GPC >Informatics >Sent: Monday, March 20, 2017 8:46 AM >To: Thomas Mish; campb...@unmc.edu; huhick...@nebraskamed.com; >dconno...@kumc.edu; rwait...@kumc.edu >Cc: gpc-dev@listserv.kumc.edu; jeff.kl...@mgh.harvard.edu >Subject: Re: [gpc-informatics] #280: Medication ontology orgainzed by >ingredient > >#280: Medication ontology orgainzed by ingredient >-------------------------+---------------------------- > Reporter: preeder | Owner: mish > Type: enhancement | Status: assigned > Priority: major | Milestone: snow-shrine-2 >Component: data-stds | Resolution: > Keywords: | Blocked By: > Blocking: | >-------------------------+---------------------------- >Changes (by dconnolly): > > * owner: jay.pedersen => mish > > >Comment: > > Tom, > > Is Debbie likely to complete her review this morning? > >-- >Ticket URL: ><http://informatics.gpcnetwork.org/trac/Project/ticket/280#comment:17> >gpc-informatics <http://informatics.gpcnetwork.org/> >Greater Plains Network - Informatics >_______________________________________________ >Gpc-dev mailing list >Gpc-dev@listserv.kumc.edu >http://listserv.kumc.edu/mailman/listinfo/gpc-dev >_______________________________________________ >Gpc-dev mailing list >Gpc-dev@listserv.kumc.edu >http://listserv.kumc.edu/mailman/listinfo/gpc-dev ________________________________ UT Southwestern Medical Center The future of medicine, today. _______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev