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<[email protected]?body=SIGNOFF%20openmrs-implement-l>from > OpenMRS Implementers' mailing list -- *Jonah S. Mwogi System Engineer Ampath Centre - Eldoret Kenya* _________________________________________ 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]
