Waiting time report - how to?

Submitted by Guest on Mon, 12/08/2013 - 10:33

Implementation discussion

I am trying to build a waiting time performance report - to show stats of how long people waited to get serviced.

act.customerAppointment holds the appointment start and end times and the arrival time.

act.customerTask holds the task (ie worklist entry) start and end times and the start time is a rounded down to the minute of the appointment arrival time, ie it is a rounded down check-in time.

act.patientClinicalEvent holds the visit information (and its start time would appear to be the appointment start time, not the check-in time).

Q: how do I get the 'waiting' time as shown on the worklist single-list view? ie where is the time-stamp for the change in worklist status from pending to in-progress?

Regards, Tim G

Re: Waiting time report - how to?

Submitted by tanderson on Mon, 12/08/2013 - 12:38.

The Time column displays the elapsed time between the startTime and endTime nodes of act.customerTask. If the endTime is unset, then it uses the current time.

The endTime is set to the current time at completion of the Check-Out workflow, although it could be set manually by a user.

-Tim A

Re: Waiting time report - how to?

Submitted by tgething (not verified) on Tue, 13/08/2013 - 08:19.

Thanks Tim - would you object if I created an improvement Jira that suggests that we should add an 'consultStartTime' node to the act.customerTask archetype (akin to the arrivalTime for the appointment) and that it should be set to the current time when the task status changes from pending to in-progress.

This would give us (for historical performance analysis purposes) the act.customerTask nodes:

startTime (S) - time customer checked in
endTime (E) - time task completed
consultStartTime (C) - time that the consult started

So (E-C) = 'processing time'; (C-S) = 'waiting time'; and (E-S) = 'total time'

Note that this information will be inaccurate if 'after the fact' data entry is being done - ie in a single vet practice where the vet writes things up at the end of the day.

However, in a busy reception-driven practice (where the practice manager would appreciate having the performance statistics), the information should be accurate.

Regards, Tim G

Re: Waiting time report - how to?

Submitted by tanderson on Tue, 13/08/2013 - 16:04.

No probs, although if you want to get it in 1.7, it will need to go through the usual project funding.

Regards,

-Tim A

Re: Waiting time report - how to?

Submitted by tgething (not verified) on Tue, 13/08/2013 - 19:05.

Tim - https://openvpms.atlassian.net/browse/OVPMS-1350 created.

Get me a costing and I will see if I can get the funding.

Regards, Tim G

Re: Waiting time report - how to?

Submitted by tanderson on Tue, 13/08/2013 - 23:02.

I've added this project: http://www.openvpms.org/project/task-waiting-time

Did you want Waiting, Consult, and Elapsed Time columns in single worklist view instead of the current Time (i.e. elapsed) column ?

-Tim A

Re: Waiting time report - how to?

Submitted by tgething (not verified) on Wed, 14/08/2013 - 10:56.

Tim - my feeling is to leave the display as it is - ie with just the one Time column on the right. This should display what I think it currently does, ie

while status = Pending, currentTime-startTime ie the waiting time

while status = In-progress, currentTime-startTime ie waiting time + process time

when status = otherwise, endTime-startTime, ie waiting + process time

I am confident that this logic simplifies to: if endTime set, T=endTime, else T=currentTime; Time=T-startTime.

Hence the new field (consultStartTime or arrivalTime or whatever you are calling it) is not in fact used in the screen display, but is available for statistical reports.

ie the approach is: screen optimised for what is happening currently; but consultStartTime is available for statistical analysis (where, as well as the waiting time performance, you could do things like looking at the difference in appointment timeslot length versus actual process process time; appointment start time versus task consultStartTime, etc)

Regards, Tim G