How to Use Cerner Millenium Database using SQL

[Nadeeshan Gimhana]

Hey, I'm new to Cerner solutions and I want to create an application to retrieve all the appointments in Cerner DB. Will this can be done with UCern?  

[Yegor Hanov (Cerner)]

Hi, Nadeeshan!

Please, check out API documentation [1] and feel free to register an application using the self-service Code Portal available in the upper right corner of documentation site.

Be careful getting "all the appointments", there could be millions of those in a production system :-)

[1] https://fhir.cerner.com/millennium/dstu2/scheduling/

-Yegor (Cerner)

[Nadeeshan Gimhana]

Hi Yegor,

While I'm trying the sample app it gives the Error, "Failed to call FHIR Service". Why is that?

Thanks,

Nadeeshan

[Nadeeshan Gimhana]

Hi Yegor,

I've gone through the API documentation [1] and I looks like there is no corresponding method for my requirement. Let me explain what I need in brief.

https://fhir-open.sandboxcerner.com/dstu2/0b8a0111-e8e6-4c26-a91c-5069cbc6b1ca/Appointment?date={date}&patient={patient_ID}

I found above to fetch appointments for a spsecific patient.

But what I want is just fetch all the appointments with in a day without specifing a Patient/Praticioner/Location. How can I do this with Cerner ?

Thanks,

Nadeeshan

[1] https://fhir.cerner.com/millennium/dstu2/scheduling/appointment/#terminology-bindings

[Jenni Syed (Cerner)]

Hi Nadeeshan,

This is not currently possible via our FHIR implementation.

~ Jenni