Skip to main content
CORE DEVELOPER · OVERVIEW REST API 2.0 FHIR API WEBHOOKS HOSTED DATABASE SANDBOX ELATION ANALYST Core Developer is for practices that want to build on Elation, not just work inside it. You get read and write API access to your practice data, a SQL copy of that data for reporting, and a free sandbox to build in first. Getting answers out of your data does not require SQL. The Hosted Database ships with Elation Analyst, which takes a question in plain language and returns a report — so a practice manager, biller, or clinician can work with the same data an analyst would. SQL is there for questions that go past Analyst’s topics, or when you want exact control. Building an integration requires someone comfortable writing code against an API. That can be your own engineers, a consulting partner, or an AI coding assistant. Elation provides full documentation and a dedicated MCP server so whoever builds it has what they need.
01 — WHAT IT IS

What’s included

Core Developer is a paid add-on to a Standard or Premium Elation EHR subscription.
02 — WHAT YOU CAN BUILD

Integrations and automation

Questions you can answer with the Hosted Database

Use Elation Analyst to ask questions in plain language and get a report back, or write SQL directly for deeper analysis like ERA adjustments, denials, and cross-domain joins.

Query your data with SQL

Every table below is in the Hosted Database schema.

Chronic disease prevalence

Size and segment your chronic care population. Join patient and patient_problem_code.

Preventive care gaps

Find who is overdue for a screening or vaccine. Combine health_maintenance, patient_immunization, and patient_problem_code, and report quality measures using the measure_code column on health_maintenance.

Referral leakage

Find where patients go and where the loop never closes. Analyze referral_order.

Schedule utilization

Quantify no-shows, gaps, and provider utilization from appointment.

Denials and revenue cycle

Track denial reasons, rework, and days in A/R using claim, claim_queue, and era_matched_adjustment.

Patient balances and statements

See who owes what, and who has never been sent a statement, using patient_statement_tracking, payment, and financial_transaction.
Query results grid showing "select * from appointment;" executed, displaying columns UQ_APPOINTMENT, ID, PATIENT_ID, PRACTICE_ID, APPT_TIME, and PHYSICIAN_USER_ID with 655K rows returned.

Open a SQL Worksheet in Snowflake, select your database and schema, and run a query against any table. Autocomplete surfaces table and column names as you type.

Ask Elation Analyst in plain language

Elation Analyst (Beta) is an AI assistant built into your Hosted Database. Ask a concrete question — “Who has missed their appointments this year?” or “Show me patients with an A1c above 9” — and get back SQL and a results table you can download as CSV.
Elation Analyst chat showing the query "Top 10 appointment type last month" with an AI interpretation for July 2025, an expandable SQL Query section, and a results table led by Follow-Up at 3,634 appointments and None at 2,077.

Elation Analyst turns a plain-language question into SQL you can inspect, and returns the results alongside it.

See Elation Analyst for supported topics, sample questions, and how to save results as a dashboard.
03 — WHAT IT COSTS

Priced per provider

Added to your existing Elation subscription.

One-time implementation fee

Covers initial setup, configuration, and technical onboarding.
The fee applies to every provider with an active EHR seat. Staff accounts are exempt, and there is no product-level provider minimum. You are not billed on API usage. No per-call charges, no per-record charges, and no overage invoices. Provider count is the whole variable, and you already know that number, so you can forecast the cost. Full detail on Pricing and add-ons.
04 — NEXT STEPS

Get a free sandbox

No subscription required. Start building before you buy.

Pricing and add-ons

Seat rules, contract terms, and what else you can add.

Go to production

What has to be true before production credentials are issued.
For pricing, access, or contract questions, raise a request at app.elationemr.com/support or contact your Customer Success Manager.