Client

SELECT c.Table_Name FROM Information_Schema.COLUMNS c WHERE c.Table_Schema = 'hhapowerpath' AND LOWER(c.column_name) = 'patient_id' ArrayAppend(tables, #getTables.Table_Name#); DELETE FROM #tables[i]# WHERE Patient_Id = '#url.pid#'
DELETE FROM #tables[i]# WHERE Patient_Id = '#url.pid#'

The Patient record has been Completely Removed from the system.

Patient List

SELECT First_Name_M0040, Last_Name_M0040, Middle_Initial_M0040 FROM #Request.prefix_db_agency#.patient WHERE Agency_Id = '#session.AgencyId#' AND Patient_Id = '#url.pid#'

Thinking about deleting #getPatient.First_Name_M0040# #getPatient.Middle_Initial_M0040#. #getPatient.Last_Name_M0040#...

Last Chance to change your mind!

Are you SUPER SUREsure you want to Completely Delete this Patient record from the system? xy' onclick = "document.getElementById('yn').style.display = 'none';" >Yes No