Hi Mei, I have attached our mapping logic for pulling data out of our CDR. We have a transformation between clarity and the CDR so I had to include some additional fields at the top of the document that are used in the main ENC_TYPE mapping. I tried to include all table names in the sql so you should be able to see where everything is coming from. If any fields aren't labeled they probably come from one of: PAT_ENC, PAT_ENC_HSP, or HSP_ACCOUNT. Let me know if it needs additional clarification.
Regards, Andrew Hangsleben On Mon, Mar 27, 2017 at 11:41 AM, Mei Liu <[email protected]> wrote: > Do any GPC sites other than KUMC can share how they mapped their hospital > visits to PCORnet AV, OA, etc.? > > Thanks, > > > > Mei > > > > *From:* Dan Connolly > *Sent:* Thursday, February 23, 2017 4:04 PM > *To:* Mei Liu; Russ Waitman > *Cc:* Brittany Zschoche > *Subject:* RE: NextD - question about data reported in EDC to PCORnet > > > > #2 looks like the same question we discussed in the "AV vs OA trends" > thread with Alona. Does my answer there about pcornet_mapping.csv > <https://github.com/kumc-bmi/i2p-transform/blob/master/Oracle/pcornet_mapping.csv> > and such suffice? > > -- > Dan > ------------------------------ > > *From:* Mei Liu > *Sent:* Thursday, February 23, 2017 3:54 PM > *To:* Dan Connolly; Russ Waitman > *Cc:* Brittany Zschoche > *Subject:* RE: NextD - question about data reported in EDC to PCORnet > > Dan, would you know the answer to question #2? > > > > Mei > > > > *From:* Dan Connolly > *Sent:* Thursday, February 23, 2017 3:51 PM > *To:* Mei Liu; Russ Waitman > *Cc:* Brittany Zschoche > *Subject:* RE: NextD - question about data reported in EDC to PCORnet > > > > The redcap project where we collected the EDC report captured a contact > person for each submission. That's the person to ask. > > > > -- > > Dan > > > ------------------------------ > > *From:* Mei Liu > *Sent:* Thursday, February 23, 2017 12:28 PM > *To:* Dan Connolly; Russ Waitman > *Cc:* Brittany Zschoche > *Subject:* NextD - question about data reported in EDC to PCORnet > > Hi Dan and Russ, > > > > For the NextD project, NU compared the time trends in visit rates for > GPC sites to theirs (see graph in attached doc). Two questions came up. > > 1. Data anomaly – specifically Indiana and UTSW reports had spikes > in their data that might be a data problem. Where does it come from? > > 2. Across sites, very different patterns for the proportions of > different visit **types** are seen (see table in attached doc). KUMC has > 28.3% “ambulatory visits” but 0% for “other ambulatory”. Why do we have so > many nulls in “other ambulatory”? How was AV vs. OA coded? What assumptions > were made during the translation from i2b2 to CDM? > > > > Bernie has contacted Dan Hood directly regarding Indiana’s data. Is > Phillip Reeder the person I should contact at UTSW regarding the data > problem? > > > > Thank you! > > > > Mei > > ------------------------------------------------- > > *Mei Liu, PhD* > > Assistant Professor > > Department of Internal Medicine > > Division of Medical Informatics > > University of Kansas Medical Center > > Office: 913-945-6446 <(913)%20945-6446> > > Fax: 913-588-4880 <(913)%20588-4880> > > > > _______________________________________________ > Gpc-dev mailing list > [email protected] > http://listserv.kumc.edu/mailman/listinfo/gpc-dev > > -- Andrew Hangsleben Developer/Analyst Academic Health Center - Information Systems <http://hub.ahc.umn.edu/ahc-information-systems> University of Minnesota Phone: (612) 625-1285 Email: [email protected]
enc_type_mapping.sql
Description: Binary data
_______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
