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

2016-06-14 Thread GPC Informatics
h Russ, and report to gpc-dev -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/280#comment:5> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@list

Re: [gpc-informatics] #492: How to Build SAS CDM v3 Medication Tables

2016-06-13 Thread GPC Informatics
sql#L33 epic_meds_transform.sql] -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/492#comment:23> 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] #304: accuracy of ALS diagnosis data collection

2016-05-31 Thread GPC Informatics
: Keywords: | Blocked By: Blocking: | -+-- Comment (by dconnolly): Tom: ok, I can follow up on this. (gpc-dev today) -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/304#comment:5&g

Re: [gpc-informatics] #502: PCORnet Menu-Driven Queries (MDQ) - MCRF experience

2016-05-31 Thread GPC Informatics
are distributed as json and translated to match the appropriate environment. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/502#comment:8> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___

Re: [gpc-informatics] #462: validate ADAPTABLE computable phenotype with chart review

2016-05-31 Thread GPC Informatics
t;http://informatics.gpcnetwork.org/trac/Project/ticket/462#comment:21> 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] #473: PCORnet CDMv3 SAS prep-to-research Readiness

2016-06-24 Thread GPC Informatics
: Keywords: | Blocked By: 381, 486 Blocking: 510 | -+ Changes (by lv): * owner: prakashnadkarni => jdale -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/473#comment:91> gpc-informat

Re: [gpc-informatics] #473: PCORnet CDMv3 SAS prep-to-research Readiness

2016-06-24 Thread GPC Informatics
473#comment:90> 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] #473: PCORnet CDMv3 SAS prep-to-research Readiness

2016-06-24 Thread GPC Informatics
| Resolution: Keywords: | Blocked By: 381, 486 Blocking: 510 | -+ Changes (by jdale): * owner: jdale => jay.pedersen -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/473#comment:92> gpc-in

Re: [gpc-informatics] #473: PCORnet CDMv3 SAS prep-to-research Readiness

2016-06-24 Thread GPC Informatics
: Keywords: | Blocked By: 381, 486 Blocking: 510 | -+ Changes (by lv): * owner: jay.pedersen => preeder -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/473#comment:93> gpc-informat

Re: [gpc-informatics] #349: plan HackathonThree: host/place, date, agenda

2016-01-11 Thread GPC Informatics
thonThree#agenda and Russ contributed HackathonThree#PIAgendaTopics, so that's our proposal for a detailed agenda. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/349#comment:10> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains

Re: [gpc-informatics] #267: CDM V2 Vitals.Smoking History compliance

2016-01-15 Thread GPC Informatics
fixed Comment: Jim Campbell asked me to close this ticket as we are proceeding direct to CDM V3. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/267#comment:10> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Net

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

2016-01-15 Thread GPC Informatics
ed. 3. Inconsistency in weight data was related also to an error in our extract procedure which we have corrected Jim James R. Campbell MD campb...@unmc.edu -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/240#comment:32> gpc-informatics <http://informatics.gpcnetwor

Re: [gpc-informatics] #267: CDM V2 Vitals.Smoking History compliance

2016-01-15 Thread GPC Informatics
. If the issue is addressed, very well. But otherwise, please re-open this and change the summary. (If trac doesn't seem to let you change ticket summaries, let me know and I'll do it.) -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/267#comment:11> gpc-informatics

Re: [gpc-informatics] #267: CDM V2 Vitals.Smoking History compliance

2016-01-13 Thread GPC Informatics
Not asked | tobacco:06 \i2b2\PCORnet Vital Signs\Tobacco\No Information | tobacco:NI \i2b2\PCORnet Vital Signs\Tobacco\Other | tobacco:OT -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/267#comment:9> gpc-informatics <http://informatics.gpcnetwork.org/> Gr

Re: [gpc-informatics] #473: PCORnet CDMv3 SAS prep-to-research Readiness

2016-06-24 Thread GPC Informatics
| Resolution: Keywords: | Blocked By: 381, 486 Blocking: 510 | -+ Changes (by lv): * owner: preeder => campbell -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/473#comment:94> gpc-informat

[gpc-informatics] Batch modify: #201, #76

2016-06-24 Thread GPC Informatics
Batch modification to #201, #76 by dconnolly: milestone to Comment: preparing to close milestone:data-domains3, as #473 is nearly done -- Tickets URL: <http://informatics.gpcnetwork.org/trac/Project/query?id=201%2C76> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Pl

[gpc-informatics] Batch modify: #455, #155, #503, #504

2016-06-24 Thread GPC Informatics
Batch modification to #455, #155, #503, #504 by dconnolly: milestone to gpc-phase2-h2 Comment: preparing to close milestone:data-domains3, as #473 is nearly done -- Tickets URL: <http://informatics.gpcnetwork.org/trac/Project/query?id=455%2C155%2C503%2C504> gpc-informatics

Re: [gpc-informatics] #473: PCORnet CDMv3 SAS prep-to-research Readiness

2016-06-24 Thread GPC Informatics
ket/473#comment:95> 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] #465: date obfuscation (shifting) for PCORnet CDM queries

2016-02-08 Thread GPC Informatics
rnance around data. Per GPC DSA have allowances to run queries around de-identified dates. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/465#comment:2> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Net

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

2016-02-08 Thread GPC Informatics
ign for this query depends on our design for smoking status #267 -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/263#comment:31> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-d

Re: [gpc-informatics] #462: validate ADAPTABLE computable phenotype with chart review

2016-02-08 Thread GPC Informatics
it make sense to cc her on this ticket. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/462#comment:1> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing

Re: [gpc-informatics] #473: PCORnet CDMv3 SAS Readiness

2016-02-10 Thread GPC Informatics
: | Blocked By: Blocking: | ---+ Changes (by ngraham): * cc: mprittie (added) Comment: Adding Mike on CC as he's been working on this at KU. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/473#comment:9&g

Re: [gpc-informatics] #462: validate ADAPTABLE computable phenotype with chart review

2016-02-10 Thread GPC Informatics
ket/462#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] #473: PCORnet CDMv3 SAS Readiness

2016-02-10 Thread GPC Informatics
to the CDM and still be useful. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/473#comment:10> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@

Re: [gpc-informatics] #462: validate ADAPTABLE computable phenotype with chart review

2016-02-10 Thread GPC Informatics
ris for MCW. Kris, please assign to UTHSCSA next. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/462#comment:6> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev maili

Re: [gpc-informatics] #473: PCORnet CDMv3 SAS Readiness

2016-02-09 Thread GPC Informatics
orkplan they are described as “unexpected conditions”) • Locked/static data • Will need to submit an ETL ADD with their query response (the template is on our Data Characterization wiki) -- Comment (by lv): Updating with date for CMH. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Proje

Re: [gpc-informatics] #473: PCORnet CDMv3 SAS Readiness

2016-02-08 Thread GPC Informatics
eciate it if "our Data Characterization wiki" were a link. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/473#comment:4> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics

Re: [gpc-informatics] #266: CDM V3 Development for Phase 2

2016-02-05 Thread GPC Informatics
. Nebraska needs to move down on the priority list of GPC sites implementing V3. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/266#comment:18> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network -

Re: [gpc-informatics] #473: PCORnet CDMv3 SAS Readiness

2016-02-05 Thread GPC Informatics
query response (the template is on our Data Characterization wiki) -- Comment (by lv): Updated date for UNMC, from 1/1/15 to 3/15/16, per email from Russ Buzalko. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/473#comment:1> gpc-informatics <http://informa

Re: [gpc-informatics] #473: PCORnet CDMv3 SAS Readiness

2016-02-05 Thread GPC Informatics
an ETL ADD with their query response (the template is on our Data Characterization wiki) -- -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/473#comment:3> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___

Re: [gpc-informatics] #266: CDM V3 Development for Phase 2

2016-02-05 Thread GPC Informatics
: Keywords: CDM V3| Blocked By: 283, 381, 436 Blocking:| --+--- Changes (by lv): * status: assigned => accepted -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/266#comment:2

[gpc-informatics] #473: PCORnet CDMv3 SAS Readiness

2016-02-05 Thread GPC Informatics
ttp://informatics.gpcnetwork.org/trac/Project/ticket/473> 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 4th quarterly QA results (and 3rd quarter if feasible) (was: Gather 2015 3rd, 4th quarterly QA results)

2016-02-09 Thread GPC Informatics
ttp://informatics.gpcnetwork.org/trac/Project/ticket/327#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] #462: validate ADAPTABLE computable phenotype with chart review

2016-02-11 Thread GPC Informatics
-sharing | Resolution: Keywords:| Blocked By: Blocking: 263 | --+ Changes (by kosinski): * owner: abos => bos -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/462#comment:

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

2016-02-11 Thread GPC Informatics
to share the ADAPTABLE queries in GPC terminologies on babel. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/263#comment:32> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___

Re: [gpc-informatics] #462: validate ADAPTABLE computable phenotype with chart review

2016-02-11 Thread GPC Informatics
-sharing | Resolution: Keywords:| Blocked By: Blocking: 263 | --+ Changes (by kosinski): * owner: kosinski => abos -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/462#comment:

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

2016-01-28 Thread GPC Informatics
ack to Tom to resume gathering results. (The Oracle code is tracked separately as #366, currently closed.) -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/327#comment:24> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Networ

[gpc-informatics] #465: date obfuscation (shifting) in PCORnet CDM data warehouses

2016-02-01 Thread GPC Informatics
JRC in ticket:266#comment:10) I see: Requirements for ‘research-ready’: ... No date obfuscation ''separating this out of #26, which is about sharing datasets between GPC sites'' -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/465> gpc-informatics

Re: [gpc-informatics] #465: date obfuscation (shifting) for PCORnet CDM queries (was: date obfuscation (shifting) in PCORnet CDM data warehouses)

2016-02-01 Thread GPC Informatics
ent:20): > ... Steve will follow up with Russ, and communicate with the IRB group. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/465#comment:1> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics __

[gpc-informatics] Batch modify: #117, #165, #161, #406

2016-02-01 Thread GPC Informatics
to be in the someday pile, let's make one or more new milestones to represent who wants them done and when. -- Tickets URL: <http://informatics.gpcnetwork.org/trac/Project/query?id=117%2C165%2C161%2C406> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network -

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

2016-02-01 Thread GPC Informatics
one. Let's try Feb 15. Tom, if you have a better guess, please let us know. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/327#comment:25> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics _

Re: [gpc-informatics] #376: data builder limited to `like concept_dimension.concept_path` metadata

2016-02-03 Thread GPC Informatics
http://informatics.gpcnetwork.org/trac/Project/ticket/376#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] #478: ADAPTABLE monitoring

2016-02-24 Thread GPC Informatics
c/Project/ticket/478#comment:1> 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] #462: validate ADAPTABLE computable phenotype with chart review

2016-02-22 Thread GPC Informatics
far we have reviewed 10 out of 20 patient charts. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/462#comment:9> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mail

Re: [gpc-informatics] #462: validate ADAPTABLE computable phenotype with chart review

2016-02-25 Thread GPC Informatics
rac/Project/ticket/462#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

Re: [gpc-informatics] #473: PCORnet CDMv3 SAS Readiness

2016-02-29 Thread GPC Informatics
ttp://informatics.gpcnetwork.org/trac/Project/ticket/473#comment:23> 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] #473: PCORnet CDMv3 SAS Readiness

2016-02-22 Thread GPC Informatics
e for UTHSCSA, per email from Alex. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/473#comment:21> 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] #473: PCORnet CDMv3 SAS Readiness

2016-02-23 Thread GPC Informatics
roject/ticket/473#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] #267: CDM V2 Vitals.Smoking History compliance

2016-01-22 Thread GPC Informatics
xed => -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/267#comment:12> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listser

Re: [gpc-informatics] #267: CDM V3 Vitals.Smoking History compliance (was: CDM V2 Vitals.Smoking History compliance)

2016-01-22 Thread GPC Informatics
V3 Comment: Per Dan's comments...spoke with Jim Campbell and he agreed to reopen. Will change to V3. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/267#comment:13> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Networ

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

2016-01-25 Thread GPC Informatics
that were used in the query are Stenosis Percent, Prior MI and Prior CABG. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/263#comment:27> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network -

Re: [gpc-informatics] #439: Demographics breakdown for population for PCORI Reporting

2016-01-22 Thread GPC Informatics
xed => Comment: Phillip: Tom Mish reached out to you to obtain the cohort demographics from UTSW. Please provide secure link to Tom so I can provide complete information to PCORI. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/439#comment:8> gpc-infor

Re: [gpc-informatics] #327: Gather 2015 4th quarterly QA results (and 3rd quarter if feasible)

2016-02-15 Thread GPC Informatics
news, I moved the due date for milestone:data-quality-q3 from Feb 15 to Feb 29. The relevance to Q4 2015 is fading; we probably should have started on Q1 2016 by now. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/327#comment:27> gpc-informatics

Re: [gpc-informatics] #266: CDM V3 Development for Phase 2

2016-02-15 Thread GPC Informatics
As far as I can tell, this isn't interestingly different from #473. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/266#comment:21> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics __

Re: [gpc-informatics] #473: PCORnet CDMv3 SAS Readiness

2016-02-15 Thread GPC Informatics
for UTHSCSA to fix some things and re-run by Feb 16 (comment:8). I suppose given the negative result from KUMC (#476) we owe an update ETA. Our internal schedule says March 16. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/473#comment:14> gpc-informatics <http:

Re: [gpc-informatics] #473: PCORnet CDMv3 SAS Readiness

2016-02-15 Thread GPC Informatics
CSA is currently using algorithmic enrollment criteria of 2 visits within the past 3 years at least 30 days apart. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/473#comment:15> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Networ

Re: [gpc-informatics] #473: PCORnet CDMv3 SAS Readiness

2016-02-15 Thread GPC Informatics
ave a HARVEST table (ref #476). -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/473#comment:18> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listser

Re: [gpc-informatics] #473: PCORnet CDMv3 SAS Readiness

2016-02-16 Thread GPC Informatics
: | Blocked By: Blocking: | ---+ Comment (by nateapathy): OK - we will use C4 and CMH for the NETWORK_ID and DATAMART_ID, respectively. Thanks! -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/473#comment:20&g

Re: [gpc-informatics] #376: data builder limited to `like concept_dimension.concept_path` metadata

2016-02-19 Thread GPC Informatics
don't currently plan to fix this. If it proves to be an unacceptable limitation, we can reconsider. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/376#comment:4> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Net

[gpc-informatics] #462: validate ADAPTABLE computable phenotype with chart review

2016-02-01 Thread GPC Informatics
he phenotype For details on the computable phenotype, see #263 ''Dan, reporting for Sravani'' -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/462> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___

Re: [gpc-informatics] #155: correlating observations with encounters

2016-03-14 Thread GPC Informatics
unt(*) qty, enc_type from encounter group by enc_type ) et cross join all_enc ; }}} -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/155#comment:18> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains

Re: [gpc-informatics] #473: PCORnet CDMv3 SAS Readiness

2016-03-09 Thread GPC Informatics
org/trac/Project/ticket/473#comment:30> 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] #473: PCORnet CDMv3 SAS Readiness

2016-03-11 Thread GPC Informatics
g/trac/Project/ticket/473#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/mailman/listinfo/gpc-dev

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

2016-03-11 Thread GPC Informatics
pirin" a workaround for sites that can't exclude on aspirin allergies? -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/263#comment:33> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics _

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

2016-03-11 Thread GPC Informatics
m inclined to wait till I get a confirmation from our site lead before I make any further changes to the query. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/263#comment:34> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains

Re: [gpc-informatics] #241: CDM V2 Lab LOINC Standardization

2016-04-06 Thread GPC Informatics
built LAB_RESULT_CM. All that remains is some observable way to test the data at our sites (#285). -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/241#comment:5> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Net

Re: [gpc-informatics] #473: PCORnet CDMv3 SAS prep-to-research Readiness

2016-04-12 Thread GPC Informatics
adding the file. I need to add the file after you or someone sets it back to “Incomplete”. Who is the contact person to reset the request? -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/473#comment:41> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Pl

Re: [gpc-informatics] #473: PCORnet CDMv3 SAS prep-to-research Readiness

2016-04-11 Thread GPC Informatics
with me to benchmark those queries in Netezza this week as well, and will most likely use this code to create the Postgres branch since Netezza SQL grammar is based on Postgres. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/473#comment:38> gpc-informatics

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

2016-04-11 Thread GPC Informatics
267, 444, 495 Comment: I think the outcome of our 29 March call (#12) is that while chart review (#462) isn't finished, we've done enough for the purpose of query design. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/263#comment:41> gpc-in

Re: [gpc-informatics] #473: PCORnet CDMv3 SAS prep-to-research Readiness

2016-04-11 Thread GPC Informatics
lt;http://informatics.gpcnetwork.org/trac/Project/ticket/473#comment:39> 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] #473: PCORnet CDMv3 SAS prep-to-research Readiness

2016-04-11 Thread GPC Informatics
rac/Project/ticket/473#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] #160: reproducible GPC, CDM refresh at a critical mass of GPC sites (PMO milestone 2.4)

2016-04-11 Thread GPC Informatics
pulate CDM from Clarity. #464 is a ticket to share it - DevTeams#unmc - using another approach due to some issue around ONC standard coding that wasn't entirely clear at the time. #455 was assigned to elaborate -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/160#commen

Re: [gpc-informatics] #160: reproducible GPC, CDM refresh at a critical mass of GPC sites (PMO milestone 2.4)

2016-04-11 Thread GPC Informatics
ement tool so I feel this gives us the capability to respond quickly to any changes. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/160#comment:25> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains

Re: [gpc-informatics] #267: CDM V3 Vitals.Smoking History compliance

2016-03-19 Thread GPC Informatics
ttp://informatics.gpcnetwork.org/trac/Project/ticket/267#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] #263: Adaptable cohort query design and administration

2016-03-19 Thread GPC Informatics
263#comment:37> 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] #263: Adaptable cohort query design and administration

2016-03-19 Thread GPC Informatics
- Included patients on Aspirin Updated query can be found in the ADAPTABLE shared folder in Babel with the name ADAPTABLE_W_NCDR_03172016. There is also a modified version of the same query without the NCDR. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/263#comment:36&g

Re: [gpc-informatics] #201: Align c_table_cd in table_access (item_key) across sites

2016-03-20 Thread GPC Informatics
to confirm -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/201#comment:9> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.k

Re: [gpc-informatics] #267: CDM V3 Vitals.Smoking History compliance

2016-03-21 Thread GPC Informatics
, measure_time, admit_date ); }}} -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/267#comment:21> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing

Re: [gpc-informatics] #155: correlating observations with encounters

2016-03-24 Thread GPC Informatics
ADD to talk about this, but we're not confident about our answer. We're following up with Russ. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/155#comment:21> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Networ

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

2016-03-24 Thread GPC Informatics
tie Comment: Mike, while our core DC work (#486) is stalled on infrastructure issues, please look into the labs table. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/285#comment:6> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Networ

Re: [gpc-informatics] #155: correlating observations with encounters

2016-03-21 Thread GPC Informatics
that we have not figured out a way to reconcile the CDM's notion of same/different encounter (comment:9) with HERON's? See also ticket:486#comment:19 by Bos 14 Mar and Matt's reply. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/155#comment:20> gpc-informatics

Re: [gpc-informatics] #155: correlating observations with encounters

2016-03-21 Thread GPC Informatics
:20) to get the number somewhat higher. Meanwhile... -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/155#comment:19> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev m

Re: [gpc-informatics] #484: CDM v3 data characterization SAS code

2016-03-21 Thread GPC Informatics
g/trac/Project/ticket/484#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] #267: CDM V3 Vitals.Smoking History compliance

2016-03-19 Thread GPC Informatics
icket/267#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] #473: PCORnet CDMv3 SAS prep-to-research Readiness (was: PCORnet CDMv3 SAS Readiness)

2016-03-21 Thread GPC Informatics
ent:10); the Data Characterization wiki may have more up-to-date materials. -- Comment: replacing out-of-date schedule in ticket description with pointer(s) to definitive info. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/473#comment:32> gpc-informatics <http:

Re: [gpc-informatics] #155: correlating observations with encounters

2016-03-04 Thread GPC Informatics
<http://informatics.gpcnetwork.org/trac/Project/ticket/155#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] #473: PCORnet CDMv3 SAS Readiness

2016-03-02 Thread GPC Informatics
ORnet wide agreements) will be taken into account. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/473#comment:24> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-de

Re: [gpc-informatics] #473: PCORnet CDMv3 SAS Readiness

2016-03-07 Thread GPC Informatics
-668-8017 | cell: 336-255-3231 -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/473#comment:28> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing

Re: [gpc-informatics] #160: reproducible GPC, CDM refresh at a critical mass of GPC sites (PMO milestone 2.4)

2016-03-07 Thread GPC Informatics
licate Comment: overtaken by #473 -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/160#comment:23> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev

Re: [gpc-informatics] #473: PCORnet CDMv3 SAS Readiness

2016-03-07 Thread GPC Informatics
t;http://informatics.gpcnetwork.org/trac/Project/ticket/473#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] #473: PCORnet CDMv3 SAS Readiness

2016-03-07 Thread GPC Informatics
you want answered? KUMC's status on DC is in #486 and DQ is #476. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/473#comment:26> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics

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

2016-03-07 Thread GPC Informatics
/trac/Project/milestone/next-d Next-d] will also use HbA1c across participating GPC sites. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/285#comment:5> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network -

Re: [gpc-informatics] #267: CDM V3 Vitals.Smoking History compliance

2016-03-04 Thread GPC Informatics
URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/267#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] #155: correlating observations with encounters

2016-03-08 Thread GPC Informatics
tps://github.com/njgraham/i2p-transform i2p- transform] I plan to proceed with our CDM V1 approach that at least categorized 20-30% of the encounters (as I vaguely recall). -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/155#comment:16> gpc-informat

Re: [gpc-informatics] #155: correlating observations with encounters

2016-03-08 Thread GPC Informatics
/njgraham/i2p- transform/commit/ac34c7e06dd68a2293ffb55aa1e9c0d5d655e71a ac34c7e] Once we run the transform against production data we can see how much coverage we have. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/155#comment:17> gpc-informatics

Re: [gpc-informatics] #473: PCORnet CDMv3 SAS prep-to-research Readiness

2016-03-28 Thread GPC Informatics
, 3.28.16 (moved up from previous 4.11.16 date). -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/473#comment:33> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mail

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

2016-04-04 Thread GPC Informatics
March call #12) -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/263#comment:39> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.k

Re: [gpc-informatics] #473: PCORnet CDMv3 SAS prep-to-research Readiness

2016-03-29 Thread GPC Informatics
. --Mosa -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/473#comment:35> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.k

Re: [gpc-informatics] #267: CDM V3 Vitals.Smoking History compliance

2016-03-21 Thread GPC Informatics
ct/ticket/267#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] #473: PCORnet CDMv3 SAS prep-to-research Readiness

2016-04-13 Thread GPC Informatics
ution is via popmednet" isn't 100% clear. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/473#comment:43> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-de

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