-
About This SQL is used to determine the time elapsed when the appointment was booked and when the appointment took place. For a given day you specify, it shows the date-time stamp of when the appointment was booked, the actual appointment date/t...
-
About This report indicates the elapsed time spent in all statuses for all appointments between the two dates that you specify. A sample image of this SQL report run in the Database Viewer is shown below: Caveats This report can be modifi...
-
About This report shows all appointments scheduled, and by which staff member, for a period between two specified dates. A sample image of this SQL report run in the Database Viewer is shown below: Caveats If an appointment is moved, the p...
-
About This report looks for active patients under the age of 60 days old (at the time the report is run) who do not have a future appointment (of any kind) scheduled. It also lists if patients have had a recent visit in the office. This can be u...
-
About This report displays all completed visits on the schedule for infants 30 days old or less on the day of the appointment, for an appointment date range you specify. A sample image of this SQL report run in the Database Viewer is shown belo...
-
About This report shows how frequently different rooms/resources were used between two schedule dates you specify. A sample image of this SQL report run in the Database Viewer is shown below: Caveats Rooms and Resources must be set up in ...
-
About This report shows all active patients with active-non medication allergies, along with detail about the allergy. A sample image of this SQL report run in the Database Viewer is shown below: Caveats None. Code To highlight and copy th...
-
About This report shows all appointments with visit status “No Show,” along with confirmation status & date, location, appointment date, chart number, and type of visit for two schedule dates you specify. A sample image of this SQL report run i...
-
About This report shows location, scheduled provider, appt date & time, patient name, chart number, DOB, appt type, primary phone number, visit status for the date range that you specify. A sample image of this SQL report run in the Database Vi...
-
About
This report shows the patient name, DOB, patient phone number, and schedule information (scheduled provider, date/time, and location) for cancelled appointments in a date range that you specify.
A sample image of this SQL repo...
-
About
For a date range you specify, shows all patients seen for sick and well visits along with the rendering provider for that visit, along with the patient’s assigned PCP in the REGISTER.
A sample image of this SQL report run in the ...
-
About This report shows patient name, DOB, patient phone number and schedule information (scheduled provider, date/time, and location) for patients who have more than one future appointment scheduled. A sample image of this SQL report run in th...
-
About This report shows list of patients who no-showed today, along with their no-show list prior to today. A sample image of this SQL report run in the Database Viewer is shown below: Caveats Includes both hard (“No Show”) and soft (“No Sho...
-
About This SQL identifies patient charts that have a Default Appointment Type that does not match an Appointment Type in your system. A sample image of this SQL report run in the Database Viewer is shown below: Caveats If the SQL returns no...
-
About This SQL identifies Appointment Types on scheduled appointments that do not match an Appointment Type in your system. Caveats If the SQL returns no results, then there is no action necessary. If results are returned, the appointment nee...
-
About This SQL identifies Appointment Types attached to Visit Templates that do not match an Appointment Type in your system. A sample image of this SQL report run in the Database Viewer is shown below: Caveats If the SQL returns no results, ...