Re: [gpc-informatics] #90: Diagnoses Modifiers for data attribution

2015-03-17 Thread GPC Informatics
, FI) would address the immediate need? AD=Admitting DI=Discharge FI=Final IN=Interim NI=No information UN=Unknown OT=Other -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/90#comment:30> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Pl

Re: [gpc-informatics] #90: Diagnoses Modifiers for data attribution

2015-03-17 Thread GPC Informatics
sation had thus far, I think it's worthwhile to pursue Laurel's suggestion above. Perhaps plus "PR" and "NP" for primary and nonprimary? -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/90#comment:31> gpc-informatics <http://inform

Re: [gpc-informatics] #90: Diagnoses Modifiers for data attribution

2015-03-17 Thread GPC Informatics
ttp://informatics.gpcnetwork.org/trac/Project/ticket/90#comment:32> 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] #90: Diagnoses Modifiers for data attribution

2015-03-17 Thread GPC Informatics
d by GPC research in the near term? Maybe sites that want these can just deal with them locally. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/90#comment:33> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains N

Re: [gpc-informatics] #158: usable view of LOINC lab terms

2015-03-17 Thread GPC Informatics
: | Blocked By: Blocking: | -+ Comment (by huhickman): Attaching CSV per gcc-dev discussion. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/158#comment:27> gpc-informatics

Re: [gpc-informatics] #182: Complete LOINC standardization of CDM V1 and share metadata with GPC

2015-03-18 Thread GPC Informatics
182#comment:9> 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: #182, #201

2015-03-19 Thread GPC Informatics
Batch modification to #182, #201 by dconnolly: milestone to data-domains3 Comment: moving these to data-domains3 in the process of closing drn-basic-query -- Tickets URL: <http://informatics.gpcnetwork.org/trac/Project/query?id=182%2C201> gpc-informatics <http://informatics.gpcne

Re: [gpc-informatics] #148: PopMedNet node at MCW

2015-03-19 Thread GPC Informatics
:| Blocked By: Blocking:| --+ Changes (by gkowalski): * status: reopened => closed * resolution: => fixed -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/148#comment:25> gpc-infor

Re: [gpc-informatics] #148: PopMedNet node at MCW

2015-03-19 Thread GPC Informatics
:| Blocked By: Blocking:| --+ Comment (by gkowalski): We have completed this ticket. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/148#comment:24> gpc-informatics <http://informatics.gpcne

Re: [gpc-informatics] #243: GPC Procedure Ontology: CPT, HCPCS

2015-03-20 Thread GPC Informatics
oads i2b2metadata2.cpt into heron_terms. We commented that out and are instead loading blueheronmetadata.umls_cpt, which was created by umls_cpt_concepts.sql -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/243#comment:4> gpc-informatics <http://informatics.gpcnetwork.

Re: [gpc-informatics] #242: CDM V2 SNOMED CT Conditions compliance

2015-03-21 Thread GPC Informatics
ickman huhick...@nebraskamed.com" "Angela Bos angela...@uthscsa.edu" "Susan Morrison susan.morri...@utsouthwestern.edu" "Patrick Lenon prle...@uwcarbone.wisc.edu" "Jacquie Bohne bohne.jacquel...@mcrf.mfldclin.edu" -- Ticket URL: <http://informati

Re: [gpc-informatics] #240: Data Characterization queries for phase 1 CDM V1 compliance (was: Data Characterization ETL ADD for phase 1 CDM V1 compliance)

2015-03-21 Thread GPC Informatics
be required of all datamarts before end of phase 1 assessing data quality by site. CDM V2 compliance will not be required before and of phase 1. -- -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/240#comment:3> gpc-informatics <http://informatics.gpcnetwork.o

Re: [gpc-informatics] #242: CDM V2 SNOMED CT Conditions compliance

2015-03-22 Thread GPC Informatics
: | Blocked By: Blocking: | -+--- Comment (by nateapathy): For our i2b2 instances at Cerner we use Oracle. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/242#comment:3> gpc-informatics

Re: [gpc-informatics] #242: CDM V2 SNOMED CT Conditions compliance

2015-03-22 Thread GPC Informatics
ect/ticket/242#comment:4> 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] #242: CDM V2 SNOMED CT Conditions compliance

2015-03-23 Thread GPC Informatics
ttp://informatics.gpcnetwork.org/trac/Project/ticket/242#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] #242: CDM V2 SNOMED CT Conditions compliance

2015-03-23 Thread GPC Informatics
ttp://informatics.gpcnetwork.org/trac/Project/ticket/242#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] #242: CDM V2 SNOMED CT Conditions compliance

2015-03-23 Thread GPC Informatics
: | Blocked By: Blocking: | -+--- Comment (by ngraham): KUMC uses Oracle. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/242#comment:7> gpc-informatics <http://informatics.gpcne

Re: [gpc-informatics] #242: CDM V2 SNOMED CT Conditions compliance

2015-03-23 Thread GPC Informatics
: | Blocked By: Blocking: | -+--- Comment (by dconnolly): KUMC also operates babel, which runs postgres. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/242#comment:8> gpc-informatics

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

2015-03-23 Thread GPC Informatics
udies - CDM v1.0 DC queries ready for distribution by early April (SQL Server, Postgres, Oracle) -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/240#comment:4> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Pla

Re: [gpc-informatics] #90: Diagnoses Modifiers for data attribution

2015-03-23 Thread GPC Informatics
ics.gpcnetwork.org/trac/Project/ticket/90#comment:34> 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] #238: March QA Query

2015-03-25 Thread GPC Informatics
rac/Project/ticket/238#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] #238: March QA Query

2015-03-26 Thread GPC Informatics
<http://informatics.gpcnetwork.org/trac/Project/ticket/238#comment:9> 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] #158: usable view of LOINC lab terms

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

Re: [gpc-informatics] #243: GPC Procedure Ontology: CPT, HCPCS

2015-03-27 Thread GPC Informatics
ket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/243#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] #241: CDM V2 Lab LOINC Standardization

2015-03-31 Thread GPC Informatics
access to the SQL code. https://datahandbook.epic.com//Reports/Details/9000297 -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/241#comment:3> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network -

Re: [gpc-informatics] #243: GPC Procedure Ontology: CPT, HCPCS

2015-03-31 Thread GPC Informatics
g/trac/Project/ticket/243#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] #243: GPC Procedure Ontology: CPT, HCPCS

2015-03-31 Thread GPC Informatics
on procedures] -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/243#comment:7> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listser

Re: [gpc-informatics] #243: GPC Procedure Ontology: CPT, HCPCS

2015-03-31 Thread GPC Informatics
ted updates -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/243#comment:8> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listser

Re: [gpc-informatics] #210: Query by BMI percentile among children.

2015-03-31 Thread GPC Informatics
: -+- Comment (by dconnolly): George, I meant to get confirmation today that all sites are ready on this. Are you ready to run queries involving BMI percentile? -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/210#comment:22> gpc-informatics

Re: [gpc-informatics] #252: collect test results of Weight and Height cohort selection queries from all sites

2015-03-31 Thread GPC Informatics
new => assigned Comment: WISC (at least) to report experience on steps 1, 2 of Obesity query v0.2 this week. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/252#comment:4> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Net

Re: [gpc-informatics] #242: CDM V2 SNOMED CT Conditions compliance

2015-03-31 Thread GPC Informatics
: | Blocked By: Blocking: | -+--- Comment (by lv): MCRF uses Microsoft SQL Server for i2b2 instances. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/242#comment:9> gpc-informatics

Re: [gpc-informatics] #238: Q1 2015 QA Query (was: March QA Query)

2015-04-02 Thread GPC Informatics
: data-quality | Blocked By: Blocking: 232 | --+- -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/238#comment:10> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network -

Re: [gpc-informatics] #238: Q1 2015 QA Query

2015-04-02 Thread GPC Informatics
this intentional? or are the other known races missing from the QA query? perhaps we need to use an updated version) -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/238#comment:11> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Net

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

2015-04-06 Thread GPC Informatics
ect/ticket/266> 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] #242: CDM V2 SNOMED CT Conditions compliance

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

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

2015-04-07 Thread GPC Informatics
://datahandbook.epic.com//Reports/Details/9000299 SQL for Tobacco type will follow later. Jim -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/267> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___

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

2015-04-07 Thread GPC Informatics
is was assigned to me by default. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/267#comment:1> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@list

Re: [gpc-informatics] #158: usable view of LOINC lab terms

2015-04-07 Thread GPC Informatics
esign is not consistent with HackathonTwo design decissions. As he mentioned in comment:25, Drs.Campbell(Jim and Scott) have put together their hierarchy. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/158#comment:29> gpc-informatics <http://informatics.gpcnetw

Re: [gpc-informatics] #56: shareable synthetic test data sets: Epic clarity, i2b2, NAACCR, ...

2015-04-07 Thread GPC Informatics
: data-sharing | Resolution: Keywords:| Blocked By: Blocking:| --+ Changes (by bzschoche): * cc: jsteinmetz (removed) -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/56#comment:24&g

[gpc-informatics] #268: HERON ETL clarity 2014 impact on 2012 installations

2015-04-08 Thread GPC Informatics
k TracPermissions). For reference: branch clarity_2014_3207, currently at 8e01143b39ba. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/268> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___

Re: [gpc-informatics] #268: HERON ETL clarity 2014 impact on 2012 installations

2015-04-08 Thread GPC Informatics
re whatever else you'd like to on the topic. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/268#comment:1> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___

Re: [gpc-informatics] #90: Diagnoses Modifiers for data attribution

2015-04-09 Thread GPC Informatics
this at some point so that we can move on. Phillip -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/90#comment:35> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev

Re: [gpc-informatics] #210: Query by BMI percentile among children.

2015-04-09 Thread GPC Informatics
ink our BMI Percentiles lookups should be computed off the real dates, and not adjusted dates. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/210#comment:24> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics __

Re: [gpc-informatics] #238: Q1 2015 QA Query

2015-04-09 Thread GPC Informatics
-TM -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/238#comment:14> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http:

Re: [gpc-informatics] #238: Q1 2015 QA Query

2015-04-09 Thread GPC Informatics
al Encounter Types are stored in our Visit_Dimension table; changes were made to accommodate this. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/238#comment:13> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___

Re: [gpc-informatics] #210: Query by BMI percentile among children.

2015-04-13 Thread GPC Informatics
: -+- Comment (by susandm): So is this for discussion in the meeting tomorrow? -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/210#comment:25> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network -

Re: [gpc-informatics] #210: Query by BMI percentile among children.

2015-04-14 Thread GPC Informatics
: -+- Comment (by lv): Yes; item 3 on the distributed agenda. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/210#comment:26> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network -

Re: [gpc-informatics] #210: Query by BMI percentile among children.

2015-04-14 Thread GPC Informatics
: -+- Comment (by dconnolly): Birthdates are shifted too; I don't see why there's a problem. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/210#comment:27> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains

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

2015-04-14 Thread GPC Informatics
t thought I had was: how can we tell if we're doing this right or wrong? Do you know if the Q1 query (#238) measures whether facts and encounters are correlated correctly? -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/155#comment:10>

Re: [gpc-informatics] #238: Q1 2015 QA Query

2015-04-14 Thread GPC Informatics
l early days, and I think we're still figuring this out as we go, but let's try to get more precise next time around. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/238#comment:15> gpc-informatics <http://informatics.gpcnetwor

Re: [gpc-informatics] #238: Q1 2015 QA Query

2015-04-14 Thread GPC Informatics
-TM -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/238#comment:16> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://

Re: [gpc-informatics] #210: Query by BMI percentile among children.

2015-04-14 Thread GPC Informatics
ed them using the deidentified data, joined the two result sets, and counted the number of mismatched ages? -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/210#comment:28> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains N

Re: [gpc-informatics] #242: CDM V2 SNOMED CT Conditions compliance

2015-04-14 Thread GPC Informatics
: | Blocked By: Blocking: | -+--- Comment (by bokov): San Antonio uses Oracle and Epic -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/242#comment:11> gpc-informatics

Re: [gpc-informatics] #238: Q1 2015 QA Query

2015-04-15 Thread GPC Informatics
. I'd be willing to help next time to find a way to write such queries in a way that is compatible with both Oracle and Netezza. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/238#comment:17> gpc-informatics <http://informatics.gpcnetwork.org

Re: [gpc-informatics] #243: GPC Procedure Ontology: CPT, HCPCS

2015-04-16 Thread GPC Informatics
-- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/243#comment:9> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://lists

Re: [gpc-informatics] #165: PopMedNet node at UTSW

2015-04-16 Thread GPC Informatics
:| Blocked By: Blocking:| --+ Comment (by susandm): PMN Data Mart Client v5 installed, tested connectivity to our pcornet data mart -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/165#comment:10&g

Re: [gpc-informatics] #165: PopMedNet node at UTSW

2015-04-16 Thread GPC Informatics
:| Blocked By: Blocking:| --+ Changes (by susandm): * status: reopened => closed * resolution: => fixed -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/165#comment:11> gpc-infor

Re: [gpc-informatics] #242: CDM V2 SNOMED CT Conditions compliance

2015-04-16 Thread GPC Informatics
t URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/242#comment:12> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mai

Re: [gpc-informatics] #252: collect test results of Weight and Height cohort selection queries from all sites

2015-04-16 Thread GPC Informatics
sql query text w/o the WI criteria */ -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/252#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] #161: PopMedNet node at CMH

2015-04-16 Thread GPC Informatics
n the necessary test queries from the Coordinating Center/Portal and returned results, and are now finalizing our Citrix deployment in a test environment. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/161#comment:11> gpc-informatics <http://informatics.gpcnetwork

[gpc-informatics] #270: Port Q1 QA query to Oracle

2015-04-20 Thread GPC Informatics
:| Blocking: 232, 262 ---+--- per gpc-dev call 14 Apr (see #12 for notes) -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/270> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Pl

Re: [gpc-informatics] #270: Port Q1 QA query to Oracle

2015-04-20 Thread GPC Informatics
s, so I'm leaving the blocking relationship in place. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/270#comment:1> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ G

Re: [gpc-informatics] #210: Query by BMI percentile among children.

2015-04-20 Thread GPC Informatics
ent: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] #238: Q1 2015 QA Query

2015-04-20 Thread GPC Informatics
as editing the milestone for two reasons: 1. to notify relevant people (trac doesn't send notifications when milestones are edited) 2. to leave an audit trail (trac doesn't keep old versions of milestone info) -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/238

Re: [gpc-informatics] #238: Q1 2015 QA Query

2015-04-20 Thread GPC Informatics
: data-quality | Blocked By: Blocking: 232, 262 | --+- Comment (by lv): Results for MCRF were sent to Tom on Wednesday, April 15. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/238#comment:19> gpc-informatics

Re: [gpc-informatics] #270: Port Q1 QA query to Oracle

2015-04-20 Thread GPC Informatics
2015v6.sql:ticket:262 -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/270#comment:2> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@list

Re: [gpc-informatics] #238: Q1 2015 QA Query

2015-04-20 Thread GPC Informatics
dressing? If there's no outstanding feedback that you know of, please close this ticket. p.s. full email addresses work fine in the cc field, but for the owner field, I much prefer to stick to trac account names. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/238

Re: [gpc-informatics] #252: collect test results of Weight and Height cohort selection queries from all sites

2015-04-20 Thread GPC Informatics
ISC now; do you have responses from any other sites? If so, which? -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/252#comment:6> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics

Re: [gpc-informatics] #238: Q1 2015 QA Query

2015-04-20 Thread GPC Informatics
ket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/238#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] #90: Diagnoses Modifiers for data attribution

2015-04-20 Thread GPC Informatics
modifier tree. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/90#comment:36> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.k

Re: [gpc-informatics] #238: Q1 2015 QA Query

2015-04-21 Thread GPC Informatics
in comment:17 (and, much more detail in ticket:262#comment:8). Most comments are suggestions for "next time", but there are a few things under "Possible Bugs" that I thought would be worth review. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/tic

Re: [gpc-informatics] #238: Q1 2015 QA Query

2015-04-21 Thread GPC Informatics
ng at KU today. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/238#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] #238: Q1 2015 QA Query

2015-04-21 Thread GPC Informatics
-quality | Blocked By: Blocking: 232, 262 | --+ Changes (by mish): * status: assigned => closed * resolution: => fixed -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/238#comment:24> gpc-infor

Re: [gpc-informatics] #238: Q1 2015 QA Query

2015-04-21 Thread GPC Informatics
ince we've ended up with me entering these datasets by hand. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/238#comment:25> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics _

Re: [gpc-informatics] #158: usable view of LOINC lab terms

2015-04-21 Thread GPC Informatics
<http://informatics.gpcnetwork.org/trac/Project/ticket/158#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] #90: Diagnoses Modifiers for data attribution

2015-04-21 Thread GPC Informatics
nosis\enctr_dx_discharge\ Encounter Diagnosis - Discharge }}} -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/90#comment:37> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics

Re: [gpc-informatics] #242: CDM V2 SNOMED CT Conditions compliance

2015-04-21 Thread GPC Informatics
<http://informatics.gpcnetwork.org/trac/Project/ticket/242#comment:13> 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] #238: Q1 2015 QA Query

2015-04-21 Thread GPC Informatics
ity_Query.sql Q1_2015_Quality_Query.sql] for the in-line code changes). -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/238#comment:26> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc

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

2015-04-23 Thread GPC Informatics
p://informatics.gpcnetwork.org/trac/Project/ticket/263#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] #266: CDM V3 Development for Phase 2

2015-04-27 Thread GPC Informatics
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] #158: usable view of LOINC lab terms

2015-04-27 Thread GPC Informatics
. But perhaps relying on `c_basecode` is the cost-effective thing to do at this point. I'm still mulling it over. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/158#comment:31> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Netw

Re: [gpc-informatics] #270: Port Q1 QA query to Oracle

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

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

2015-04-27 Thread GPC Informatics
| -+- Comment (by dconnolly): Still no word on the IRB (#271)? Then we're still at least two weeks away from done. Milestone due date moves from May 11 to May 18. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/227#comment:20> gpc-inform

Re: [gpc-informatics] #252: collect test results of Weight and Height cohort selection queries from all sites

2015-04-27 Thread GPC Informatics
): - UIOWA ETA Fri - UMN: Can get it done by next Tuesday - MCW: can run next week (week of April 27) -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/252#comment:7> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network -

Re: [gpc-informatics] #252: collect test results of Weight and Height cohort selection queries from all sites

2015-04-27 Thread GPC Informatics
right so we're trying to track down where the issue is at. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/252#comment:8> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics __

Re: [gpc-informatics] #242: CDM V2 SNOMED CT Conditions compliance

2015-04-27 Thread GPC Informatics
e metadata/transitive closure table. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/242#comment:14> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@

Re: [gpc-informatics] #158: usable view of LOINC lab terms

2015-04-28 Thread GPC Informatics
/file/36891223/ JAVA transformation code] is generating null c_fullnames. - There are missing trailing '\' in the paths. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/158#comment:32> gpc-informatics <http://informatics.gpcnetwork.org/> Greater P

Re: [gpc-informatics] #270: Port Q1 QA query to Oracle

2015-04-28 Thread GPC Informatics
<http://informatics.gpcnetwork.org/trac/Project/ticket/270#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] #266: CDM V3 Development for Phase 2

2015-04-28 Thread GPC Informatics
he blocking relationship isn't quite right, but it'll do for now.'' -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/266#comment:2> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics

[gpc-informatics] Batch modify: #133, #256, #263

2015-04-28 Thread GPC Informatics
Batch modification to #133, #256, #263 by dconnolly: priority to minor Comment: technical work on milestone:adaptable-accrual is on the back-burner pending governance (#276) -- Tickets URL: <http://informatics.gpcnetwork.org/trac/Project/query?id=133%2C256%2C263> gpc-informatics

Re: [gpc-informatics] #278: CDRN Survey_Bariatric Prep to Research Table (was: SQL for PCORnet bariatric study)

2015-04-30 Thread GPC Informatics
ding it to the task of getting all the prep-to-research info from sites to PCORI. I gather you're coordinating this, in coordination with Brittany. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/278#comment:8> gpc-informatics <http://informatics.gpcnetwork.org/&

Re: [gpc-informatics] #278: CDRN Survey_Bariatric Prep to Research Table

2015-04-30 Thread GPC Informatics
he SQL code here... -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/278#comment:9> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.

Re: [gpc-informatics] #90: Diagnoses Modifiers for data attribution

2015-04-30 Thread GPC Informatics
C:Diagnoses #63" but don't understand the difference between Encounter and Billing. Definitions of what to include for all would be helpful. Thanks! -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/90#comment:38> gpc-informatics <http://informatics.gpcne

Re: [gpc-informatics] #90: Diagnoses Modifiers for data attribution

2015-04-30 Thread GPC Informatics
. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/90#comment:39> 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] #229: Enrollment terms based on Catchment Area, encounters, etc.

2015-04-30 Thread GPC Informatics
start and stop dates are populated from the earliest- observed encounter and latest-observed encounter. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/229#comment:9> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network -

Re: [gpc-informatics] #229: Enrollment terms based on Catchment Area, encounters, etc.

2015-04-30 Thread GPC Informatics
pc-pcornet- cdm/src/2b34bc7b71b13382b2cb697a10688fbc37f06c0d/CDM_transform_enrollment.sql?at=default#cl-20 CDM_transform_enrollment.sql line 20] -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/229#comment:10> gpc-informatics <http://informatics.gpcnetwork.org/>

Re: [gpc-informatics] #278: CDRN Survey_Bariatric Prep to Research Table

2015-04-30 Thread GPC Informatics
<http://informatics.gpcnetwork.org/trac/Project/ticket/278#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] #266: CDM V3 Development for Phase 2

2015-05-01 Thread GPC Informatics
aven’t had any time to investigate the validity of this change and its quality. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/266#comment:3> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics _

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

2015-05-01 Thread GPC Informatics
in A1c (HbA1c) laboratory data in CDM form. This involves ensuring that the CDM ETL (#145) handles mapping from GPC labs (#158) to CDM labs. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/241#comment:4> gpc-informatics <http://informatics.gpcnetwork.org/> Grea

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

2015-05-01 Thread GPC Informatics
t;http://informatics.gpcnetwork.org/trac/Project/ticket/191#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

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