I'm surely missing something -- if you're going to study med data from 2010, don't you need NDCs from 2010?
Having only NDCs currently active might be great for prescribing, but it's not so great for retrospective data analysis... Bill On Wed, Sep 20, 2017 at 6:16 PM, Russ Waitman <rwait...@kumc.edu> wrote: > Sorry for my poor pseudocode. Perhaps better stated functionally as the > great(powerful(Lori > Phillips, Jeff Klann)). > > > > So it sounds like 3.1 may not have it then? > > > > I agree we may not want to have ancient NDCs but our CMS data only goes > back to 2011 so I’d hope most of those wouldn’t be retired. We’re only > getting 57% coverage so we’ve got a big gap right now. If our data in any > way could help you know which ones to grab we could share a NDC list. > > > > We just realized you had comments that some of the missing NDCs may have > been fixed since 2.2 and we hoped they might be resolved in 3.1. > > > > We will need to move forward with things somehow to serve especially some > cancer projects so I don’t think we’d want to be in an undetermined state > to fill in the gap. > > > > Russ > > > > > > *From:* Klann, Jeffrey G. [mailto:jeff.kl...@mgh.harvard.edu] > *Sent:* Wednesday, September 20, 2017 4:28 PM > *To:* Russ Waitman; GPC-DEV@LISTSERV.KUMC.EDU > *Cc:* members; Chrischilles, Elizabeth A; 'McDowell, Bradley D' > *Subject:* Re: Med ontology missing NDC question > > > > Is the property commutative? As in, (the great and powerful (Lori Phillips > and Jeff Klann)) or ((the great and powerful Lori Phillips) and Jeff Klann)? > > > > There are a massive number of retired NDC codes that we did not have any > way of grabbing systematically when we built the ontology, and we never > added them because it would make the ontology so much bigger. > > > > Jim Campbell has created a version with all the retired NDC codes, but the > organization is somewhat different than SCILHS. We do hope to harmonize > them but lack the resources. Shawn Murphy suggested this be a topic at the > next i2b2 meeting (AMIA in November?). > > > > Jeffrey Klann, PhD > > Instructor of Medicine, Harvard Medical School > > Director, SCILHS Query Core > > > > > > *From: *Russ Waitman <rwait...@kumc.edu> > *Date: *Wednesday, September 20, 2017 at 5:06 PM > *To: *"GPC-DEV@LISTSERV.KUMC.EDU" <GPC-DEV@LISTSERV.KUMC.EDU> > *Cc: *members <memb...@i2b2aug.org>, "Chrischilles, Elizabeth A" < > e-chrischil...@uiowa.edu>, Jeffrey KLANN <jeff.kl...@mgh.harvard.edu>, > "'McDowell, Bradley D'" <bradley-mcdow...@uiowa.edu> > *Subject: *Med ontology missing NDC question > > > > HI gpc-dev and (i2b2 community (particular the great and powerful Lori > Phillips and Jeff Klann), > > > > We are working on loading all the medication claims from Medicare for our > eight Greater Plains Collaborative PCORnet CDRN into i2b2 where we will > link across with our site i2b2 data (that has things like tumor registries) > and then run the scripts to pump it all into the PCORnet CDM ultimately. > > > > We’ve hit a snag: > > We’re using the ACT/SCILHS meds ontology loaded in Oracle (version 2.2) > via the magnanimous Phillip Reeder of Dallas. But it’s missing a bunch of > NDCs. > > > > It looks like that may have been fixed in 3.1a or 3.1b > > https://github.com/SCILHS/scilhs-ontology/tree/master/Ontology > > > > Do you know if it’s fixed? > > > > Dan’s notes are below for those who are curious. Brad and Betsy: if > you’re curious, we are now querying samples of both PDE and HCPCS for > things like Chemo administration (but it’s a ~1% sample) > Meds and Chemo Procedures working in at least one case > > - 33124±3 For Query "Analgesics@10:34:37" > - 1986±3 For Query "J9010 - J9999: @10:36:42" > > This works because of: > > - bb8cad6 fill concept_dimension from PCORIMETADATA > > But… thousands of NDC Codes still unsearchable due to missing metadata > > top 3 from this 1% sample: > > CONCEPT_CD > > PATIENTS > > ENCOUNTERS > > FACTS > > NDC:59310057920 > > 7046 > > 16684 > > 16900 > > NDC:65162062711 > > 4583 > > 12208 > > 12224 > > NDC:00088222033 > > 2036 > > 9516 > > 9558 > > Consulting NLM's RxNav <https://mor.nlm.nih.gov/RxNav/> > > - NDC:59310057920: *There is no result for '59310057920' (as NDC)* > - NDC:65162062711: RxNorm? <https://bmi-work.kumc.edu/work/wiki/RxNorm> > 835603 traMADol hydrochloride 50 MG Oral Tablet > - NDC:00088222033: RxNorm? <https://bmi-work.kumc.edu/work/wiki/RxNorm> > 285018 Lantus 100 UNT/ML Injectable Solution > > Looking at PCORNET_MED > > WHICH_T > > TERM_QTY > > TERM_PCT > > FACT_QTY > > FACT_PCT > > PDE only > > 17,396 > > 16 > > 86,057,698 > > 43 > > SCILHS only > > 80,499 > > 73 > > 0 > > 0 > > both > > 11,636 > > 11 > > 112,535,344 > > 57 > > total > > 109,531 > > 100 > > 198,593,042 > > 100 > > > > > > About 4 months ago we had record on gpc-dev calls that Jim Campbell was > connecting to the NLM and looping SCILHS and Jeff Klann ( > https://informatics.gpcnetwork.org/trac/Project/ticket/280#comment:27) > but didn’t know if something was working yet. > > > > Also trying to see if we can keep as much of the GPC work in sync with the > SCILHS/NIH work. > > > > > > Russ Waitman, PhD > > Director of Medical Informatics > > Associate Vice Chancellor for Enterprise Analytics > > Professor, Department of Internal Medicine > > University of Kansas Medical Center, Kansas City, Kansas > > 913-945-7087 <(913)%20945-7087> (office) > > rwait...@kumc.edu > > http://www.kumc.edu/ea-mi/ > > http://informatics.kumc.edu > > http://www.gpcnetwork.org – a PCORnet collaborative www.pcornet.org > > > > The information in this e-mail is intended only for the person to whom it > is > addressed. If you believe this e-mail was sent to you in error and the > e-mail > contains patient information, please contact the Partners Compliance > HelpLine at > http://www.partners.org/complianceline . If the e-mail was sent to you in > error > but does not contain patient information, please contact the sender and > properly > dispose of the e-mail. >
_______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
