Sorry, that should read as ZC_DISP_ENC_TYPE.NAME not ZC_DISP_ENC.TYPE. On Mon, Mar 27, 2017 at 12:09 PM, Andrew Hangsleben <[email protected]> wrote:
> 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] > -- 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]
_______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
