As of Genie version 9.3.5, it is possible to track how long a patient has been in with the doctor via the appointment book. The timing will show up in the Time with Dr column once the doctor has saved out of the clinical window. It is then possible to report on the time the doctor has spent with particular patients. This article outlines how to use QuickReports to gather this information.
Before you begin
If you haven't used QuickReports before you may find our Using QuickReports article beneficial.
Appointment Duration by Provider
To find all appointment durations for a particular provider, navigate to File > QuickReports and follow the below steps:
- In the Table tab select [ApptTimingEvent] and click Query
- A new Query window will open up. Under Available Fields, select the arrow to the left of ApptTimingEvent. This will open new options.
- Select ApptProviderName and choose 'contains' in the Comparison table.
- In Value enter in the surname of the provider
- If you would like to limit the search by any other fields, you can select Add Line and add in the appropriate details
- When you are happy with your search, click Query
- You will be returned to the Report Builder window where you will need to click on the Columns tab. From Database Fields you can click and drag any Field you would like to include in the report over to Report Columns. For this search we would recommend the following:
- [Appt]ProviderName
- [Appt]Name
- [Appt]StartDate
- [Appt]StartTime
- Note: For the above fields under the [Appt] table, you will need to expand the APT_ID_Fk field shown in the Database Fields list.
- [ApptTimingEvent]DurationSeconds
- When you are happy with the columns you have included, you can Preview, Print or Export your report.
Appointment Durations in a Particular Date Range
To find all appointment durations for a particular date range, navigate to File > QuickReports and follow the below steps:
- In the Table tab select [ApptTimingEvent] and click Query
- A new Query window will open up. Under Available Fields, select the arrow to the left of ApptTimingEvent. This will open new options.
- Select ApptStartDate and choose 'is greater than or equal to' in the Comparison table.
- In Value enter the first date of the date range you wish to search
- Select Add Line
- In Available Fields choose ApptStartDate again and select 'is greater than or equal to' in the Comparison table.
- In Value, enter the last date of the date range you wish to search
- If you would like to limit the search by any other fields, you can select Add Line and add in the appropriate details
- When you are happy with your search, click Query
- You will be returned to the Report Builder window where you will need to click on the Columns tab. From Database Fields you can click and drag any Field you would like to include in the report over to Report Columns. For this search we would recommend the following:
- [Appt]ProviderName
- [Appt]Name
- [Appt]StartDate
- [Appt]StartTime
- Note: For the above fields under the [Appt] table, you will need to expand the APT_ID_Fk field shown in the Database Fields list.
- [ApptTimingEvent]DurationSeconds
- When you are happy with the columns you have included, you can Preview, Print or Export your report.
Appointment Durations for a Particular Appointment Type
To find all appointment durations for a particular appointment type, navigate to File > QuickReports and follow the below steps:
- In the Table tab select [ApptTimingEvent] and click Query
- A new Query window will open up. Under Available Fields, select the arrow to the left of ApptTimingEvent. This will open new options.
- Select ApptReason and choose 'contains' in the Comparison table.
- In Value enter the Appointment Type you would like to search on
- If you would like to limit the search by any other fields, you can select Add Line and add in the appropriate details
- When you are happy with your search, click Query
- You will be returned to the Report Builder window where you will need to click on the Columns tab. From Database Fields you can click and drag any Field you would like to include in the report over to Report Columns. For this search we would recommend the following:
- [Appt]ProviderName
- [Appt]Name
- [Appt]StartDate
- [Appt]StartTime
- [Appt]Reason
- Note: For the above fields under the [Appt] table, you will need to expand the APT_ID_Fk field shown in the Database Fields list.
- [ApptTimingEvent]DurationSeconds
- When you are happy with the columns you have included, you can Preview, Print or Export your report.
Comments
2 comments
I am trying to get a useful output from the quickreport described above. For today, when I query how many appointments lasted >5minutes, I get 15 results, but can not see how to output the actual duration beside the patients name. The only table in the " columns" tab is [Patient], and no other tables are available....
Is this a glitch or am I missing something? the following fields are not available
Hi Daniel, thank you for your query. In order to report on appointment duration, you will need to be performing the QuickReport on the [ApptTimingEvent] table. I have created a ticket on your behalf and will send you an email with further information.