Prakash has asked about this process so I gave him pointers and I gather he's working on it.
As an inducement for the rest of you to get your ALS data into GPC REDCap, I offer a bounty: you get to go to the bottom of the scribe list<https://informatics.gpcnetwork.org/trac/Project/ticket/12#comment:97>! Justin, UMN folks, give it a try? Let me know if you'd like me to call you to talk you through it. I'd like to run through the process with a few teams before next Tuesday's call so that it's mature and the rest can go smoothly. Summary of the process: 1. Make working copy of your site's ALS survey project 2. Copy record_id->MRN mapping 3. Build and run EMR demographics query 4. Copy EMR data into REDCap working copy 5. Convert MM/YYYY survey dates 6. Scrub PHI from free-text fields 7. Export de-identified survey+EMR data 8. Upload using the REDCap data import module for the ALS REDCap project<https://redcap.gpcnetwork.org/redcap_v6.11.5/DataImport/index.php?pid=51> For details, see: * slide presentation: ALS Data Integration<https://docs.google.com/presentation/d/137wdUY6giLCasJyZ7wxnWCAGFH2DT4Gx0vLZ17jfxhA/edit> * attachment:ALS_survey_DataDictionary.csv<https://informatics.gpcnetwork.org/trac/Project/attachment/ticket/380/ALS_survey_DataDictionary.csv><https://informatics.gpcnetwork.org/trac/Project/raw-attachment/ticket/380/ALS_survey_DataDictionary.csv> -- Dan ________________________________________ From: GPC Informatics [[email protected]] Sent: Thursday, September 01, 2016 4:55 PM To: Tamara McMahon; Dan Connolly; Bhargav Adagarla; Vincent Leonardo; [email protected]; [email protected]; [email protected]; [email protected] Cc: Brittany Zschoche; [email protected] Subject: Re: [gpc-informatics] #380: Collect ALS survey data, EMR data from participating sites #380: Collect ALS survey data, EMR data from participating sites --------------------------+------------------------------ Reporter: tmcmahon | Owner: dconnolly Type: task | Status: accepted Priority: major | Milestone: cohort-char-als Component: data-sharing | Resolution: Keywords: als-cohort | Blocked By: 245, 284, 527 Blocking: | --------------------------+------------------------------ Changes (by dconnolly): * cc: gpc-dev@… (added) * owner: schandaka => dconnolly * status: assigned => accepted Comment: I refined the process (comment:16) based on discussion with Tamara and Bhargav. In the next few days I'll try to run through it with a few other sites. Any volunteers? -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/380#comment:21> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics
_______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
