RE: UNMC -- BC survey -- issue with rxcui values for importing per-medication into RedCap, rxcui values
Hi, I was now able to upload the per-medication results from UNMC. Jay Pedersen, M.A. Department of Pathology/Microbiology University of Nebraska Medical Center 985900 Nebraska Medical Center Omaha NE 68198-5900 402-559-9487 (office) 402-739-3496 (mobile) From: Dan Connolly [dconno...@kumc.edu] Sent: Thursday, October 13, 2016 5:08 PM To: Campbell, James R; Pedersen, Jay G; gpc-dev@listserv.kumc.edu Subject: RE: UNMC -- BC survey -- issue with rxcui values for importing per-medication into RedCap, rxcui values OK, all relevant UNMC meds are in the project codebook<https://redcap.gpcnetwork.org/redcap_v6.11.5/Design/data_dictionary_codebook.php?pid=64> as well. I don't suppose I took the shortest path to the target... The data dictionary was originally built by querying the meds from gpc_terms on babel. So I used unmc_terms instead, figuring that would subsume gpc_terms. But it doesn't. So I took the union of them. for reference: https://github.com/kumc-bmi/bc_qa/commits/rc_codebook/bc2_collect ba2a302 https://github.com/kumc-bmi/bc_qa/blob/rc_codebook/bc2_collect/bc_meds.csv https://github.com/kumc-bmi/bc_qa/blob/rc_codebook/bc2_collect/rx_choices.txt p.s. I didn't even need my laptop. I just used pythonanywhere <https://www.pythonanywhere.com/> on one of the public-use computers here at the Kauffman center. -- Dan From: gpc-dev-boun...@listserv.kumc.edu [gpc-dev-boun...@listserv.kumc.edu] on behalf of Campbell, James R [campb...@unmc.edu] Sent: Wednesday, October 12, 2016 2:03 PM To: Pedersen, Jay G; gpc-dev@listserv.kumc.edu Subject: RE: UNMC -- BC survey -- issue with rxcui values for importing per-medication into RedCap, rxcui values >From the looks of the medications that fail, I suspect the version of RXNORM >may need updating. Jim From: gpc-dev-boun...@listserv.kumc.edu [gpc-dev-boun...@listserv.kumc.edu] on behalf of Pedersen, Jay G [jay.peder...@unmc.edu] Sent: Wednesday, October 12, 2016 12:03 PM To: gpc-dev@listserv.kumc.edu Subject: UNMC -- BC survey -- issue with rxcui values for importing per-medication into RedCap, rxcui values Hi, Looking for insight into the following problem. When I try to import my per-medication CSV files into RedCap, I get errors relating to the "rxcui" values. Specifically: 378861 847229 847262 897121 1298947 I have these documented to mean (I think I have this right, can double-check as needed): 378861 ==> NPH INSULIN HUMAN RECOMB 100 UNIT/ML SUBCUTANEOUS SUSPENSION 847229 ==> INSULIN GLARGINE 100 UNIT/ML (3 ML) SUBCUTANEOUS PEN 847262 ==> INSULIN ASPART 100 UNIT/ML SUBCUTANEOUS PEN 897121 ==> LIRAGLUTIDE 0.6 MG/0.1 ML (18 MG/3 ML) SUBCUTANEOUS PEN INJECTOR 1298947 ==> PERTUZUMAB 420 MG/14 ML (30 MG/ML) INTRAVENOUS SOLUTION Jay Pedersen, M.A. Department of Pathology/Microbiology University of Nebraska Medical Center 985900 Nebraska Medical Center Omaha NE 68198-5900 402-559-9487 (office) 402-739-3496 (mobile) The information in this e-mail may be privileged and confidential, intended only for the use of the addressee(s) above. Any unauthorized use or disclosure of this information is prohibited. If you have received this e-mail by mistake, please delete it and immediately contact the sender. ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
RE: UNMC -- BC survey -- issue with rxcui values for importing per-medication into RedCap, rxcui values
OK, all relevant UNMC meds are in the project codebook<https://redcap.gpcnetwork.org/redcap_v6.11.5/Design/data_dictionary_codebook.php?pid=64> as well. I don't suppose I took the shortest path to the target... The data dictionary was originally built by querying the meds from gpc_terms on babel. So I used unmc_terms instead, figuring that would subsume gpc_terms. But it doesn't. So I took the union of them. for reference: https://github.com/kumc-bmi/bc_qa/commits/rc_codebook/bc2_collect ba2a302 https://github.com/kumc-bmi/bc_qa/blob/rc_codebook/bc2_collect/bc_meds.csv https://github.com/kumc-bmi/bc_qa/blob/rc_codebook/bc2_collect/rx_choices.txt p.s. I didn't even need my laptop. I just used pythonanywhere <https://www.pythonanywhere.com/> on one of the public-use computers here at the Kauffman center. -- Dan From: gpc-dev-boun...@listserv.kumc.edu [gpc-dev-boun...@listserv.kumc.edu] on behalf of Campbell, James R [campb...@unmc.edu] Sent: Wednesday, October 12, 2016 2:03 PM To: Pedersen, Jay G; gpc-dev@listserv.kumc.edu Subject: RE: UNMC -- BC survey -- issue with rxcui values for importing per-medication into RedCap, rxcui values >From the looks of the medications that fail, I suspect the version of RXNORM >may need updating. Jim From: gpc-dev-boun...@listserv.kumc.edu [gpc-dev-boun...@listserv.kumc.edu] on behalf of Pedersen, Jay G [jay.peder...@unmc.edu] Sent: Wednesday, October 12, 2016 12:03 PM To: gpc-dev@listserv.kumc.edu Subject: UNMC -- BC survey -- issue with rxcui values for importing per-medication into RedCap, rxcui values Hi, Looking for insight into the following problem. When I try to import my per-medication CSV files into RedCap, I get errors relating to the "rxcui" values. Specifically: 378861 847229 847262 897121 1298947 I have these documented to mean (I think I have this right, can double-check as needed): 378861 ==> NPH INSULIN HUMAN RECOMB 100 UNIT/ML SUBCUTANEOUS SUSPENSION 847229 ==> INSULIN GLARGINE 100 UNIT/ML (3 ML) SUBCUTANEOUS PEN 847262 ==> INSULIN ASPART 100 UNIT/ML SUBCUTANEOUS PEN 897121 ==> LIRAGLUTIDE 0.6 MG/0.1 ML (18 MG/3 ML) SUBCUTANEOUS PEN INJECTOR 1298947 ==> PERTUZUMAB 420 MG/14 ML (30 MG/ML) INTRAVENOUS SOLUTION Jay Pedersen, M.A. Department of Pathology/Microbiology University of Nebraska Medical Center 985900 Nebraska Medical Center Omaha NE 68198-5900 402-559-9487 (office) 402-739-3496 (mobile) The information in this e-mail may be privileged and confidential, intended only for the use of the addressee(s) above. Any unauthorized use or disclosure of this information is prohibited. If you have received this e-mail by mistake, please delete it and immediately contact the sender. ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
Re: UNMC -- BC survey -- issue with rxcui values for importing per-medication into RedCap, rxcui values
Use Russ’s , We’re seeing him stand up there talking right now. Is there a live feed ? G George Kowalski Biomedical Informatics Software Engineer Clinical & Translational Science Institute Medical College of Wisconsin 9200 West Wisconsin Avenue, Suite L722A Milwaukee, Wisconsin USA 53226 414.805.7318 (office) / gkowal...@mcw.edu<mailto:gkowal...@mcw.edu> From: <gpc-dev-boun...@listserv.kumc.edu> on behalf of Dan Connolly <dconno...@kumc.edu> Date: Thursday, October 13, 2016 at 9:13 AM To: "gpc-dev@listserv.kumc.edu" <gpc-dev@listserv.kumc.edu>, "Pedersen, Jay G" <jay.peder...@unmc.edu> Subject: RE: UNMC -- BC survey -- issue with rxcui values for importing per-medication into RedCap, rxcui values Hi from the LEC... Forgot my laptop. Bummed that I haven't addressed this issue yet. On Oct 12, 2016 12:54 PM, Dan Connolly <dconno...@kumc.edu> wrote: I'll look into adding those to the data dictionary. -- Dan From: gpc-dev-boun...@listserv.kumc.edu [gpc-dev-boun...@listserv.kumc.edu] on behalf of Pedersen, Jay G [jay.peder...@unmc.edu] Sent: Wednesday, October 12, 2016 12:03 PM To: gpc-dev@listserv.kumc.edu Subject: UNMC -- BC survey -- issue with rxcui values for importing per-medication into RedCap, rxcui values Hi, Looking for insight into the following problem. When I try to import my per-medication CSV files into RedCap, I get errors relating to the "rxcui" values. Specifically: 378861 847229 847262 897121 1298947 I have these documented to mean (I think I have this right, can double-check as needed): 378861 ==> NPH INSULIN HUMAN RECOMB 100 UNIT/ML SUBCUTANEOUS SUSPENSION 847229 ==> INSULIN GLARGINE 100 UNIT/ML (3 ML) SUBCUTANEOUS PEN 847262 ==> INSULIN ASPART 100 UNIT/ML SUBCUTANEOUS PEN 897121 ==> LIRAGLUTIDE 0.6 MG/0.1 ML (18 MG/3 ML) SUBCUTANEOUS PEN INJECTOR 1298947 ==> PERTUZUMAB 420 MG/14 ML (30 MG/ML) INTRAVENOUS SOLUTION Jay Pedersen, M.A. Department of Pathology/Microbiology University of Nebraska Medical Center 985900 Nebraska Medical Center Omaha NE 68198-5900 402-559-9487 (office) 402-739-3496 (mobile) The information in this e-mail may be privileged and confidential, intended only for the use of the addressee(s) above. Any unauthorized use or disclosure of this information is prohibited. If you have received this e-mail by mistake, please delete it and immediately contact the sender. ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
RE: UNMC -- BC survey -- issue with rxcui values for importing per-medication into RedCap, rxcui values
Hi from the LEC... Forgot my laptop. Bummed that I haven't addressed this issue yet. On Oct 12, 2016 12:54 PM, Dan Connolly <dconno...@kumc.edu> wrote: I'll look into adding those to the data dictionary. -- Dan From: gpc-dev-boun...@listserv.kumc.edu [gpc-dev-boun...@listserv.kumc.edu] on behalf of Pedersen, Jay G [jay.peder...@unmc.edu] Sent: Wednesday, October 12, 2016 12:03 PM To: gpc-dev@listserv.kumc.edu Subject: UNMC -- BC survey -- issue with rxcui values for importing per-medication into RedCap, rxcui values Hi, Looking for insight into the following problem. When I try to import my per-medication CSV files into RedCap, I get errors relating to the "rxcui" values. Specifically: 378861 847229 847262 897121 1298947 I have these documented to mean (I think I have this right, can double-check as needed): 378861 ==> NPH INSULIN HUMAN RECOMB 100 UNIT/ML SUBCUTANEOUS SUSPENSION 847229 ==> INSULIN GLARGINE 100 UNIT/ML (3 ML) SUBCUTANEOUS PEN 847262 ==> INSULIN ASPART 100 UNIT/ML SUBCUTANEOUS PEN 897121 ==> LIRAGLUTIDE 0.6 MG/0.1 ML (18 MG/3 ML) SUBCUTANEOUS PEN INJECTOR 1298947 ==> PERTUZUMAB 420 MG/14 ML (30 MG/ML) INTRAVENOUS SOLUTION Jay Pedersen, M.A. Department of Pathology/Microbiology University of Nebraska Medical Center 985900 Nebraska Medical Center Omaha NE 68198-5900 402-559-9487 (office) 402-739-3496 (mobile) The information in this e-mail may be privileged and confidential, intended only for the use of the addressee(s) above. Any unauthorized use or disclosure of this information is prohibited. If you have received this e-mail by mistake, please delete it and immediately contact the sender. ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
RE: UNMC -- BC survey -- issue with rxcui values for importing per-medication into RedCap, rxcui values
>From the looks of the medications that fail, I suspect the version of RXNORM >may need updating. Jim From: gpc-dev-boun...@listserv.kumc.edu [gpc-dev-boun...@listserv.kumc.edu] on behalf of Pedersen, Jay G [jay.peder...@unmc.edu] Sent: Wednesday, October 12, 2016 12:03 PM To: gpc-dev@listserv.kumc.edu Subject: UNMC -- BC survey -- issue with rxcui values for importing per-medication into RedCap, rxcui values Hi, Looking for insight into the following problem. When I try to import my per-medication CSV files into RedCap, I get errors relating to the "rxcui" values. Specifically: 378861 847229 847262 897121 1298947 I have these documented to mean (I think I have this right, can double-check as needed): 378861 ==> NPH INSULIN HUMAN RECOMB 100 UNIT/ML SUBCUTANEOUS SUSPENSION 847229 ==> INSULIN GLARGINE 100 UNIT/ML (3 ML) SUBCUTANEOUS PEN 847262 ==> INSULIN ASPART 100 UNIT/ML SUBCUTANEOUS PEN 897121 ==> LIRAGLUTIDE 0.6 MG/0.1 ML (18 MG/3 ML) SUBCUTANEOUS PEN INJECTOR 1298947 ==> PERTUZUMAB 420 MG/14 ML (30 MG/ML) INTRAVENOUS SOLUTION Jay Pedersen, M.A. Department of Pathology/Microbiology University of Nebraska Medical Center 985900 Nebraska Medical Center Omaha NE 68198-5900 402-559-9487 (office) 402-739-3496 (mobile) The information in this e-mail may be privileged and confidential, intended only for the use of the addressee(s) above. Any unauthorized use or disclosure of this information is prohibited. If you have received this e-mail by mistake, please delete it and immediately contact the sender. ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
RE: UNMC -- BC survey -- issue with rxcui values for importing per-medication into RedCap, rxcui values
I'll look into adding those to the data dictionary. -- Dan From: gpc-dev-boun...@listserv.kumc.edu [gpc-dev-boun...@listserv.kumc.edu] on behalf of Pedersen, Jay G [jay.peder...@unmc.edu] Sent: Wednesday, October 12, 2016 12:03 PM To: gpc-dev@listserv.kumc.edu Subject: UNMC -- BC survey -- issue with rxcui values for importing per-medication into RedCap, rxcui values Hi, Looking for insight into the following problem. When I try to import my per-medication CSV files into RedCap, I get errors relating to the "rxcui" values. Specifically: 378861 847229 847262 897121 1298947 I have these documented to mean (I think I have this right, can double-check as needed): 378861 ==> NPH INSULIN HUMAN RECOMB 100 UNIT/ML SUBCUTANEOUS SUSPENSION 847229 ==> INSULIN GLARGINE 100 UNIT/ML (3 ML) SUBCUTANEOUS PEN 847262 ==> INSULIN ASPART 100 UNIT/ML SUBCUTANEOUS PEN 897121 ==> LIRAGLUTIDE 0.6 MG/0.1 ML (18 MG/3 ML) SUBCUTANEOUS PEN INJECTOR 1298947 ==> PERTUZUMAB 420 MG/14 ML (30 MG/ML) INTRAVENOUS SOLUTION Jay Pedersen, M.A. Department of Pathology/Microbiology University of Nebraska Medical Center 985900 Nebraska Medical Center Omaha NE 68198-5900 402-559-9487 (office) 402-739-3496 (mobile) The information in this e-mail may be privileged and confidential, intended only for the use of the addressee(s) above. Any unauthorized use or disclosure of this information is prohibited. If you have received this e-mail by mistake, please delete it and immediately contact the sender. ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
UNMC -- BC survey -- issue with rxcui values for importing per-medication into RedCap, rxcui values
Hi, Looking for insight into the following problem. When I try to import my per-medication CSV files into RedCap, I get errors relating to the "rxcui" values. Specifically: 378861 847229 847262 897121 1298947 I have these documented to mean (I think I have this right, can double-check as needed): 378861 ==> NPH INSULIN HUMAN RECOMB 100 UNIT/ML SUBCUTANEOUS SUSPENSION 847229 ==> INSULIN GLARGINE 100 UNIT/ML (3 ML) SUBCUTANEOUS PEN 847262 ==> INSULIN ASPART 100 UNIT/ML SUBCUTANEOUS PEN 897121 ==> LIRAGLUTIDE 0.6 MG/0.1 ML (18 MG/3 ML) SUBCUTANEOUS PEN INJECTOR 1298947 ==> PERTUZUMAB 420 MG/14 ML (30 MG/ML) INTRAVENOUS SOLUTION Jay Pedersen, M.A. Department of Pathology/Microbiology University of Nebraska Medical Center 985900 Nebraska Medical Center Omaha NE 68198-5900 402-559-9487 (office) 402-739-3496 (mobile) The information in this e-mail may be privileged and confidential, intended only for the use of the addressee(s) above. Any unauthorized use or disclosure of this information is prohibited. If you have received this e-mail by mistake, please delete it and immediately contact the sender. ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
