This proposal, like the previous one, directly constrains the patient_dimension, provider_dimension, and visit_dimension. Milestone_27_TestSQLv2.docx<https://informatics.gpcnetwork.org/trac/Project/attachment/ticket/114/Milestone_27_TestSQLv2.docx><https://informatics.gpcnetwork.org/trac/Project/raw-attachment/ticket/114/Milestone_27_TestSQLv2.docx> added
Those constraints conflict with practices and preferences at our site (and, as I recall, several others). Plus, those constraints don't specify the concept paths (c_fullname in metadata tables) that would actually appear in the relevant queries. Agreement on paths is necessary and sufficient for our work, as far as I can tell. Given what I've seen so far, I disagree with any proposal that directly constrains the i2b2 table schema. I tried to explain how paths are sufficient in last week's call, and I agreed to elaborate in detail. But as I mentioned, I'm at a conference this week, so I'm not sure I'll have it done in time for the May 6 call. -- Dan
_______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
