drbowen wrote on Wednesday, June 22, 2005:
Sure you can.
from database reporting:
select "forms"
run sql where pid=PatientNumberOfBadInfo
click go
look for the form numbers of the encounter.
go to each form such as:
form_dictation
form_vitals
form_encounter
and delete each offending form
then delete the entries in
forms.
_____________________________________
This most common error is putting the information on the wrong patients chart.
The fix for this is easier. Find the pid for the correct patient and the pid of the correct patient. The easiest way to do this is to open the patients medical record and check the number in the URL. The patient number on the "find patient" result is the "pubpid" and is not always the same as the pid. To get this to work you have to use the true pid.
find the affected forms, such as:
form_dictation
form_vitals
form_encounter
forms
instead of clicking the little red trash can click on the "note pad". This is the edit button.
Open the form in edit mode and change the pid from the bad pid to the correct pid then click on go for each change.
Check that the forms show up in the correct patients chart as expected.
___________________________________________________
Deleting from the database can cause wide spread, permanent loss of data if done incorrectly.
This type of action should only be done by the database administrator and has to logged with specific - verbose - valid reasons to do so. Your reasoning will need to be able to survive federal investigation.