Mmmm. I had thought that mapping table had the reference code. So you are just using a pointer to the reference table and the reference table holds the code and whatever name? That is harder to manage, as I can't simply add ICD9 code as a map without adding the ICD9 code to the reference table... which should be carefully maintained. I had thought that the link between mapping table and reference table was not constrained, and that I could add a map that does not necessarily require a reference foreign key.... but that would take advantage of those that did exist. (like an outer join).
Sorry for the misunderstanding (been too long). Andy -------------------- Andrew S. Kanter, MD MPH - Director of Health Information Systems/Medical Informatics Millennium Villages Project, Earth Institute, Columbia University - Asst. Prof. of Clinical Biomedical Informatics and Clinical Epidemiology Columbia University Email: [email protected] Mobile: +1 (646) 469-2421 Office: +1 (212) 305-4842 Skype: akanter-ippnw Yahoo: andy_kanter >________________________________ >From: Wyclif Luyima <[email protected]> >To: [email protected] >Sent: Tuesday, August 30, 2011 4:37 PM >Subject: Re: [OPENMRS-DEV] Creating new reference terms on-the-fly on the edit >concept page > > >Andy, in the new way we are handling the concept mappings, the code is stored >in the associated reference term table, the code is no longer stored in the >mappings table, so if we are to allow creating codes on the fly, technically a >new row is inserted into the concept reference term table. In earlier >discussions we have always said the code is required. > > >Wyclif > >On Tue, Aug 30, 2011 at 4:20 PM, Darius Jazayeri <[email protected]> wrote: > >What do you mean by storing the code for the map without the required >reference term? >>-Darius (by phone) >>On Aug 30, 2011 4:14 PM, "Andrew Kanter" <[email protected]> wrote: >>> >>> >>>I think it makes sense to require a separate form for creating a new >>>reference term. However, If I am adding a reference term as a map, I >>>shouldn't have to create the term as well. It should be OK to just store the >>>code for the map without the required key in the reference table. >>> >>> >>>I think Burke and I both disagree with Roger on the required fields that the >>>code should be required and the name not (on the mapping table). On the >>>reference table it seems that you would want to have both code and name >>>populated. >>> >>> >>>Andy >>> >>> >>>-------------------- >>>Andrew S. Kanter, MD MPH >>> >>>- Director of Health Information Systems/Medical... >>>Email: [email protected] >>>Mobile: +1 (646) 469-2421 >>>Office: +1 (212) 305-4842 >>>Skype: a... >>> >>>>________________________________ >>>>From: Wyclif Luyima <[email protected]> >>>> >>>>> To: [email protected]: Tuesday, August 30, 2011 2:57 >>>>> PM >>>>Subject: Re: [OPENMRS-DEV] Creating new reference terms on-the-fly on the >>>>edit concept page >>>> >>>>> >>>>> I get a feeling that some implementations want to be able to create new >>>>> terms on the fly since t... >>>________________________________ >>>Click here to unsubscribe from OpenMRS Developers' mailing list >> >>________________________________ >> Click here to unsubscribe from OpenMRS Developers' mailing list >>________________________________ > Click here to unsubscribe from OpenMRS Developers' mailing list > > _________________________________________ To unsubscribe from OpenMRS Developers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-devel-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-devel-l]
