Re: [gpc-informatics] #595: collect i2b2 datamarts for GROUSE

2017-05-25 Thread GPC Informatics
to that Redcap project. Or am I completely missing something ? -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/595#comment:17> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___

Re: [gpc-informatics] #595: collect i2b2 datamarts for GROUSE

2017-05-24 Thread GPC Informatics
URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/595#comment:15> 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] #578: DC Cycle 3 - Beta Testing

2017-05-22 Thread GPC Informatics
. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/578#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] #280: Medication ontology orgainzed by ingredient

2017-05-31 Thread GPC Informatics
URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/280#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] #595: collect i2b2 datamarts for GROUSE

2017-06-02 Thread GPC Informatics
595#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] #578: DC Cycle 3 - Beta Testing

2017-06-05 Thread GPC Informatics
<http://informatics.gpcnetwork.org/trac/Project/ticket/578#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/mailman/listinfo/gpc-dev

Re: [gpc-informatics] #595: collect i2b2 datamarts for GROUSE

2017-06-01 Thread GPC Informatics
: Keywords: all-sites | Blocked By: 597 Blocking:| --+ Comment (by gkowalski): Uploaded crosswalk file to secureflles site . Done -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/595#comment:20&g

Re: [gpc-informatics] #595: collect i2b2 datamarts for GROUSE

2017-06-01 Thread GPC Informatics
}}} -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/595#comment:21> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://lists

Re: [gpc-informatics] #604: snow shrine prod hub public cert renewal - spoke server keystore updates

2017-06-08 Thread GPC Informatics
sted to make sure your spoke is returning a cohort. Feel free to schedule time with Keith Wanta (kwa...@uwhealth.org) on or after June 8 to test your spoke. -- -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/604#comment:16> gpc-informatics <http://informatics.gp

Re: [gpc-informatics] #604: snow shrine prod hub public cert renewal - spoke server keystore updates

2017-06-08 Thread GPC Informatics
| -+- Comment (by kwanta): Cutover for the public cert on the production hub is at 5pm tonight. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/604#comment:17> gpc-informatics

Re: [gpc-informatics] #604: snow shrine prod hub public cert renewal - spoke server keystore updates

2017-06-08 Thread GPC Informatics
C ticket when you have tested to make sure your spoke is returning a cohort. Feel free to schedule time with Keith Wanta (kwa...@uwhealth.org) on or after June 8 to test your spoke. -- -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/604#comment:18> gpc-informatics <

Re: [gpc-informatics] #604: snow shrine prod hub public cert renewal - spoke server keystore updates

2017-06-08 Thread GPC Informatics
: <http://informatics.gpcnetwork.org/trac/Project/ticket/604#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/mail

Re: [gpc-informatics] #595: collect i2b2 datamarts for GROUSE

2017-06-05 Thread GPC Informatics
rge, I see you got it done within two weeks of when we assigned it to you; did it take you more than 2 hours? More than 4 hours? -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/595#comment:23> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains

Re: [gpc-informatics] #595: collect i2b2 datamarts for GROUSE

2017-05-08 Thread GPC Informatics
3. Upload these files using https://securefiles.kumc.edu/ ; address the submission to `lpa...@kumc.edu, badaga...@kumc.edu` -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/595#comment:3> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plai

Re: [gpc-informatics] #545: Study sample and DM sample definition for next-d

2017-05-04 Thread GPC Informatics
t;http://informatics.gpcnetwork.org/trac/Project/ticket/545#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] #545: Study sample and DM sample definition for next-d

2017-05-04 Thread GPC Informatics
with other geocoding work. -- Mei -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/545#comment:21> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@lists

Re: [gpc-informatics] #579: Data Characterization - Cycle 3 Tracking

2017-05-30 Thread GPC Informatics
efresh Dates: Query Distribution: July 5 Query Due Date: July 31 Second Refresh Dates: Query Distribution: ~Early October Query Due Date: TBD *Dates current as of PCORnet DRN OC Forum 2/6/17 -- Comment (by dconnolly): date updates from LV -- Ticket URL: <http://informatics.gp

Re: [gpc-informatics] #578: DC Cycle 3 - Beta Testing

2017-05-31 Thread GPC Informatics
IVF. Provided feedback on the order of Data Checks/Tables as the Exception Summary is in a different order than data are reported. Recommended Table IA be updated to add value "NI." -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/578#comment:11> gpc-i

Re: [gpc-informatics] #545: Study sample and DM sample definition for next-d

2017-09-13 Thread GPC Informatics
final” (ok, nothing is every truly final, but still, no longer “draft”) details on the data pull in the next couple of days. " Once we receive the details, we at KUMC can prototype and present to other sites. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/545#co

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

2017-10-03 Thread GPC Informatics
to this ticket? Thanks! -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/280#comment:31> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@lists

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

2017-10-10 Thread GPC Informatics
c-dev/2017q4/004314.html SNOW Shrine Ontology] \\Andrew Hangsleben hangs008 at umn.edu \\Tue Oct 3 14:04:22 CDT 2017 -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/201#comment:12> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plai

Re: [gpc-informatics] #545: Study sample and DM sample definition for next-d

2017-08-29 Thread GPC Informatics
on a GPC REDCap submission destination -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/545#comment:25> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing

Re: [gpc-informatics] #545: Study sample and DM sample definition for next-d

2017-08-29 Thread GPC Informatics
. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/545#comment:26> 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] #478: ADAPTABLE monitoring

2017-09-05 Thread GPC Informatics
t;http://informatics.gpcnetwork.org/trac/Project/ticket/478#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] #545: Study sample and DM sample definition for next-d

2017-09-05 Thread GPC Informatics
, NextDcodeForTable1_StudysampleAndPregnancyExclusion-2017-08-22-AF.sql​ -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/545#comment:30> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing

Re: [gpc-informatics] #186: Querying age by numerical constraints

2017-09-11 Thread GPC Informatics
ned * resolution: fixed => * milestone: data-domains2 => snow-shrine-1 Comment: See ticket:411#comment:2 -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/186#comment:15> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains

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

2017-09-11 Thread GPC Informatics
et/229#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] #229: Enrollment terms based on Catchment Area, encounters, etc.

2017-09-11 Thread GPC Informatics
is now automatically computed. Drag the item to the query window and set date constraints. }}} -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/229#comment:12> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Net

Re: [gpc-informatics] #545: Study sample and DM sample definition for next-d

2017-09-11 Thread GPC Informatics
then, with SHRINE prep for the LEC and such, it's a stretch. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/545#comment:31> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mail

Re: [gpc-informatics] #186: Querying age by numerical constraints

2017-09-11 Thread GPC Informatics
=> closed * resolution: => wontfix Comment: This isn't available in the SHRINE demographics ontology (#525), so I infer we don't plan to support it. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/186#comment:16> gpc-informatics <http://informatics

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

2017-09-26 Thread GPC Informatics
ttp://informatics.gpcnetwork.org/trac/Project/ticket/280#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] #545: Study sample and DM sample definition for next-d

2017-09-25 Thread GPC Informatics
: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] #625: Disk space allocation and LVM setup for SNOW SHRINE spoke server(s)

2017-09-26 Thread GPC Informatics
cket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/625#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] #280: Medication ontology orgainzed by ingredient

2017-09-26 Thread GPC Informatics
://www.dropbox.com/s/oc56lvqi7jvftp8/scilhs_meds_mods.zip?dl=0 -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/280#comment:29> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___

Re: [gpc-informatics] #545: Study sample and DM sample definition for next-d

2017-09-29 Thread GPC Informatics
trac/Project/ticket/545#comment:36> 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] #545: Study sample and DM sample definition for next-d

2017-09-29 Thread GPC Informatics
, MCW, UTSW, IU, KUMC), let's track the others separately: - MU #641 - UNMC #642 - UMN #643 -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/545#comment:35> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network -

Re: [gpc-informatics] #545: Study sample and DM sample definition for next-d

2017-08-28 Thread GPC Informatics
]._%' and PX_TYPE = '09') or (PX like '1%' and PX_TYPE = '10') or (PX like '59[0-9][0-9][0-9]' and PX_TYPE='CH') -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/545#comment:23> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network -

Re: [gpc-informatics] #545: Study sample and DM sample definition for next-d

2017-08-31 Thread GPC Informatics
it is unlikely we are going to be able to turn this around by 9/5. I will keep everyone updated on our progression. Dan H. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/545#comment:27> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Pl

Re: [gpc-informatics] #545: Study sample and DM sample definition for next-d

2017-08-29 Thread GPC Informatics
confusion. Please see attachment. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/545#comment:24> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing

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

2017-11-27 Thread GPC Informatics
ent: Phillip to write an email and a few queries that show how to make use of modifiers and send that to gpc-dev for Jim Campbell’s evaluation. per Nov 21 call #12 -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/90#comment:43> gpc-informatics <http://informatics.gp

Re: [gpc-informatics] #604: snow shrine prod hub public cert renewal - spoke server keystore updates

2017-11-20 Thread GPC Informatics
L: <http://informatics.gpcnetwork.org/trac/Project/ticket/604#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

[gpc-informatics] Batch modify: #583, #120, #23, #229

2017-11-20 Thread GPC Informatics
Batch modification to #583, #120, #23, #229 by dconnolly: priority to minor Comment: focus on Demographics, Diagnoses, Procedures, and Medications for now -- Tickets URL: <http://informatics.gpcnetwork.org/trac/Project/query?id=583%2C120%2C23%2C229> gpc-informatics

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

2017-11-02 Thread GPC Informatics
st of hiding them (and postponing support) is about one SQL update statement. I suppose the next step is to look into the benefits of supporting them and then consider the costs... -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/90#comment:40> gpc-informatics <http://informati

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

2017-11-02 Thread GPC Informatics
omehow particularly onerous. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/90#comment:41> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@list

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

2017-11-02 Thread GPC Informatics
fied SHRINE ontology queries available across procedure and diagnosis domains early and then improve on that. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/90#comment:42> gpc-informatics <http://informatics.gpcnetwork.org/> Grea

Re: [gpc-informatics] #625: Disk space allocation and LVM setup for SNOW SHRINE spoke server(s)

2017-10-23 Thread GPC Informatics
's see if calling it done sticks... -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/625#comment:8> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev

Re: [gpc-informatics] #627: New custom authentication provider at MCW blocking SHRINE requests to i2b2

2018-01-09 Thread GPC Informatics
. The trouble with querying our site was some one elses upstream cert , which was fixed. Case closed. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/627#comment:1> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network -

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

2018-02-12 Thread GPC Informatics
243#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] #583: SNOW SCILHS Lab Metadata Expansion

2018-02-20 Thread GPC Informatics
(by dconnolly): * priority: minor => major -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/583#comment:13> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev maili

[gpc-informatics] Batch modify: #90, #280, #411, #583, #272, #390, #624

2018-02-19 Thread GPC Informatics
ect/query?id=90%2C280%2C411%2C583%2C272%2C390%2C624> 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] #280: Medication ontology orgainzed by ingredient

2018-02-19 Thread GPC Informatics
Standardized Vocabularies Drug Domain] Here's hoping for time to ask them if they have a hierarchical form or experience putting it into i2b2. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/280#comment:34> gpc-informatics <http://informatics.gpcnetwork.org/> Gr

Re: [gpc-informatics] #708: Kidney Health CRG Pilot - Information Gathering

2018-08-01 Thread GPC Informatics
<http://informatics.gpcnetwork.org/trac/Project/ticket/708#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] #709: CDMV41 DOSE_ADMIN_UNITS and ROUTE valuesets do not follow PCORNET v1.4 documentation

2018-07-30 Thread GPC Informatics
efault. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/709#comment:1> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listser

Re: [gpc-informatics] #709: CDMV41 DOSE_ADMIN_UNITS and ROUTE valuesets do not follow PCORNET v1.4 documentation

2018-07-30 Thread GPC Informatics
in the DCQA. I mapped all of them to 'OT' in our PRESCRIBING table and reran the SAS dataset load. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/709#comment:2> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network -

[gpc-informatics] #709: CDMV41 DOSE_ADMIN_UNITS and ROUTE valuesets do not follow PCORNET v1.4 documentation

2018-07-28 Thread GPC Informatics
were not in synch with what is accepted as valid by the DCQA code. Only by pulling up the sas tables in \dmlocal\ did I verify the units and route codes that the DCQA accepted as valid. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/709> gpc-informatics

Re: [gpc-informatics] #708: Kidney Health CRG Pilot - Information Gathering

2018-07-25 Thread GPC Informatics
from CRAN) -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/708#comment:6> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.k

Re: [gpc-informatics] #708: Kidney Health CRG Pilot - Information Gathering

2018-07-25 Thread GPC Informatics
need to be installed we should be able to update our R instances. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/708#comment:7> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___

[gpc-informatics] #710: SAS dataset load from CDMV41 tables

2018-08-07 Thread GPC Informatics
By: | Blocking: --+--- Two SAS PROCs for 1) loading of SAS datasets from CDMV41 tables and 2)correcting date/time formats to meet SAS specs. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/710> gpc-infor

Re: [gpc-informatics] #710: SAS dataset load from CDMV41 tables

2018-08-13 Thread GPC Informatics
share the code; so this is done. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/710#comment:1> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev

Re: [gpc-informatics] #411: Align SNOW SHRINE terminology with ARCH and ACT ontology for interoperation of query

2018-08-28 Thread GPC Informatics
@… (added) Comment: trac isn't smart enough to understand what just `gpc-dev` means in the cc field. It has to be spelled out in full. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/411#comment:26> gpc-informatics <http://informatics.gpcnetwork.org/> Gr

Re: [gpc-informatics] #683: medication classification for clinical purposes

2018-08-28 Thread GPC Informatics
| Resolution: Keywords:| Blocked By: Blocking:| --+ Changes (by dconnolly): * cc: gpc-dev (removed) * cc: gpc-dev@… (added) -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/683#comment:4&g

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

2018-08-27 Thread GPC Informatics
Keywords: | Blocked By: Blocking: | -+--- Changes (by campbell): * status: assigned => closed * resolution: => fixed -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/242#commen

Re: [gpc-informatics] #691: Patient Preferred Spoken Language

2018-08-27 Thread GPC Informatics
Keywords: language, cdm | Blocked By: Blocking: | ---+ Changes (by campbell): * status: new => closed * resolution: => fixed -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/691#comme

Re: [gpc-informatics] #709: CDMV41 DOSE_ADMIN_UNITS and ROUTE valuesets do not follow PCORNET v1.4 documentation

2018-08-27 Thread GPC Informatics
c/Project/ticket/709#comment:3> 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] #708: Kidney Health CRG Pilot - Information Gathering

2018-07-24 Thread GPC Informatics
: | Blocked By: Blocking: | ---+ Comment (by jmcclay): UNMC needs to know more about R configuration requirements. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/708#comment:3> gpc-informatics

Re: [gpc-informatics] #708: Kidney Health CRG Pilot - Information Gathering

2018-07-24 Thread GPC Informatics
. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/708#comment:4> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc

[gpc-informatics] #708: Kidney Health CRG Pilot - Information Gathering

2018-07-24 Thread GPC Informatics
with embedded SQL commands. To prepare for this study, we need to assess which sites have CDM data in Oracle/SQL database and are able to run R code. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/708> gpc-informatics <http://informatics.gpcnetwork.org/> Gr

Re: [gpc-informatics] #708: Kidney Health CRG Pilot - Information Gathering

2018-07-24 Thread GPC Informatics
ttp://informatics.gpcnetwork.org/trac/Project/ticket/708#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] #708: Kidney Health CRG Pilot - Information Gathering

2018-07-24 Thread GPC Informatics
twork.org/trac/Project/ticket/708#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] #708: Kidney Health CRG Pilot - Information Gathering

2018-07-24 Thread GPC Informatics
rom Oracle is working -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/708#comment:5> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@

Re: [gpc-informatics] #411: Align SNOW SHRINE terminology with ARCH and ACT ontology for interoperation of query

2018-08-29 Thread GPC Informatics
rr.* from RXCUI_RELATIONSHIPS rr where rr.RXCUI=215568 and rr.RELATION_TYPE in ('SCD','SBD','GPCK','BPCK') order by relation_type would indicate the RxCUI codes for the orderable drug Tylenol. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/411#comment:27> gpc-i

Re: [gpc-informatics] #583: SNOW SCILHS Lab Metadata Expansion

2018-09-04 Thread GPC Informatics
_basecode from pcornet_labs where c_basecode like 'LOINC:%' and c_fullname like '\PCORI\LAB_RESULT_CM\LAB_LOINC%') and c_basecode not like 'LOINC:LP%’; -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/583#comment:15> gpc-informatics <http://informatics.gpcnetwork.or

Re: [gpc-informatics] #711: External Validation for Acute Kidney Injury(AKI) Predictive Models using PCORnet CDM data

2018-09-10 Thread GPC Informatics
-sharing | Resolution: Keywords: aki cdm | Blocked By: Blocking:| --+ Changes (by xsong): * reporter: xsong => meiliu -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/711#comment:6> gpc-informat

Re: [gpc-informatics] #711: External Validation for Acute Kidney Injury(AKI) Predictive Models using PCORnet CDM data

2018-09-07 Thread GPC Informatics
ps://github.com/kumc-bmi/AKI_CDM or xsong's branch: https://github.com/sxinger/AKI_CDM -- -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/711#comment:5> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___

[gpc-informatics] #691: Patient Preferred Spoken Language

2018-04-05 Thread GPC Informatics
? Do we want to convert to the 3-digit model that will be CDM compliant? Is this interpreted as separate from our existing Demographic / Language field? -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/691> gpc-informatics <http://informatics.gpcnetwork.org/> Gr

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

2018-04-10 Thread GPC Informatics
icket/280#comment:36> 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] #691: Patient Preferred Spoken Language

2018-04-12 Thread GPC Informatics
ttp://informatics.gpcnetwork.org/trac/Project/ticket/691#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] #583: SNOW SCILHS Lab Metadata Expansion

2018-03-29 Thread GPC Informatics
(by dconnolly): Note in ticket:411#comment:18 suggestion for all SNOW sites to submit lab frequency info. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/583#comment:14> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network -

Re: [gpc-informatics] #715: NextD request on mapping payer_type variable

2018-10-12 Thread GPC Informatics
t; 0.1%||661 || 86.9% || -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/715#comment:24> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev ma

Re: [gpc-informatics] #715: NextD request on mapping payer_type variable

2018-10-12 Thread GPC Informatics
ttp://informatics.gpcnetwork.org/trac/Project/ticket/715#comment:25> 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] #711: External Validation for Acute Kidney Injury(AKI) Predictive Models using PCORnet CDM data

2018-10-17 Thread GPC Informatics
) : Column `expos_daily` must be length 0 (the number of rows) or one, not 2 -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/711#comment:22> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network -

Re: [gpc-informatics] #711: External Validation for Acute Kidney Injury(AKI) Predictive Models using PCORnet CDM data

2018-10-17 Thread GPC Informatics
in mutate_impl(.data, dots) : > Column `expos_daily` must be length 0 (the number of rows) or one, not 2 -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/711#comment:23> gpc-informatics <http://informatics.gpcnetwork.org/> Greate

Re: [gpc-informatics] #711: External Validation for Acute Kidney Injury(AKI) Predictive Models using PCORnet CDM data

2018-10-17 Thread GPC Informatics
s 479-551 (AKI_CDM_EXT_VALID_p1_QA.Rmd) > Error in mutate_impl(.data, dots) : > Evaluation error: object '2' not found. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/711#comment:21> gpc-informatics <http://informatics.gpcnetwork.org/> Greater P

Re: [gpc-informatics] #711: External Validation for Acute Kidney Injury(AKI) Predictive Models using PCORnet CDM data

2018-10-18 Thread GPC Informatics
s'.) > -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/711#comment:25> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu

Re: [gpc-informatics] #716: Create Trac Accounts

2018-10-18 Thread GPC Informatics
| Blocked By: Blocking: | ---+--- Comment (by lv): Account needed for Steffani Roush - roush.steff...@marshfieldresearch.org -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/716#comment:5> gpc-informatics

Re: [gpc-informatics] #711: External Validation for Acute Kidney Injury(AKI) Predictive Models using PCORnet CDM data

2018-10-18 Thread GPC Informatics
een dateadd(day,-30,pat.ADMIT_DATE) and pat.DISCHARGE_DATE order by PATID, ENCOUNTERID, RXNORM_CUI, RX_START_DATE (Invalid object name '#AKI_onsets'.) -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/711#comment:24> gpc-informatics <http://informatics.gpcnetwork.o

Re: [gpc-informatics] #711: External Validation for Acute Kidney Injury(AKI) Predictive Models using PCORnet CDM data

2018-10-16 Thread GPC Informatics
(AKI_CDM_EXT_VALID_p1_QA.Rmd) Error in mutate_impl(.data, dots) : Evaluation error: object '2' not found. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/711#comment:20> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network -

Re: [gpc-informatics] #714: NextD aggregate counts request

2018-10-16 Thread GPC Informatics
c/Project/ticket/714#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] #711: External Validation for Acute Kidney Injury(AKI) Predictive Models using PCORnet CDM data

2018-10-21 Thread GPC Informatics
are ready to be tested. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/711#comment:27> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.k

Re: [gpc-informatics] #715: NextD request on mapping payer_type variable

2018-11-01 Thread GPC Informatics
/2012 0:00 3/31/2014 0:00 NN BCBS NETWORK BLUE BCBS6 4/1/2014 0:00 (null) -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/715#comment:26> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network -

Re: [gpc-informatics] #711: External Validation for Acute Kidney Injury(AKI) Predictive Models using PCORnet CDM data

2018-10-18 Thread GPC Informatics
> -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/711#comment:26> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://l

Re: [gpc-informatics] #711: External Validation for Acute Kidney Injury(AKI) Predictive Models using PCORnet CDM data

2018-11-07 Thread GPC Informatics
er the JVM reaches the heap size limit. If that occurs, site can decide to restrict collection window by resetting `start_date` and `end_date` (e.g. start_date = "2014-01-01") -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/711#comment:28> gpc-informatics <http

Re: [gpc-informatics] #718: DROC Request #42 - BC data to MCW

2018-11-13 Thread GPC Informatics
ket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/718#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] #719: Oracle is changing their licensing fees

2018-11-14 Thread GPC Informatics
By: Blocking: | ---+ Changes (by dconnolly): * cc: gpc-dev (removed) * cc: gpc-dev@… (added) -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/719#comment:1> gpc-informatics <http://informatics.gpcnetwork.org/

Re: [gpc-informatics] #714: NextD aggregate counts request

2018-10-04 Thread GPC Informatics
6366627 100% -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/714#comment:6> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.k

Re: [gpc-informatics] #711: External Validation for Acute Kidney Injury(AKI) Predictive Models using PCORnet CDM data

2018-10-04 Thread GPC Informatics
ttp://informatics.gpcnetwork.org/trac/Project/ticket/711#comment:17> 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] #715: NextD request on mapping payer_type variable

2018-10-04 Thread GPC Informatics
ter-based financial class. We will follow up on the KUMC code and this ask during Oct. 9th GPC-dev call. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/715#comment:19> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Networ

Re: [gpc-informatics] #715: NextD request on mapping payer_type variable

2018-10-04 Thread GPC Informatics
rk.org/trac/Project/ticket/715#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] #715: NextD request on mapping payer_type variable

2018-10-03 Thread GPC Informatics
billing should contact me for a copy of the SQL. Jim Campbell campb...@unmc.edu -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/715#comment:16> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network -

Re: [gpc-informatics] #715: NextD request on mapping payer_type variable

2018-10-02 Thread GPC Informatics
URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/715#comment:13> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc

<    6   7   8   9   10   11   12   13   >