Oracle Health
Description
Oracle Health (Cerner) Millennium is an electronic health record (EHR) platform that hospitals and health systems use to run clinical care and operations.
Setup guide
Ask your Oracle Health administrator to provision the Improvado app for your Millennium domain. In Oracle's FHIR application provisioning process, the administrator logs a service request to Cerner Ignite APIs for Millennium to provision the app's application ID and client ID against your tenant ID. The Improvado app is named Improvado, with application ID 186fd0fb-be5e-4833-8774-808075373952 and client ID 61f790a1-99ae-4613-a8af-ab6c8601a157. The app has read-only access to appointments, encounters, locations and practitioners, and it reads them without a user sign-in.
Get your FHIR R4 base URL, such as https://fhir-ehr.cerner.com/r4/<tenant ID>, or https://fhir-ehr.sandboxcerner.com/r4/<tenant ID> for a test domain. Your administrator can request it with the provisioning, and Oracle lists published base URLs in its endpoint list.
In the authorization form, paste the base URL into the FHIR R4 Base URL field and click Connect. A connection reads one tenant: connect each tenant with its own base URL.
When the connection status is Active, each unit-level location of the hospital, such as a clinic, department or nursing unit, is an account. To extract data, follow the instructions on how to set up data extraction. Appointments and Encounters read the locations you select; Locations and Practitioners cover the whole hospital.
Schema information
The schema information shows all report types you can use to extract data from Oracle Health.
Limits
Patient data. Appointments and Encounters identify the patient only by the Oracle Health FHIR ID in Patient ID, which is not selected by default. Patient names, narratives and free-text notes are not extracted.
Dates and times. Times are in UTC. Both report types select rows by the start time of the appointment in UTC, so an evening appointment at a US hospital can fall on the next day. Scheduled extractions read up to the current day, so a future booking arrives once its day comes.
Later changes. By default, scheduled extractions reread the last 7 days. A change Oracle Health records more than 7 days after the appointment day, such as the discharge after a long stay, reaches your data when an extraction covers that day again.
What is not included. Proposed appointment requests, which have no start time yet, and visits without an appointment at the selected location, such as walk-ins.
Active records only. Oracle Health lists only active locations and practitioners. A location or practitioner deactivated after a load keeps its last loaded row, and a practitioner who was already inactive at the first load is not included. An inactive location is included while an active location sits under it.
Shared domains. Oracle's self-service provisioning does not cover hospitals on a shared CommunityWorks, PowerWorks or Continuum domain. Their administrator can explore other options with their Oracle representative.
Release notes
Oracle Health announces API changes, such as end-of-support notices and authorization server moves, in the Announcements category of its developer forums.
Troubleshooting
Having trouble with your setup? Find solutions to common issues →
Was this article helpful?
Thanks for the feedback!
Questions? The Improvado team is always happy to help. Send us an email, contact your Customer Success Manager, or raise a request in the Improvado Service Desk.