Re: Empirical Data Dictionary: MCRF and UTHSCSA results

2014-10-28 Thread Alex Bokov
I'm getting KUMC's secure encrypted attachment notice when I sent the XLS file with the updated empirical data dictionary. There is nothing sensitive in the attachment, I don't know what triggered this. I'm tempted to zip the file and re-send it to the list. Is there any reason (Dan, Russ) I

RE: Empirical Data Dictionary: MCRF and UTHSCSA results

2014-10-28 Thread Dan Connolly
...@uthscsa.edu] Sent: Tuesday, October 28, 2014 10:04 AM To: gpc-dev@listserv.kumc.edu Subject: Re: Empirical Data Dictionary: MCRF and UTHSCSA results I'm getting KUMC's secure encrypted attachment notice when I sent the XLS file with the updated empirical data dictionary. There is nothing sensitive

Re: R, SQL, i2b2, and governance RE: Example (Re: Empirical Data Dictionary)

2014-10-07 Thread Alex Bokov
Yes, I'm fully in agreement there-- no direct, unlimited queries by investigators. Or under normal circumstances, us, for that matter. The only variable parts are the patient/visit sets. I see the goal of the initial cohort work is learning how to generalize these queries so they can be

RE: R, SQL, i2b2, and governance RE: Example (Re: Empirical Data Dictionary)

2014-10-07 Thread Dan Connolly
...@listserv.kumc.edu [gpc-dev-boun...@listserv.kumc.edu] on behalf of Alex Bokov [bo...@uthscsa.edu] Sent: Tuesday, October 07, 2014 9:41 AM To: gpc-dev@listserv.kumc.edu Subject: Re: R, SQL, i2b2, and governance RE: Example (Re: Empirical Data Dictionary) Yes, I'm fully in agreement there-- no direct, unlimited

Example (Re: Empirical Data Dictionary)

2014-10-06 Thread Alex Bokov
Kind thanks to KUMC and the sites that volunteered to test. With help from Wisconsin and MCW so far, I have a lot of revisions to add to the original script that make the output smaller, the syntax less Oracle-specific, and eliminate or scrub certain fields. If you're not one of the test sites,

RE: Example (Re: Empirical Data Dictionary)

2014-10-06 Thread Dan Connolly
...@listserv.kumc.edu] on behalf of Alex Bokov [bo...@uthscsa.edu] Sent: Monday, October 06, 2014 12:57 PM To: gpc-dev@listserv.kumc.edu Subject: Example (Re: Empirical Data Dictionary) Kind thanks to KUMC and the sites that volunteered to test. With help from Wisconsin and MCW so far, I have

RE: pattern of cohort characterization needs? RE: Empirical Data Dictionary

2014-10-06 Thread Dan Connolly
, October 06, 2014 1:45 PM To: gpc-dev@listserv.kumc.edu Subject: Re: pattern of cohort characterization needs? RE: Empirical Data Dictionary I don't claim this covers all cases, only the ones I can think of so far. If anyone can think of a cohort characterization question that cannot be answered

Re: Example (Re: Empirical Data Dictionary)

2014-10-06 Thread Alex Bokov
*From:* gpc-dev-boun...@listserv.kumc.edu [gpc-dev-boun...@listserv.kumc.edu] on behalf of Alex Bokov [bo...@uthscsa.edu] *Sent:* Monday, October 06, 2014 12:57 PM *To:* gpc-dev@listserv.kumc.edu *Subject:* Example (Re: Empirical Data Dictionary) Kind thanks to KUMC and the sites that volunteered

RE: Example (Re: Empirical Data Dictionary)

2014-10-06 Thread Dan Connolly
wrote a couple more times. -- Dan From: gpc-dev-boun...@listserv.kumc.edu [gpc-dev-boun...@listserv.kumc.edu] on behalf of Alex Bokov [bo...@uthscsa.edu] Sent: Monday, October 06, 2014 5:05 PM To: gpc-dev@listserv.kumc.edu Subject: Re: Example (Re: Empirical Data

R, SQL, i2b2, and governance RE: Example (Re: Empirical Data Dictionary)

2014-10-06 Thread Dan Connolly
...@listserv.kumc.edu] on behalf of Alex Bokov [bo...@uthscsa.edu] Sent: Monday, October 06, 2014 5:05 PM To: gpc-dev@listserv.kumc.edu Subject: Re: Example (Re: Empirical Data Dictionary) [...] I've seen pretty good cohort characterization progress w.r.t. breast cancer and ALS based on HERON data

RE: Empirical Data Dictionary

2014-10-03 Thread Verhagen, Laurel A
Hi Alex, Just wanted to let you know that Marshfield is working on this as well. It’s taking a little longer for us, because of converting from ORACLE to SQL. Thanks, Laurel From: gpc-dev-boun...@listserv.kumc.edu [mailto:gpc-dev-boun...@listserv.kumc.edu] On Behalf Of Alex Bokov Sent:

Re: Empirical Data Dictionary

2014-10-03 Thread Alex Bokov
Thank you very much. I'm happy to help at our end by making the query less Oracle-specific if you let me know which statements generate errors. Have a great weekend. On 10/03/2014 02:25 PM, Verhagen, Laurel A wrote: Hi Alex, Just wanted to let you know that Marshfield is working on this as

RE: Empirical Data Dictionary

2014-10-03 Thread Apathy,Nate
: Friday, October 03, 2014 2:25 PM To: Alex Bokov Cc: gpc-dev@listserv.kumc.edu Subject: RE: Empirical Data Dictionary Hi Alex, Just wanted to let you know that Marshfield is working on this as well. It’s taking a little longer for us, because of converting from ORACLE to SQL. Thanks, Laurel

pattern of cohort characterization needs? RE: Empirical Data Dictionary

2014-10-03 Thread Dan Connolly
most cohort characterization needs seem to follow the same basic pattern What pattern is that? -- Dan From: gpc-dev-boun...@listserv.kumc.edu [gpc-dev-boun...@listserv.kumc.edu] on behalf of Alex Bokov [bo...@uthscsa.edu] Sent: Wednesday, October 01, 2014 5:26