Patient disappeared from system after deleting secondary and tertiaray insurance info

Patient came in for a scheduled appt. and their record couldn’t be found.
Patient’s document folder is still in the system.
Patient can still be found on our backup server.
Log search for “Patient Record” + “delete” showed only 2 lines for insurance deletions for this PID.
Server reboot had no effect.

Is there a way to recover just this patients record from the backup server and import it back into the main server?

OpenEMR Version
I’m using OpenEMR version 6.1.0 (1)

FF 101.0

Operating System
Utuntu 18.04
Did you check the logs? Yes
Was there anything pertinent in them? No
Please paste them here (surround with three backticks (```) for readability.
You can also turn on User Debugging under Administration->Globals->Logging User Debugging Options=>All

Delete button was pressed that applies to patient record and not just insurance?

Possible but doubtful. Logs don’t show patient delete, just secondary and tertiary insurance.
User in question has been with us for 8 years and system would have warned prior to delete.
It was reported that the patient in the previous time slot was also showing in the time slot of the patient in question around mid-morning however, the provider distinctly recalls the calendar was showing two different patients in their proper time slots earlier in the morning. This is proven by the backup server which was not accessible by staff and shows both patients still in their respective slots.
Also, if patient had been deleted, their documents folder would also have been missing, yet it’s still in there. Right?

documents folder and contents still exists after patient delete

We are not aware of any transfer tool that will allow selective restore of a patient from backup. So you will have to restore selective records from last valid backup. That is something not done using this forum.

Does the patient still exist in the patient_data table? Its possible there’s a query that is messed up preventing the patient from displaying.

Now this;
We have discovered that the patient who disappeared (Patient A) is now appearing as a duplicate of the patient who had the prior appointment (Patient B). When searching for Patient B, duplicate entries are displayed however, only the first (top) entry is correct. The second entry displays the encounters, CAMOS Notes, ID Photo and all the other documents of Patient A, yet all the Demographics are of Patient B. How can this be corrected?

Without knowing if anything was done between last question and “Now this;” it would appear that someone/something is having fun with patient records or unknowingly created duplicates. What was your finding about patient_data table that @adunsulag asked?

It will help you in debugging if the list columns also included id and pid columns in addition to pubpid (Exeternal ID). Most of the application uses pid to link records and id as main key for system use.


1 Like

Is it possible someone accidentally edited the patient’s name and lastname?
Go back in the log audit to the approximate time the patient disappeared.


Patient “A” Data Table showed Patient “B” Demographics which clued me in on what happened.
Audit log search for “ALL” using Patient “A” PID revealed that during insurance updates, staff mistakenly replaced Patient “A” insurance and demographics with Patient “B” info.

Sandra: Good call.


Thank goodness you figured it out!

1 Like