Reports > Clients > List (e.g. interface/reports/patient_list.php) gives:
Last visit date, patient’s last name, first name, middle name, ID, street, city, state, zip, home phone, work phone.
Would anyone please be so kind as to give me the MySQL query for a similar report but that would instead give the following for a specific date:
ID, last visit date and time, facility name, encounter provider, patient’s last name, first name, middle name, date of birth, sex, reason for encounter.
I would be very grateful for this. Thank you very much inadvance.