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

Visit Start/End Time

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

4 Posts

3 Users

0 Reactions

61 Views

RSS

Jsnyder

(@jsnyder)

Posts: 13

Eminent Member

Topic starter

We are trying to figure out how to track and report on when our patients are roomed and to when they leave the room. We have added some new types of visits to our scheduling module, but I can't find the status updates anywhere on the database. Has anyone set anything up like this?

Posted : March 11, 2016 11:07 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

I have developed a Crystal Report for summarizing patient flow during a visit and calculating time intervals per physician. The process is not entirely simple. The report returns the following information: arrival to schedule, arrival to create, total MA involvement, create to order, arrive to order, and arrive to sign. Arrive time is from the ActivityLog.created where ActivityLog.Value2="Arrived", schedule time form Appointments.ApptStart, contribute times from DocContrib.Contb_Time, order time is from Orders.Pubtime converted from the ClinicalDate format to date-time, and signed time from Document.Pubtime again converted from ClinicalDate format to date-time.

That information should at least give you a start.

Posted : March 11, 2016 11:45 am

gpincomb

(@gpincomb)

Posts: 278

Reputable Member

Are you by chance looking for the Appointment table then joining that to the MedLists table on Appointment.ApptStatusMId = MedLists.MedListsId where the MedLists.TableName = 'AppointmentStatus' then you can pull the MedLists.Description to get things like "Arrived", "In a Room", "Completed", etc.

If so, you may also want to include the MedLists table where MedLists.TableName = 'AppointmentCancelReasons' so that you can pull "No show" patients.

Posted : March 11, 2016 11:57 am

Jsnyder

(@jsnyder)

Posts: 13

Eminent Member

Topic starter

Thank you very much, this did send me down the right path. I was able to pull all of the information I was looking for out of the activitylog table.

Posted : March 18, 2016 3:44 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 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