[gpc-informatics] #296: breast cancer stage, receptor status, treatment from EMR

2015-06-29 Thread GPC Informatics
<http://informatics.gpcnetwork.org/trac/Project/ticket/296> 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-informatics] #296: breast cancer stage, receptor status, treatment from EMR

2015-06-29 Thread GPC Informatics
... I don't know about radiation, endocrine or hormonal therapy. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/296#comment:1> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics __

Re: [gpc-informatics] #293: Report SAS and RDBMS version and packages to DSSNI

2015-06-29 Thread GPC Informatics
| Resolution: Keywords: | Blocked By: Blocking: | ---+-- Changes (by dconnolly): * milestone: cohort-char1 => data-quality-q2 -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/293#comment:6> gpc-in

Re: [gpc-informatics] #80: assessment of GPC vs. data privacy and security standards

2015-06-29 Thread GPC Informatics
CMH. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/80#comment:22> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.k

Re: [gpc-informatics] #284: Deploy GPC ALS Survey at GPC sites

2015-06-29 Thread GPC Informatics
n from UIOWA would be ideal, though we understand they're all set. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/284#comment:4> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics

Re: [gpc-informatics] #80: assessment of GPC vs. data privacy and security standards

2015-06-30 Thread GPC Informatics
familiar with the specific policies and protocols of the site, rather than questions Cerner can answer. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/80#comment:23> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network -

Re: [gpc-informatics] #80: assessment of GPC vs. data privacy and security standards

2015-06-30 Thread GPC Informatics
x27;s responses were submitted as KUMC with a note at the bottom of the survey clarifying that they are for CMH. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/80#comment:24> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Netw

Re: [gpc-informatics] #293: Report SAS and RDBMS version and packages to DSSNI

2015-06-30 Thread GPC Informatics
t;http://informatics.gpcnetwork.org/trac/Project/ticket/293#comment:7> 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-informatics] #205: interim builder for breast cancer cohort summary

2015-06-30 Thread GPC Informatics
, bradley-mcdowell@… (removed) Comment: See also UTHSCSA scripts: ticket:217#comment:18 -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/205#comment:16> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network -

Re: [gpc-informatics] #191: represent PCORI CDM 2.x terminology as i2b2 metadata

2015-06-30 Thread GPC Informatics
(ticket:240#comment:6), as well as shared development costs with SCILHS going forward. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/191#comment:3> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics _

Re: [gpc-informatics] #291: Gather 2015 2nd quarterly QA results

2015-06-30 Thread GPC Informatics
ve got some code: [https://bitbucket.org/jvanschyndle/gpc-2015-q2-qa- files/commits/4d7def85af3604448c0aac7dff5bbdeecfcc1948 4d7def8] Who wants to try it out? -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/291#comment:6> gpc-informatics <http://informatics.gpcn

Re: [gpc-informatics] #296: breast cancer stage, receptor status, treatment from EMR

2015-07-01 Thread GPC Informatics
network.org/trac/Project/ticket/296#comment:2> 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-informatics] #293: Report SAS and RDBMS version and packages to DSSNI

2015-07-01 Thread GPC Informatics
hat database system is used to hoset and extract the PCORnet data at your site||Oracle|| ||(7) What SAS version and modules are available at your site?||Campus SAS license|| Please complete ASAP. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/293#comment:8> gpc-informat

Re: [gpc-informatics] #293: Report SAS and RDBMS version and packages to DSSNI

2015-07-01 Thread GPC Informatics
Dictionary is not specific enough to provide this. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/293#comment:9> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing

Re: [gpc-informatics] #227: Data QA for Breast Cancer Finder File

2015-07-01 Thread GPC Informatics
: | -+- Comment (by bzschoche): As updated on the 7.1.15 Breast Cancer Survey webinar, UNMC and UTSW are also approved for mailing. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/227#comment:37> gpc-informatics <http://informatics.gpcnetwork.org/

[gpc-informatics] Batch modify: #295, #296, #297, #298, #214, #265

2015-07-02 Thread GPC Informatics
ohort characterization. re #296, Russ put together EMR_BC_Criteria [7-2-2015] [rwait...@kumc.edu] -- Tickets URL: <http://informatics.gpcnetwork.org/trac/Project/query?id=295%2C296%2C297%2C298%2C214%2C265> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Netw

Re: [gpc-informatics] #296: breast cancer treatment from EMR (was: breast cancer stage, receptor status, treatment from EMR)

2015-07-02 Thread GPC Informatics
t getting stage, receptor status from the EMR isn't feasible in our timeframe. Otherwise, I think I have what I need to build a query (#295) including treatment. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/296#comment:4> gpc-informatics <http://inf

Re: [gpc-informatics] #227: Data QA for Breast Cancer Finder File

2015-07-02 Thread GPC Informatics
: <http://informatics.gpcnetwork.org/trac/Project/ticket/227#comment:38> 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-informatics] #80: assessment of GPC vs. data privacy and security standards

2015-07-06 Thread GPC Informatics
up. Patrick sent mail June 30. Also, Tom Mish called me to catch up on things and said he'd bring this to Umberto's attention. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/80#comment:25> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Pla

Re: [gpc-informatics] #284: Deploy GPC ALS Survey at GPC sites

2015-07-06 Thread GPC Informatics
ment:5> 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-informatics] Batch modify: #154, #117, #166, #161, #162

2015-07-06 Thread GPC Informatics
Batch modification to #154, #117, #166, #161, #162 by dconnolly: milestone to data-quality-q2 Comment: moving popmednet tickets to milestone:data-quality-q2 phasing out milestone:data-agg1 -- Tickets URL: <http://informatics.gpcnetwork.org/trac/Project/query?id=154%2C117%2C166%2C161%2C162&g

Re: [gpc-informatics] #280: Medication ontology orgainzed by ingredient

2015-07-07 Thread GPC Informatics
: Keywords: | Blocked By: Blocking: | -+--- Changes (by dconnolly): * priority: major => minor -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/280#comment:4> gpc-informat

Re: [gpc-informatics] #293: Report SAS and RDBMS version and packages to DSSNI

2015-07-07 Thread GPC Informatics
compiled to date. We are waiting on information from two sites (Medical College of Wisconsin and University of Iowa). [table] -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/293#comment:10> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Pl

Re: [gpc-informatics] #293: Report SAS and RDBMS version and packages to DSSNI

2015-07-07 Thread GPC Informatics
| Resolution: Keywords: | Blocked By: Blocking: | ---+-- Comment (by btaylor): MCW information added to the google doc -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/293#comment:11> gpc-informatics

Re: [gpc-informatics] #293: Report SAS and RDBMS version and packages to DSSNI

2015-07-07 Thread GPC Informatics
| Resolution: Keywords: | Blocked By: Blocking: | ---+- Changes (by btaylor): * owner: gkowalski => Prakash-Nadkarni@… -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/293#comment:1

Re: [gpc-informatics] #293: Report SAS and RDBMS version and packages to DSSNI

2015-07-07 Thread GPC Informatics
er field. :-/ -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/293#comment:13> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://lists

Re: [gpc-informatics] #293: Report SAS and RDBMS version and packages to DSSNI

2015-07-07 Thread GPC Informatics
ticket/293#comment:14> 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-informatics] #284: Deploy GPC ALS Survey at GPC sites

2015-07-07 Thread GPC Informatics
roject/ticket/284#comment:6> 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-informatics] #284: Deploy GPC ALS Survey at GPC sites

2015-07-07 Thread GPC Informatics
0. UTSW - already collecting responses as of 23 June -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/284#comment:7> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mai

Re: [gpc-informatics] #293: Report SAS and RDBMS version and packages to DSSNI

2015-07-07 Thread GPC Informatics
<http://informatics.gpcnetwork.org/trac/Project/ticket/293#comment:15> 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-informatics] #253: obesity survey REDCap tracker and tools

2015-07-09 Thread GPC Informatics
home state based upon what I see in the query instructions). Is it the intention that this study be limited to a site's home state? Or should it be constrained by geolocation data (50 miles from center or similar?) -- Ticket URL: <http://informatics.gpcnetwork.org/tr

Re: [gpc-informatics] #253: obesity survey REDCap tracker and tools

2015-07-09 Thread GPC Informatics
ntioned, this probably does not translate to your institution. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/253#comment:23> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc

Re: [gpc-informatics] #253: obesity survey REDCap tracker and tools

2015-07-10 Thread GPC Informatics
below): {{{#!python def loadID(self, id_loader): ... --and upper(pd.state_cd) = '&&state_long' }}} -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/253#comment:24> gpc-informatics <http://informatics.gpcnetwork.org/> Greate

Re: [gpc-informatics] #240: Data Characterization queries for phase 1 CDM V1 compliance

2015-07-10 Thread GPC Informatics
: -+- Comment (by susandm): Has this call been scheduled? -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/240#comment:13> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network -

Re: [gpc-informatics] #80: assessment of GPC vs. data privacy and security standards

2015-07-10 Thread GPC Informatics
rac/Project/ticket/80#comment:26> 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-informatics] #240: Data Characterization queries for phase 1 CDM V1 compliance

2015-07-10 Thread GPC Informatics
RL: <http://informatics.gpcnetwork.org/trac/Project/ticket/240#comment:14> 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-informatics] #240: Data Characterization queries for phase 1 CDM V1 compliance

2015-07-13 Thread GPC Informatics
: -+- Comment (by susandm): Thanks! I wondered and wanted to attend but could not find the call in info. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/240#comment:15> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Pl

Re: [gpc-informatics] #240: Data Characterization queries for phase 1 CDM V1 compliance

2015-07-13 Thread GPC Informatics
<http://informatics.gpcnetwork.org/trac/Project/ticket/240#comment:16> 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-informatics] #291: Gather 2015 2nd quarterly QA results

2015-07-14 Thread GPC Informatics
LP29693-6\LP7784-4\1558-6\ (1558-6: Fasting glucose [398797 facts; 150656 patients]) -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/291#comment:8> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics _

[gpc-informatics] #308: LEA Feasibility Query

2015-07-14 Thread GPC Informatics
feasibility requests. Please update this ticket when your institution has completed the queries and sent the numbers with estimated time to Tamara. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/308> gpc-informatics <http://informatics.gpcnetwork.org/> Gr

Re: [gpc-informatics] #308: LEA Feasibility Query

2015-07-14 Thread GPC Informatics
: | ---+--- Changes (by tmcmahon): * cc: meiliu (added) * status: new => accepted -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/308#comment:1> gpc-informatics <http://informatics.gpcnetwork.org/> Greater

Re: [gpc-informatics] #253: obesity survey REDCap tracker and tools

2015-07-15 Thread GPC Informatics
s. Thanks! Laurel -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/253#comment:25> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu

Re: [gpc-informatics] #253: obesity survey REDCap tracker and tools

2015-07-15 Thread GPC Informatics
/gpc- d...@listserv.kumc.edu/msg01992.html. Because UTHSCSA is not using email for the obesity survey, '''I'd appreciate it if another site could respond''' about how they pull parental email data. -- Ticket URL: <http://informatics.gpcnetwork.org/t

Re: [gpc-informatics] #291: Gather 2015 2nd quarterly QA results

2015-07-16 Thread GPC Informatics
amter: * ''Record format: The file to be uploaded has its records stored as separate **Columns**'' -TM -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/291#comment:9> gpc-informatics <http://informatics.gpcnetwork.org/>

Re: [gpc-informatics] #291: Gather 2015 2nd quarterly QA results

2015-07-16 Thread GPC Informatics
EDCap project to upload/import the file? Can you advise? Thanks. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/291#comment:10> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics __

Re: [gpc-informatics] #291: Gather 2015 2nd quarterly QA results

2015-07-17 Thread GPC Informatics
Tool now. As a side note: ensure that Record ID is set to all upper case. I noticed that after running the script, mine was "Wisc" instead of "WISC". A simple edit corrected that. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/291#comment:11

Re: [gpc-informatics] #291: Gather 2015 2nd quarterly QA results

2015-07-20 Thread GPC Informatics
`. Are we supposed to change this to the age range concepts used at our site? -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/291#comment:12> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network -

Re: [gpc-informatics] #291: Gather 2015 2nd quarterly QA results

2015-07-20 Thread GPC Informatics
ange the age ranges, Angela? -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/291#comment:13> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@li

Re: [gpc-informatics] #253: obesity survey REDCap tracker and tools

2015-07-20 Thread GPC Informatics
gela Bos, the tracker seems stable as of b85e0b6 Jul 15. We can re-open this if evaluation by Hubert or anyone else turns up critical issues. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/253#comment:27> gpc-informatics <http://informatics.gpcnetwork.org/> Greate

[gpc-informatics] Batch modify: #240, #154, #117, #166, #161, #162

2015-07-20 Thread GPC Informatics
166%2C161%2C162> 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-informatics] #291: Gather 2015 2nd quarterly QA results

2015-07-20 Thread GPC Informatics
ted format. Please try again." Fixed. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/291#comment:14> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing lis

Re: [gpc-informatics] #291: Gather 2015 2nd quarterly QA results

2015-07-20 Thread GPC Informatics
), so I missed it. Sorry, that's been fixed. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/291#comment:15> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mai

Re: [gpc-informatics] #291: Gather 2015 2nd quarterly QA results

2015-07-20 Thread GPC Informatics
joining results and SQL was selecting the first result it found. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/291#comment:16> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___

Re: [gpc-informatics] #240: Data Characterization queries for phase 1 CDM V1 compliance

2015-07-21 Thread GPC Informatics
/Project/ticket/240#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-informatics] #284: Deploy GPC ALS Survey at GPC sites

2015-07-21 Thread GPC Informatics
10. UTSW - already collecting responses as of 23 June -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/284#comment:8> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-de

Re: [gpc-informatics] #253: obesity survey REDCap tracker and tools

2015-07-21 Thread GPC Informatics
tient has email address Y/N" to our demographics load would be a handy thing. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/253#comment:28> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics _

Re: [gpc-informatics] #253: obesity survey REDCap tracker and tools

2015-07-21 Thread GPC Informatics
059'' -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/253#comment:29> 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-informatics] #291: Gather 2015 2nd quarterly QA results

2015-07-23 Thread GPC Informatics
/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/2

Re: [gpc-informatics] #263: Adaptable cohort query design and administration

2015-07-23 Thread GPC Informatics
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 _

Re: [gpc-informatics] #285: HbA1c and other laboratory data: data quality check, CDM ETL

2015-07-27 Thread GPC Informatics
nder what LOINC code people are using. The top google hit is: [http://r.details.loinc.org/LOINC/4548-4.html?sections=Comprehensive 4548-4 Hemoglobin A1c/​Hemoglobin.total in Blood]. I haven't checked babel. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/285#com

Re: [gpc-informatics] #227: Data QA for Breast Cancer Finder File

2015-07-27 Thread GPC Informatics
and which of the 9 are the 8. Tamara, Brittany, I don't see anything related to breast cancer surveys that merits discussion in SoftwareDev this week (tomorrow). Let us know if you prefer otherwise. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/

Re: [gpc-informatics] #227: Data QA for Breast Cancer Finder File

2015-07-27 Thread GPC Informatics
g/trac/Project/ticket/227#comment:40> 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-informatics] #240: Data Characterization queries for phase 1 CDM V1 compliance

2015-07-27 Thread GPC Informatics
g/trac/Project/ticket/240#comment:19> 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-informatics] #291: Gather 2015 2nd quarterly QA results

2015-07-27 Thread GPC Informatics
<http://informatics.gpcnetwork.org/trac/Project/ticket/291#comment:19> 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-informatics] #291: Gather 2015 2nd quarterly QA results

2015-07-27 Thread GPC Informatics
ttp://informatics.gpcnetwork.org/trac/Project/ticket/291#comment:20> 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-informatics] #291: Gather 2015 2nd quarterly QA results

2015-07-27 Thread GPC Informatics
ould you change the age ranges, Angela? Sorry, please allow me to retract the question. It was based on a faulty assumption after looking at the input file but before looking at the SQL code. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/291#comment:21> gpc-inf

Re: [gpc-informatics] #291: Gather 2015 2nd quarterly QA results

2015-07-27 Thread GPC Informatics
by Wednesday. Sorry, results have delayed by my attendance at the PMN conference. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/291#comment:22> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Networ

Re: [gpc-informatics] #240: Data Characterization queries for phase 1 CDM V1 compliance

2015-07-28 Thread GPC Informatics
st )m; exit }}} The other one that does not complete is the same query except for weight. In the above example using Oracle's MEDIAN function will help cure some of the ills along with factoring out some of the subselects. I will rewrite and send feedback for these two in parti

Re: [gpc-informatics] #285: HbA1c and other laboratory data: data quality check, CDM ETL

2015-07-28 Thread GPC Informatics
Tom says next time. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/285#comment:4> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listser

Re: [gpc-informatics] #240: Data Characterization queries for phase 1 CDM V1 compliance

2015-07-28 Thread GPC Informatics
s not null UNION SELECT 'NULL or missing' AS Statistic, COUNT(*) AS wt FROM Vital WHERE wt IS NULL UNION SELECT 'record_n' AS Statistic, COUNT(*) AS wt FROM Vital WHERE wt IS NOT NULL )csv ORDE

Re: [gpc-informatics] #308: LEA Feasibility Query

2015-07-29 Thread GPC Informatics
: | ---+--- Comment (by tmcmahon): Patient counts received from UTSW. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/308#comment:2> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network -

Re: [gpc-informatics] #240: Data Characterization queries for phase 1 CDM V1 compliance

2015-07-29 Thread GPC Informatics
ket/240#comment:22> 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-informatics] #291: Gather 2015 2nd quarterly QA results

2015-07-30 Thread GPC Informatics
hope to be finished this week. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/291#comment:25> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@

Re: [gpc-informatics] #80: assessment of GPC vs. data privacy and security standards

2015-07-30 Thread GPC Informatics
ttp://informatics.gpcnetwork.org/trac/Project/ticket/80#comment:27> 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-informatics] #253: obesity survey REDCap tracker and tools

2015-07-31 Thread GPC Informatics
\\[a9cef5738229] Angela Bos 85. add config option to access clarity tables over a database link \\[35fe2794a4f0] Dan Connolly https://bitbucket.org/DanC/survey_tracker/overview -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/253#comment:30> gpc-informatics

Re: [gpc-informatics] #253: obesity survey REDCap tracker and tools

2015-07-31 Thread GPC Informatics
://bitbucket.org/bos_uthscsa/survey_tracker/overview default repo]. You can get some overview stats by running this: `$ python tracker_load.py stats` -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/253#comment:31> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Pl

Re: [gpc-informatics] #80: assessment of GPC vs. data privacy and security standards

2015-08-03 Thread GPC Informatics
. How about you send it to gpc-dev@listserv.kumc.edu? -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/80#comment:28> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc

Re: [gpc-informatics] #291: Gather 2015 2nd quarterly QA results

2015-08-03 Thread GPC Informatics
ent:26> 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-informatics] #327: Gather 2015 3rd quarterly QA results

2015-08-03 Thread GPC Informatics
#x27;'#tbd'' - Better support for QA results on Oracle Server -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/327> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___

Re: [gpc-informatics] #291: Gather 2015 2nd quarterly QA results

2015-08-03 Thread GPC Informatics
. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/291#comment:27> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc

Re: [gpc-informatics] #327: Gather 2015 3rd quarterly QA results

2015-08-04 Thread GPC Informatics
re that we have full ethnicity and race questions tackled. -- -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/327#comment:1> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gp

Re: [gpc-informatics] #308: LEA Feasibility Query

2015-08-04 Thread GPC Informatics
: | ---+--- Comment (by mish): Counts and time spent sent to Tamara from WISC. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/308#comment:3> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Pl

Re: [gpc-informatics] #191: represent PCORI CDM 2.x terminology as i2b2 metadata

2015-08-04 Thread GPC Informatics
inserted the TABLE_ACCESS rows twice. I hope that's not too much of a distraction. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/191#comment:6> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics _

Re: [gpc-informatics] #295: breast cancer correspondence between EHR and tumor registry variables - i2b2 query

2015-08-04 Thread GPC Informatics
ntified. This should suffice for an initial investigation, but I suppose we need to mix in all the stuff from #204 before it's finished. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/295#comment:5> gpc-informatics <http://informatics.gpcnetwork.org/> Grea

Re: [gpc-informatics] #295: breast cancer correspondence between EHR and tumor registry variables - i2b2 query

2015-08-04 Thread GPC Informatics
chemo meds from MCRF and the rest from KUMC. Is that an issue? We'll see. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/295#comment:6> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Netw

Re: [gpc-informatics] #240: Data Characterization queries for phase 1 CDM V1 compliance

2015-08-06 Thread GPC Informatics
s complete. Take Deux, here we go ! -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/240#comment:23> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing

Re: [gpc-informatics] #308: LEA Feasibility Query

2015-08-07 Thread GPC Informatics
: | ---+--- Comment (by gbushee): MCW counts and times sent to Tamara today. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/308#comment:4> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Pl

Re: [gpc-informatics] #161: PopMedNet node at CMH

2015-08-07 Thread GPC Informatics
.org/trac/Project/ticket/161#comment:14> 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-informatics] #291: Gather 2015 2nd quarterly QA results

2015-08-10 Thread GPC Informatics
ee fit, but this is done to my satisfaction. If you think it's worth more group attention, go ahead and re-open it. For follow-up work, see milestone:data-quality-q3 -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/291#comment:28> gpc-

Re: [gpc-informatics] #308: LEA Feasibility Query

2015-08-10 Thread GPC Informatics
gpcnetwork.org/trac/Project/ticket/308#comment:5> 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-informatics] #80: assessment of GPC vs. data privacy and security standards

2015-08-10 Thread GPC Informatics
ttp://informatics.gpcnetwork.org/trac/Project/ticket/80#comment:29> 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-informatics] #80: assessment of GPC vs. data privacy and security standards

2015-08-10 Thread GPC Informatics
-sharing | Resolution: Keywords: security | Blocked By: 79 Blocking:| --+- Changes (by dconnolly): * owner: mish => bzschoche -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/80#comment:3

Re: [gpc-informatics] #240: Data Characterization queries for phase 1 CDM V1 compliance

2015-08-10 Thread GPC Informatics
d' -e '/^\s*$/d' > $MYFILE }}} The scripts are running once more. There may be more elegant solutions, but `sed` works. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/240#comment:24> gpc-informatics

Re: [gpc-informatics] #166: PopMedNet node at WISC

2015-08-11 Thread GPC Informatics
. Closing ticket. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/166#comment:11> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.k

Re: [gpc-informatics] #166: PopMedNet node at WISC

2015-08-11 Thread GPC Informatics
:| Blocked By: 209 Blocking:| --+-- Changes (by kwanta): * status: reopened => closed * resolution: => fixed -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/166#comment:12> gpc

Re: [gpc-informatics] #327: Gather 2015 3rd quarterly QA results

2015-08-12 Thread GPC Informatics
twork.org/trac/Project/ticket/327#comment:2> 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-informatics] #327: Gather 2015 3rd quarterly QA results

2015-08-12 Thread GPC Informatics
'll create a ticket for George. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/327#comment:3> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@li

Re: [gpc-informatics] #191: represent PCORI CDM 2.x terminology as i2b2 metadata

2015-08-14 Thread GPC Informatics
er teams won't have for some time. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/191#comment:7> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev

Re: [gpc-informatics] #191: represent PCORI CDM 2.x terminology as i2b2 metadata

2015-08-14 Thread GPC Informatics
Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/191#comment:8> 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-informatics] #80: assessment of GPC vs. data privacy and security standards

2015-08-17 Thread GPC Informatics
URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/80#comment:31> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mail

<    2   3   4   5   6   7   8   9   10   11   >