Notifications
Clear all
Topic starter
I am looking for a crystal report with patient time duration from Checked In to Checked out.
Do anyone has that can share?
Thanks!
Posted : September 15, 2016 4:18 am
There are OBS terms defined to hold the two times, and a report from those would be fairly simple. Otherwise, a report would have to make assumptions about various steps to guess at the times.
Do you set check-in and check-out times?
Posted : September 15, 2016 4:21 am
Topic starter
We change the status to "Checked in" when patient arrives and "Checked out" when patient leaves. What are the OBS terms? I tried to look for data table model but not able to find it.
Thanks!
Posted : September 15, 2016 4:28 am
If you're looking for information on individual patients, within the schedule you can select "View > Appointment Activity List" and it will tell you the amount of time the patient was in each status.
Posted : September 15, 2016 5:49 am
Topic starter
Thank you but I am looking for the report which can list all appointments for a day.
Posted : September 15, 2016 5:52 am
That's kind of what I thought. I'd also be interested in that kind of report if you find one. Thanks!
Posted : September 15, 2016 5:55 am
Two things to look at:
1) For a completed office visit, look at the related Flowsheet OBS terms for it. You will see BP items, probably Smoking, etc... Look to see if you put something into terms that look like check-in.
2) In the patient appointment view, click to "View Details..." and at the bottom Comments section, does it record notes and times for Check-in and Check-out?
Based on how you answer those two questions, that may point a way to knowing and then being able to report.
Posted : September 15, 2016 6:32 am
Topic starter
Joe, I am looking for report on PM side on schedule. Report which lists total time patient was at our practice (from checked in- in waiting room- in exam room to checked out).
Posted : September 15, 2016 6:58 am
We use the ActivityLog table, and look for the events "Arrived" and "Completed" for the appointment. Here's my blog post on the subject: http://www.the-mosi.net/geblog/?p=493
Posted : September 22, 2016 3:24 am
Topic starter
Ron, Do you have a crystal report that you can share? Thanks!
Posted : September 22, 2016 5:01 am
I'm happy to share it, but it's based on a stored procedure and there are a few things in there that are kinda specific to how we do business. Also, there is a function and a view that are needed to support the stored procedure. I'm happy to attach the report, stored procedure, function, and view; I only worry that there's going to be something in there that doesn't quite conform to how you do things.
Additionally, my code is very under-documented, and I apologize for that. I'm happy to explain whatever needs explaining and hopefully help you tweak everything to suit your needs.
Posted : September 22, 2016 5:12 am
Topic starter
Ron, I loaded your report in my test system but I see that you have customized to a specific location. I do not have crystal report license for EMR so I am not sure how to tweak your report to show all locations. I have crystal licensce for PM. Do you know where CPS stores appointment activities log. If you can forward files and tables that I can search. Where on GE site I can find the DB tables? Thank you for all your help!
Posted : September 22, 2016 5:40 am
For the activity data, you're looking in the ActivityLog table for records where TableName = 'Appointments' and Value2 = 'Arrived' or 'Completed'. RecordId is the AppointmentsId.
If you're looking for the database schema...
1. Go to https://engage.gehealthcare.com/welcome
2. Click Centricity Practice Solution under Your Solutions.
3. Click Access Documentation under Resources.
4. Scroll down to CPS12 Data Dictionary. It explains how to use the file.
Posted : September 22, 2016 6:39 am
