How is everyone keeping track of patient wait time. Are you using a 3rd party add on, or doing it through CPS?
redde said:
How is everyone keeping track of patient wait time. Are you using a 3rd party add on, or doing it through CPS?
We have be doing it manually? Any suggests or advice would be great.
Thanks,
Kelly
I have written something with Crystal to look at various data to determine wait times.
1) From rptappt, I can get the appttime
2) I link to the appt table, and db_updated field tells me when last touched (arrived)
3) Only look for patients who are status=3, for arrived
4) Using the doccontb file, I look for the first entry by an MA or med student, which means that the person has begun the visit with someone who is starting the process of taking vitals
Now, there is some trickiness here because a patient who arrives at 9:45 for a 10:00 appt with the MA beginning the note at 10:05 is how long of a wait? As a rule, I take the later of appt time or arrival time, so this would be a 5 minute wait. Likewise, a patient arriving at 10:08 for 10:00 and getting to the MA at 10:18 would be a wait of 10 minutes. Of course, what to do with the 9:45 arrival for a 10:00 and the MA begins at 9:55? Might count as zero wait, or be excluded.
A metric we are experimenting with is to determine for patients who arrive up to the appt time, how many does the MA begin the vitals within five minutes? This eliminates any math issue for the early arrivals: see how many patients arrival time <= appt time as denominator, and the numerator is simply MA vitals time <= appt time + 5 minutes.
Any thoughts on this approach?
We have a manual process using the appointment type which is assigned a color on the schedule, IN ROOM, IN LOBBY, IN HALL , IN LAB , DISCHARGED this allows us to see how many patients are actually in a room and how many are actually waiting to be seen. The staff moves the patients as they interact with them. We only do this for our walk-in clinic and track estimated time to be seen.
Made a program that starts a timer when they are checked in though CPS, and when they actually are roomed, which has an app bar that allows MA's to mark they have roomed the patient.