PCORI article on NPR

Of interest http://www.npr.org/sections/health-shots/2015/08/04/428164731/is-obamacares-research-institute-worth-the-billions I share this because you don’t see too many national news articles on PCORI – I am not making any sort of political statement.The aspirin study is mentioned in passin

Re: Babel updates

e tries to open your demographics folder on babel we get a message: The following error has occurred: Database error On May 26, 2015, at 10:10 AM, Hickman, Hubert B mailto:huhick...@nebraskamed.com>> wrote: I’ve finally spent some development/brain cycles working on automating our babel

Oracle->Postgresql info

This the timing for the initial full-up run of our identified instance load: The final tally of time: · Metadata and concept_dimension sync (deid => postgresql) 10 minutes · Loading of facts from prototype fact tables: 580 minutes · Creation of fact table indexes : 878 m

Babel updates

I’ve finally spent some development/brain cycles working on automating our babel updates here at UNMC. It now takes about 2.5 minutes for our babel update to happen now – using some of the same ideas used to move our Oracle data into Postgresql to construct the new identified warehouse. I ha

standing up an identified i2b2 instance on Postgresql

I made a passing comment in one of the past gpc-dev weekly calls about UNMC standing up an identified i2b2 on Postgresql. Dan asked if I would be willing to spend part of an upcoming gpc-dev call to present what we did, and I will happily do so. I wrote scripts that move data from Oracle into

Tickets for PCORnet Antibiotic and Bariatric study SQL

UNMC submitted our counts last night for this study — I’ve attached the SQL we used to the tickets. Ticket 277 (Antibiotic study) Ticket 278 (Bariatric study) Hubert Hickman Sys

Re: GPC_TERMS Table

Phil – Here is the GPC_ENCOUNTER_TERMS (just did a quick export of them) - they appear to be CDMV1 terms. Hubert Hickman Systems Sr. Analyst huhick...@nebraskamed.com (402) 559-4838 From: , Laurel A mailto:verhagen.lau...@mcrf.mfldclin.edu>> Date: Tuesday, April 21, 2015 at 12:50 PM To: Phillip

GPC-DEV meeting minutes for 3/24/2015

https://docs.google.com/document/d/14ZoC6ZcgVpqUHodYEkCTrv8caYliPLoEWe8cwxQDKFY/edit# MARCH 24, 2015 GPC Dev meeting notes 1. Convene, take roll, review records and plan next meeting. * ​Meeting ID and access code: 817-393-381; ca

i2b2 V1.7.04

See Mike’s message below. A bug that kept temporal queries from being reloaded has been fixed in 1.7.04. As Mike points out – when a site upgrades that the users should toss their browser cache or they may get some rather oddball behaviors. Hubert Hickman Applications Sr. Analyst huhick...@ne

Meeting notes for 11/18

https://docs.google.com/document/d/18EVk8xyca2QUjBHJ13l5ASXOUA9Fg87Bp9e-4gVhvgU/edit?usp=sharing All should be able to edit. Hubert Hickman Applications Sr. Analyst huhick...@nebraskamed.com (402) 559-4838 Nebraska Medicine E-mail Confidentiality Disclaimer The

Meeting notes for 10/14/2014

https://docs.google.com/document/d/1wn2Zl3FuQShqkuX1MytNX2xYOYEN284bIjuEY5DH0jM/edit?usp=sharing All should be able to view/edit. Hubert Hickman Applications Sr. Analyst huhick...@nebraskamed.com (402) 559-4838 Nebraska Medicine E-mail Confidentiality Disclaimer

Google document link for 9/9/2014

https://docs.google.com/document/d/18EMSbE6W130smhjlgcXSQAzAQBStt_nPlIg-EJorxJg/edit?usp=sharing Should be open to everyone to view/edit. Hubert Hickman Applications Sr. Analyst The Nebraska Medical Center, Zip 5030 huhick...@nebraskamed.com (402) 559-4838 The

PCORI CDM Race codes

Just a ping to see what others are doing - but for patients with more than one race recorded we can either pick one of those races and use that for PCORI purposes or we can have any patient that has more than one race recorded map to "Multiple race" for PCORI purposes? The latter seems most cor

FW: Does i2b2 Ontology support Multiple Inheritance of Concept ?

(memb...@i2b2aug.org); Hickman, Hubert B; Karthik Tumu; Munns, Michael B; Patrick Ryan Subject: RE: Does i2b2 Ontology support Multiple Inheritance of Concept ? Hi Parsa, I respect your use case of an interoperable database to support medication surveillance upon which OMOP is based, but that is

RE: i2b2 Queries

27, 2014 1:16 PM To: Murphy, Shawn N.; Phillips, Lori C. Cc: gpc-dev@listserv.kumc.edu<https://urldefense.proofpoint.com/v1/url?u=http://mailto:gpc-dev%40listserv.kumc.edu&k=PmKqfXspAHNo6iYJ48Q45A%3D%3D%0A&r=7jqROYnRJZ%2FRUK29eXLgd84I9Ih235HbTh2w98KlP4I%3D%0A&m=pDdvQD%2Biwpb1alvTBMP8roYfCDj%2BfTL8t4gdGC2pkoo%3D%0A&s=71ebd848b61b30

RE: PCORI Mapping

I see that in the code now, but no mention of it in the i2b2 documentation? From: Dan Connolly [mailto:dconno...@kumc.edu] Sent: Thursday, July 24, 2014 3:17 PM To: Hickman, Hubert B; Phillip Reeder; gpc-dev@listserv.kumc.edu Subject: RE: PCORI Mapping no way to do dates in observation_fact

RE: PCORI Mapping

Since observation_fact seems to have no good way to represent a date fact natively, we could use an integer to represent the date as a Julian date, which we could convert back to a 'regular' date when needed. I don't know if I like this though - but it is one way to express a date fact in the o

Revised LOINC metadata on PCORI deskotp

I have placed a revised LOINC metadata export file in the GPC i2b2 metadata folder (loincv3_unmc_export.csv). This file has the LOINC hierarchy starting at the Laboratory Measurements and Clinical Measurements levels - the per discussions of sometime back. I have uploaded a table_access_loincv

RE: gpc-dev agenda July 15

Link for google doc….. https://docs.google.com/document/d/15RwFQbMegtZfxtGwik4Fx9Lwx6M_FB1XZGiDOdF9iDM/edit?usp=sharing From: gpc-dev-boun...@listserv.kumc.edu [mailto:gpc-dev-boun...@listserv.kumc.edu] On Behalf Of Dan Connolly Sent: Tuesday, July 15, 2014 10:10 AM To: gpc-dev@listserv.kumc.edu

RE: Weight units

ounds/grams/kilos. The metadata xml which contains the unit conversions used in the above testing is : 3.02 06/11/2014 07:00:00 3141-9 LOINC:3141-9 Weight PosFloat H Y OUNCES POUNDS 16 GRAMS 0.035274 KILOGRAMS 35.274 0 64000 64000 From: Campbell, James R

Re: [gpc-informatics] #114: Milestone 2.7 GPC harmonizes with PCORI CDM V1.0

ll, James R [campb...@unmc.edu<mailto:campb...@unmc.edu>] Sent: Sunday, June 01, 2014 10:40 AM To: Hickman, Hubert B Cc: Dan Connolly; gpc-dev@listserv.kumc.edu<mailto:gpc-dev@listserv.kumc.edu>; nwil...@uwhealth.org<mailto:nwil...@uwhealth.org>; John Steinmetz Subject: Re: [gpc-in

RE: [gpc-informatics] #114: Milestone 2.7 GPC harmonizes with PCORI CDM V1.0

correct concept codes for that site, we can interoperate just fine, I think. HH From: Campbell, James R [campb...@unmc.edu] Sent: Sunday, June 01, 2014 8:50 AM To: Hickman, Hubert B; Dan Connolly; gpc-dev@listserv.kumc.edu; nwil...@uwhealth.org Cc: John Steinmetz

RE: [gpc-informatics] #114: Milestone 2.7 GPC harmonizes with PCORI CDM V1.0

Let me give a concrete example: Here is the relevant bits of the XML that Dan is referring to - in this case a query for BMI >19, using a slightly modified LOINC metadata table 4 39156-5: Body mass inde

RE: CPT metadata

If you wouldn't mind sharing the more the merrier.. From: Wilson Nathan [mailto:nwil...@uwhealth.org] Sent: Thursday, May 15, 2014 12:28 PM To: 'Dan Connolly'; Phillip Reeder; Hickman, Hubert B; gpc-dev@listserv.kumc.edu Subject: RE: CPT metadata I can also share the file that

CPT metadata

Does anyone have CPT metadata that they are willing to share? (Or am I missing it in the some of the standard metadata?) Hubert Hickman P/A III The Nebraska Medical Center, Zip 5030 huhick...@nebraskamed.com (402) 559-4838 The Nebraska Medical Center E-mail Con

Link for site to generate diagrams from SQL statements

During the Wednesday conference call, there was mention of a site that automagically generates diagrams from SQL statements. Can the URL be passed along? I (and suspect other folks who write SQL) would find such a site to be very handy on occasion. Hubert Hickman ___