Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Tracking Urgent Care Wait times

General Discussion

Last Post by chaddix 10 years ago

3 Posts

3 Users

0 Reactions

80 Views

RSS

kdevin

(@kdevin)

Posts: 75

Estimable Member

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

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

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

chaddix

(@chaddix)

Posts: 177

Estimable Member

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

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0