Re: [gpc-informatics] #263: Adaptable cohort query design and administration
#263: Adaptable cohort query design and administration --+ Reporter: nateapathy| Owner: rwaitman Type: design-issue | Status: new Priority: minor | Milestone: adaptable-accrual Component: data-stds | Resolution: Keywords:| Blocked By: 276 Blocking:| --+ Comment (by bzschoche): On an ADAPTABLE IRB call on 7.23.15, we learned that Duke is now tentatively scheduling for the first ADAPTABLE patients to be enrolled in '''December 2015'''. Work on governance continues. -- Ticket URL: http://informatics.gpcnetwork.org/trac/Project/ticket/263#comment:10 gpc-informatics http://informatics.gpcnetwork.org/ Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
GPC 2nd quarter QA design looks nice!
Tom/James, I've just started working on running the GPC Q2 quality queries here at KUMC and wanted to say that the design looks pretty slick! I really like having the concept paths, codes, etc. split out into their own xlsx/csv file that loads nicely into REDCap to begin with. I think that'll make it a lot easier to port to various sites. Now, on to actually gathering results... Refs: * WISC BitBucket: gpc-2015-q2-qa-fileshttps://bitbucket.org/jvanschyndle/gpc-2015-q2-qa-files * My fork on BitBucket: gpc-2015-q2-qa-fileshttps://bitbucket.org/njgraham/gpc-2015-q2-qa-files Regards, Nathan ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
Re: [gpc-informatics] #291: Gather 2015 2nd quarterly QA results
#291: Gather 2015 2nd quarterly QA results --+--- Reporter: mish | Owner: bos Type: problem | Status: assigned Priority: major | Milestone: data-quality-q2 Component: data-quality | Resolution: Keywords:| Blocked By: 259, 281, 285, 290, 306, 309 Blocking:| --+--- Comment (by bos): In [https://bitbucket.org/jvanschyndle/gpc-2015-q2-qa- files/src/1b9cf89ef8bdec77c474e2ed8adfe1b6e0ac910a/Q2_2015_GPC_QA.sql?at=default Q2_2015_GPC_QA.sql], `/* Encounters with No ICD 9 Code */` uses the result of `'num_valid_icd9'` which hasn't yet been populated. Am I missing something? -- Ticket URL: http://informatics.gpcnetwork.org/trac/Project/ticket/291#comment:18 gpc-informatics http://informatics.gpcnetwork.org/ Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
RE: GPC 2nd quarter QA design looks nice!
Let us know how it goes, I have had to rewrite a couple of queries, one that took 17 min to update 3 rows, one due to our differences. I am now having another that will not return. Has anyone else had issues on an Oracle DB? Michael Munns Database Analyst 402-559-3821 From: gpc-dev-boun...@listserv.kumc.edu [mailto:gpc-dev-boun...@listserv.kumc.edu] On Behalf Of Nathan Graham Sent: Thursday, July 23, 2015 10:47 AM To: GPC-DEV@LISTSERV.KUMC.EDU; Thomas Mish; James Van Schyndle (jvanschyn...@wisc.edu) Subject: GPC 2nd quarter QA design looks nice! Tom/James, I've just started working on running the GPC Q2 quality queries here at KUMC and wanted to say that the design looks pretty slick! I really like having the concept paths, codes, etc. split out into their own xlsx/csv file that loads nicely into REDCap to begin with. I think that'll make it a lot easier to port to various sites. Now, on to actually gathering results... Refs: * WISC BitBucket: gpc-2015-q2-qa-fileshttps://bitbucket.org/jvanschyndle/gpc-2015-q2-qa-files * My fork on BitBucket: gpc-2015-q2-qa-fileshttps://bitbucket.org/njgraham/gpc-2015-q2-qa-files Regards, Nathan 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