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

Query CPS for Provider Schedule Availability

General Discussion

Last Post by mikeseale 8 years ago

4 Posts

3 Users

0 Reactions

72 Views

RSS

CaseyBryson

(@caseybryson)

Posts: 1

New Member

Topic starter

What is the best way to ask GE for a provider's availability? I am working on connecting an external specialty application to both GE and Epic, it will reside "in the middle".

I know how to query both Epic and GE for patient demographic matches and operate as an external MPI.

I also know how to use Epic's web services to ask for provider availability.

Does GE have something similar? How do I ask the system for provider availability on a given day and return that to the scheduler so I am not inserting an inefficient process (literally calling the clinic before scheduling an appointment to do manual conflict checking).

THANKS for any help you can provide!

Casey

Posted : December 13, 2016 6:51 am

mikeseale

(@mikeseale)

Posts: 344

Reputable Member

This could get you started. I developed an application to generate the providers' schedules for users outside of Centricity. Here is the SQL query I use to pull their schedule. @doctorfacilityid would be the provider you need the schedule for; along with the start and end date. If ApptsId column is null, there isn't anything schedule in that time slot. ListOrder is the column on the schedule. Ideally you would want all columns of a row on the schedule to be NULL to consider the provider "available":

DECLARE @dtStartDate DATETIME, @dtStopDate DATETIME, @doctorfacilityid INT SELECT @dtStartDate = DATEADD(DD, -1, GETDATE()), @dtStopDate = GETDATE(), @doctorfacilityid = 119

SELECT vApptSlot.Start AS TimeStart, vApptSlot.Stop AS TimeStop, vApptSlot.ListOrder, vApptSlot.ScheduleId, vApptSlot.FacilityId, vApptSlot.ApptSlotId AS ScheduleTimesId, Schd.DoctorResourceId, dr.Type AS ResourceType, df.ListName AS FacilityName, df.Color AS FacilityColor, vApptSlot.Overbooked, vApptSlot.Status, vApptSlot.ApptId As ApptsId, (CASE WHEN vApptSlot.ListOrder < 0 THEN 99999 ELSE vApptSlot.ListOrder END) AS SortedListOrder FROM (Schedule AS Schd WITH (NOLOCK) INNER JOIN DoctorFacility AS dr WITH (NOLOCK) ON Schd.DoctorResourceId = dr.DoctorFacilityId INNER JOIN ApptSlot AS vApptSlot WITH (NOLOCK) ON Schd.ScheduleId = vApptSlot.ScheduleId AND (vApptSlot.Start < @dtStopDate AND vApptSlot.Stop > @dtStartDate AND (vApptSlot.Overbooked IS NULL OR (vApptSlot.Overbooked IS NOT NULL AND vApptSlot.ApptId IS NOT NULL))) INNER JOIN DoctorFacility AS df WITH (NOLOCK) ON vApptSlot.FacilityId = df.DoctorFacilityId) LEFT JOIN Appointments AS vAppts WITH (NOLOCK) ON (Schd.DoctorResourceId = vAppts.ResourceId AND vApptSlot.ApptId = vAppts.AppointmentsId) AND (vAppts.ApptStart < @dtStopDate AND vAppts.ApptStop > @dtStartDate) WHERE Schd.DoctorResourceId = @doctorfacilityid ORDER BY vApptSlot.Start, SortedListOrder, vApptSlot.FacilityId

Posted : December 22, 2016 9:53 am

abulsara

(@abulsara)

Posts: 150

Estimable Member

Mike,

How to you handle if the Provider or Resource has a Schedule Template applied to with? For all of our providers we have a schedule template applied to them where certain time slots have a predefined appointment type and some time slots do not. How do you find the open slots in this scenario?

Amar

Posted : December 29, 2016 7:18 am

mikeseale

(@mikeseale)

Posts: 344

Reputable Member

The query should still show all of those predefined appt types as empty if there isn't a patient in that slot. You may have to add in some extra filters to remove any blocks on the schedule where the provider is out to lunch or holiday/sick.

Posted : January 3, 2017 7:00 am

Share:

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