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
I started trying out the script last week. 1st bit of feedback: It was taking a lot longer than the estimated 20 minutes. Just building the 1st intermediate table took longer than that. I have since lost my sesson/context (had to reboot my desktop... sigh...) I guess my high order feedback is:

RE: Updated milestone report from todays GPC-DEV call; 4Public

2014-10-06 Thread Dan Connolly
Please copy gpc-dev when you submit it, John. -- Dan From: gpc-dev-boun...@listserv.kumc.edu [gpc-dev-boun...@listserv.kumc.edu] on behalf of John Steinmetz [jsteinm...@kumc.edu] Sent: Tuesday, September 30, 2014 1:24 PM To: 'Campbell, James R';

RE: Updated milestone report from todays GPC-DEV call; 4Public

2014-10-06 Thread John Steinmetz
Here is the linkhttps://pcornet.centraldesktop.com/c4gpc/file/34887855/ to the deliverable on CDT. It is one document that contains 2.1, 2.5, and 2.7. 2.3 was previously submitted, and can be found on CDT at this linkhttps://pcornet.centraldesktop.com/c4gpc/file/32487317/. John. From: Dan

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

2014-10-06 Thread GPC Informatics
#158: usable view of LOINC lab terms -+ Reporter: rwaitman | Owner: budh0007 Type: enhancement | Status: assigned Priority: major| Milestone: data-domains2 Component: data-stds| Resolution: Keywords:

gpc-dev agenda 7 Oct

2014-10-06 Thread Dan Connolly
I don't expect we'll get through all of this, so come prepared with input on the order... Tues 11amCT: 1. Convene, take roll, review records and plan next meeting * ​Meeting ID and access code: 686-845-717https://global.gotomeeting.com/meeting/join/686845717; call +1 (267) 507-0008

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

2014-10-06 Thread Dan Connolly
Nice. For bonus points, update the obesity data elements ticket (#33https://informatics.gpcnetwork.org/trac/Project/ticket/33) to note this pattern in general and the obesity aspects in particular. For sensitive material, put it in the KUMC REDCap project I recently invited you to: * GPC

Re: Example (Re: Empirical Data Dictionary)

2014-10-06 Thread Alex Bokov
First of all, I feel like I'm treading into sensitive territory here, in that where I point out on problems it can be misinterpreted as criticizing other people's work. So let me just re-affirm: We are all geeks here. It's us against the bugs. When we engage in debate, both sides win by

RE: Example (Re: Empirical Data Dictionary)

2014-10-06 Thread Dan Connolly
What you've written is entirely responsive to my questions. As I say, I'm largely ignorant of this whole field (emperical data validation), so I appreciate the being educated by way of verbose specifics. I think I have a few substantive questions in response, but I want to read over what you

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

2014-10-06 Thread Dan Connolly
(Please excuse the awkward top-posting format; I'm stuck with Microsoft Outlook.) Perhaps we're converging... the new Data Builder codehttps://informatics.gpcnetwork.org/trac/Project/ticket/134#comment:4 delivers an sqlite3 file, so you can continue to use SQL to analyze it; and if you like