Reporting on waiting times

[Harland-Dear]

Is there a report I can use to do an audit on patient waiting times? How long patient has waited on average per clinician for each month? The purpose of this audit is to establish how long patients wait before they go into surgery (dentist running late, on time, etc)

Would someone be able to assist

[Alison_Daniels]

Good Afternoon
Unfortunately there isn't a report on waiting time or a way to calculate it in R4.
Kind regards
Aliso

[Alison_Daniels]

Good Morning

After some research I have been advised by a colleague that you can create a bespoke report to show average waiting time.

To create a report to show average waiting time by performer

1. Open Report Manager
2. Highlight ‘Reports not in a category’
3. Click ‘New Report’ then ‘Start’
4. Click the ellipsis to create a new query
5. Click ‘New Query’ then ‘Start’
6. Highlight ‘Appointments’ then ‘Next’
7. Tick ‘that have certain attributes’ then ‘Specify Attributes’
8. Add ‘Date’ to the ‘Criteria’ window
9. Amend the ‘operator’ column to ‘is later than or equal to’ tick the Ask box then click ‘OK’ and amend the question to say ‘please specify the start date’
10. Add ‘Date’ again to the ‘Criteria’ window
11. Amend the ‘operator’ column to ‘is earlier than or equal to’ tick the Ask box then click ‘OK’ and amend the question to say ‘please specify the end date’ the click
12. Click ‘OK’
13. Then tick the box next to ‘that have been completed’
14. Click ‘Finish’ then save the query
15. Select the query just made then click ‘Next’
16. Click ‘Report Layout’
17. Click on ‘click here to edit report properties’ (in blue)
18. Select the from the Fields list the following; Treatment Provider, Date,  and from the Lead Times Visit time, Waiting Time and Surgery Time
19. For the last 3 tick the boxes to show Total and Average
20. Click ‘OK’ then ‘Finish’ and finally save the report.

I hope this gives you the information you require.

Kind regards

Alison