Extracting all data for a patient

mdsupport wrote on Tuesday, June 07, 2011:

Does anyone have script that extracts all data for a patient?  For a practice with significant nbr of terminal patients, we are looking at establishing ‘archive’ installation which replicates all entries for a group of patients.  We currently mark patients as ‘Deceased’ or ‘Inactive’ but that does not help in standard code.

tmccormi wrote on Tuesday, June 07, 2011:

I was think about this and the ‘deleter’ is the closest.   It could be copied and all the SQL for delete could become write output instead … perhaps.

I have an export script that produces a CSV file for selected data, including some history. meds but not everything.

-Tony

mdsupport wrote on Tuesday, June 07, 2011:

We will look at the deleter as starting point.  We will have to include documents as well.  Not sure how auto-incremented id fields will work in the transfer.  Have to try it out.  Thx.