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

Looking for Crystal report - patient time duration from Checked In to Checked out

Trading Post

Last Post by Anonymous 1 second ago

13 Posts

4 Users

0 Reactions

84 Views

RSS

JSheth

(@jsheth)

Posts: 90

Estimable Member

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

joeg1962

(@joeg1962)

Posts: 843

Noble Member

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

JSheth

(@jsheth)

Posts: 90

Estimable Member

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

mvolkert

(@mvolkert)

Posts: 143

Reputable Member

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

JSheth

(@jsheth)

Posts: 90

Estimable Member

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

mvolkert

(@mvolkert)

Posts: 143

Reputable Member

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

joeg1962

(@joeg1962)

Posts: 843

Noble Member

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

JSheth

(@jsheth)

Posts: 90

Estimable Member

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

ronmoses

(@ronmoses)

Posts: 158

Estimable Member

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

JSheth

(@jsheth)

Posts: 90

Estimable Member

Topic starter

Ron, Do you have a crystal report that you can share? Thanks!

Posted : September 22, 2016 5:01 am

ronmoses

(@ronmoses)

Posts: 158

Estimable Member

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.

turnaroundtimes

Posted : September 22, 2016 5:12 am

JSheth

(@jsheth)

Posts: 90

Estimable Member

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

ronmoses

(@ronmoses)

Posts: 158

Estimable Member

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

Share:

24 Forums
9,942 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.1