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 (office) rwait...@kumc.edu<mailto:rwait...@kumc.edu> http://www.kumc.edu/ea-mi/ http://informatics.kumc.edu<http://informatics.kumc.edu/> http://www.gpcnetwork.org<http://www.gpcnetwork.org/> – a PCORnet collaborative www.pcornet.org<http://www.pcornet.org>
_______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
