Notifications
Clear all
Topic starter
Curious to see if anyone else has a solution to track Urgent Care wait times.
We would like to track:
Arrival Time
Check-in Complete
Triaged by Nursing staff
Triage complete
Patient roomed
Provider start time in room
Lab ordered/X-ray ordered
Lab back
X-ray back
Read time
Discharge
Centricity EMR does not really lend itself to capture this information automatically-
so what are others doing? Does anyone have a form that could do this?
Any assistance or guidance you can offer would be greatly appreciated.
Thank you,
Kathy Devin
Applications Manager
Rockwood Clinic
[email protected]
Posted : March 5, 2015 7:31 am
There is no integrated mechanism to do this within Centricity. Developing a form to do this would be very straight forward.
Posted : March 5, 2015 8:42 am
Some of this information can be tracked using the Appointment Status. While we do not track as many data points, we use appointment status to track arrival, check in, being seen by nurse, moved to clinic room, transferred to lab draw, and checked out.
If you wanted to run a report on wait time, you would probably need to run a SQL query looking at the ActivityLog table, which records the time stamps when an appointment status is changed. For example, if we wanted to query the time between patient check-in (Appt Status = Checked In) and when the patient was transferred to nursing for check-in (Appt Status = Being Seen - Nursing), our query would look something like this:
SELECT DISTINCT P.PatientId, P.First, P.Last, B.TM AS CheckedIn, C.TM AS BeingSeen
FROM Appointments A
INNER JOIN PatientProfile P ON A.OwnerId = P.PatientProfileId
LEFT OUTER JOIN
(
SELECT L.PatientProfileId, MIN(L.Created) AS TM
FROM ActivityLog L
WHERE L.FunctionName = 'Change Appointment Status'
AND L.Value2 = 'Checked In'
AND CAST(L.Created AS DATE) = '3/5/2015'
GROUP BY L.PatientProfileId
) C ON C.PatientProfileId = A.OwnerId AND CAST(A.ApptStart AS DATE) = CAST(C.TM AS DATE)
LEFT OUTER JOIN
(
SELECT L.PatientProfileId, MIN(L.Created) AS TM
FROM ActivityLog L
WHERE L.FunctionName = 'Change Appointment Status'
AND L.Value2 LIKE '%Being Seen%'
AND CAST(L.Created AS DATE) = '3/5/2015'
GROUP BY L.PatientProfileId
) B ON B.PatientProfileId = A.OwnerId AND CAST(A.ApptStart AS DATE) = CAST(B.TM AS DATE)
WHERE CAST(A.ApptStart AS DATE) = '3/5/2015'
AND CAST(A.ApptStart AS DATE) = '3/5/2015'
AND A.Canceled IS NULL
AND A.ApptKind = 1
Posted : March 6, 2015 3:58 am
