Thanks, Jonah.... I had wondered if that was how I was going to do it. Seems like a great functionality to add to Trunk :)
-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: Jonah S. Mwogi <[email protected]> >To: [email protected] >Sent: Monday, October 17, 2011 1:32 PM >Subject: Re: [OPENMRS-IMPLEMENTERS] Moving encounters to different patients > > >Andy, > >Guess i will give you a technical approach of running the query if you know >the encounter_id and patient_id/person_id as follows: > >update obs SET person_id= XXXX where encounter_id=XXXX > >update encounters SET patient_id=XXXX where encounter_id=YYY > >Not sure of the database you are using so the query may not be appropriately >written. > >Cheers, > > >On Mon, Oct 17, 2011 at 6:36 PM, Andrew Kanter <[email protected]> wrote: > >Has anyone found a way to move an encounter mistakenly placed under one >patient to another one in the database? >> >> >>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 >>________________________________ >> Click here to unsubscribe from OpenMRS Implementers' mailing list > > >-- >Jonah S. Mwogi >System Engineer >Ampath Centre - Eldoret Kenya > >>________________________________ > Click here to unsubscribe from OpenMRS Implementers' mailing list > > _________________________________________ To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-implement-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l]
