Regarding the #44 Portable Heron notes, one situation I’ve dealt with is references to a table which I do not have. From naaccr_concepts_load.sql, for instance:
(select * from BlueHeronData.source_master@deid where source_cd like 'tumor_registry@%') I don’t have a “source_master” table, and can’t begin to guess what “*” might comprise. (OK, I know one field is called “source_cd”.) In other cases I’ve been able to infer what’s missing, or what our local name for a given table is, but this one stopped me cold. For a database script to be portable, there need to be definitions somewhere of the tables and fields referenced. This could be in the form of a data dictionary, or it could be simply output of data definition language (DDL) from the tables referenced. Oftimes the first script run does all the DDL up front, with data manipulation language (DML) in a separate script that can be run iteratively. Apologies if I missed something obvious. Peril of being the “new kid”… p.s. If I did miss it,kindly point it out using small words and simple gestures. ;) From: gpc-dev-boun...@listserv.kumc.edu [mailto:gpc-dev-boun...@listserv.kumc.edu] On Behalf Of Dan Connolly Sent: Tuesday, January 27, 2015 9:46 AM To: gpc-dev@listserv.kumc.edu Subject: HackathonTwo follow-up action items I'm going over the meeting notes<https://informatics.gpcnetwork.org/trac/Project/wiki/HackathonTwo#record> (thanks, Laurel!) looking especially for follow-up items. I added comments that some of them aren't quite clear (as well as presentation materials to find, etc.) This is a summary of follow-up action items that I found so far: Names in section headings indicate follow-up item ownership. Day 1 - Thu, Jan 22<https://docs.google.com/document/d/13dA_ml1GSIhZ7fs-fWle5dPU95UlFQEoS6HJezSgKyQ/edit#heading=h.w3yrm6qir16q> Introductions, Opening Remarks - GPC Phase 2 LOI<https://docs.google.com/document/d/13dA_ml1GSIhZ7fs-fWle5dPU95UlFQEoS6HJezSgKyQ/edit#heading=h.46n62mizfpxm> AM Session 1 - GPC CDM ETL (Campbell, Graham?)<https://docs.google.com/document/d/13dA_ml1GSIhZ7fs-fWle5dPU95UlFQEoS6HJezSgKyQ/edit#heading=h.1ahl9lh7w5ei> AM Session 1 - Heron Code Sharing<https://docs.google.com/document/d/13dA_ml1GSIhZ7fs-fWle5dPU95UlFQEoS6HJezSgKyQ/edit#heading=h.zdilnib5ekxc> identified i2b2 (Mosa@MU)<https://docs.google.com/document/d/13dA_ml1GSIhZ7fs-fWle5dPU95UlFQEoS6HJezSgKyQ/edit#heading=h.523suzwa3zeu> AM Session 2 - Breast Cancer Survey Finder FIle (Kowalski, UMN, UIOWA, MCRF, UTSW, McMahon)<https://docs.google.com/document/d/13dA_ml1GSIhZ7fs-fWle5dPU95UlFQEoS6HJezSgKyQ/edit#heading=h.nf8258clqxww> AM Session 2 - Obesity, BMI percentile (?)<https://docs.google.com/document/d/13dA_ml1GSIhZ7fs-fWle5dPU95UlFQEoS6HJezSgKyQ/edit#heading=h.okvaig1ygap4> AM Session 2 - Terminology Mapping Strategies<https://docs.google.com/document/d/13dA_ml1GSIhZ7fs-fWle5dPU95UlFQEoS6HJezSgKyQ/edit#heading=h.c9scujdqyl8e> PM Session 1 - Terminologies (Reeder, Campbell, Connolly)<https://docs.google.com/document/d/13dA_ml1GSIhZ7fs-fWle5dPU95UlFQEoS6HJezSgKyQ/edit#heading=h.bl4ohqy5t9xr> PM Session 2 - Data Quality (?)<https://docs.google.com/document/d/13dA_ml1GSIhZ7fs-fWle5dPU95UlFQEoS6HJezSgKyQ/edit#heading=h.v6pigqrdquys> PM Session 2 - Encounters<https://docs.google.com/document/d/13dA_ml1GSIhZ7fs-fWle5dPU95UlFQEoS6HJezSgKyQ/edit#heading=h.qhq7fmqwj9xi> PM Session 2 - Text Deidentification (Jacquie @ MCRF)<https://docs.google.com/document/d/13dA_ml1GSIhZ7fs-fWle5dPU95UlFQEoS6HJezSgKyQ/edit#heading=h.mhfn3n5l9hx> DAY 2<https://docs.google.com/document/d/13dA_ml1GSIhZ7fs-fWle5dPU95UlFQEoS6HJezSgKyQ/edit#heading=h.4te681ghpj2u> AM Session 1 - Usable LOINC Lab Hierarchy - (Apathy)<https://docs.google.com/document/d/13dA_ml1GSIhZ7fs-fWle5dPU95UlFQEoS6HJezSgKyQ/edit#heading=h.5yzy9wlfcb19> AM Session 1 - NLP/Text Notes Code Sharing<https://docs.google.com/document/d/13dA_ml1GSIhZ7fs-fWle5dPU95UlFQEoS6HJezSgKyQ/edit#heading=h.ydcola9j7ok> AM Session 2 - Federated login (Mish)<https://docs.google.com/document/d/13dA_ml1GSIhZ7fs-fWle5dPU95UlFQEoS6HJezSgKyQ/edit#heading=h.wnkejbhu1tmr> AM Session 2 - Building Analytic Datasets<https://docs.google.com/document/d/13dA_ml1GSIhZ7fs-fWle5dPU95UlFQEoS6HJezSgKyQ/edit#heading=h.u7ngvpz55k2i> Using heron_extract to reshape data for use in REDCap<https://docs.google.com/document/d/13dA_ml1GSIhZ7fs-fWle5dPU95UlFQEoS6HJezSgKyQ/edit#heading=h.nvkllaqj6uky> Analyzable Data<https://docs.google.com/document/d/13dA_ml1GSIhZ7fs-fWle5dPU95UlFQEoS6HJezSgKyQ/edit#heading=h.tfawvpu2vbot> Data Analyzer User Interface<https://docs.google.com/document/d/13dA_ml1GSIhZ7fs-fWle5dPU95UlFQEoS6HJezSgKyQ/edit#heading=h.dpnvwd4jzxgm> PM Session 1 - EMR Integration<https://docs.google.com/document/d/13dA_ml1GSIhZ7fs-fWle5dPU95UlFQEoS6HJezSgKyQ/edit#heading=h.xy7jgds0qjnw> PM Session 2<https://docs.google.com/document/d/13dA_ml1GSIhZ7fs-fWle5dPU95UlFQEoS6HJezSgKyQ/edit#heading=h.q0osz6mvtv3c> -- Dan
_______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev