It appears that when a patient record is deleted, billing information-at least balance due, maybe more- is retained. This information is linked to internal ID. This ID is recycled when you enter the next patient and the billing info is then transfered to the new client. A fresh new patient could then appear to have a balance etc.
I there a way to COMPLETELY delete a patient?
This I have asked before: I prefer a popup checkout window. Currently, checkout is only present on the “Fees” menu and opens in lower pane. I had resorted to using “Checkout” from “Popups” menu which would popup my favorite checkout window (instead of opening in lower pane). However, I now cannot find “Checkout” in “Popups” on the demo server. Is there an easy way to fix this?
Can you do an sql query for the pid in the database and then just snuff those rows/values?…not that I would attempt this with a real database…
Any record (including the balance due) I would guess HAS to be linked to PID doesn’t it, at very least an encounter ID, which includes a patient id…right? Something like that?
Been sniffing around the database and found some suspicious tables including ar_activity, ar_session and billing. They seem to hold the “Inherited” info. Will try playing around with the rows/values in a test environment and see what happens.
looks like they are log tables. But I’m not sure if you want to erase them as well, depending upon whether you want to have a record of what was deleted and when. Also recycling of IDs seems unusual. I need to test it on my demo server and see how it works. I guess that deleted a patient is not that simple as there are multiple entities tied to the patient data record.