Notifications
Clear all
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
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
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
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
