# Elation Help Center > Help center documentation for Elation EHR — clinical workflows, billing, scheduling, prescriptions, and practice management. - [Elation EHR (526 pages)](https://help.elationhealth.com/_llms/elation-ehr.md): Documentation for Elation EHR. - [Elation Billing (122 pages)](https://help.elationhealth.com/_llms/elation-billing.md): Documentation for Elation Billing. ## Core Developer ### Core Developer - [Core Developer](https://help.elationhealth.com/core-developer.md): Core Developer is an add-on to your Elation subscription that gives your practice the APIs, Webhooks, and Hosted Database to build custom integrations, automate workflows, and run your own reporting and analytics. - [Core Developer pricing and add-ons](https://help.elationhealth.com/core-developer-pricing.md): What Core Developer costs, how provider seats are counted, why there are no usage-based charges, and the capabilities you can add on request. - [Get started with Core Developer](https://help.elationhealth.com/core-developer-access.md): Request a free Elation sandbox, generate API credentials, make your first API call and Hosted Database query, and understand what it takes to reach production. - [Core Developer FAQ](https://help.elationhealth.com/core-developer-faq.md): Answers to the questions Elation's Technical Solutions and Support teams field most often about Core Developer: pricing, credentials, the sandbox, the APIs, Webhooks, and the Hosted Database. ### What's New - [Subscribe to Elation Release Feeds](https://help.elationhealth.com/articles/subscribe-to-release-feeds.md): Follow Elation API and Hosted Database changes automatically using RSS. - [Changelog](https://help.elationhealth.com/articles/rest/changelog/changelog.md): Notable changes to Elation API 2.0, organized by release date. Covering both changes to individual resources and changes impacting the behavior of the API in general. - [Release Notes](https://help.elationhealth.com/articles/hdb/hdb-snowflake.md) - [API Reference (646 pages)](https://help.elationhealth.com/_llms/api-reference.md): Documentation for API Reference. ## Hosted Database ### Hosted Database - [Hosted Database](https://help.elationhealth.com/hosted-database.md): Query your Elation practice data directly using the hosted database for reporting and analytics. ### Overview - [What is the Hosted Database?](https://help.elationhealth.com/articles/hdb/what-is-the-hosted-database.md) - [Hosted Database Schema](https://help.elationhealth.com/articles/hdb/schema.md) - [Change Management and Schema Versioning](https://help.elationhealth.com/articles/hdb/change-management.md): How Elation classifies, announces, and rolls out changes to the Hosted Database schema and data, and the notice you can expect before each type of change. ### How Tos - [Accessing Your Hosted Database](https://help.elationhealth.com/articles/hdb/accessing-your-hosted-database.md) - [Using worksheets to write queries](https://help.elationhealth.com/articles/hdb/quick-start-guide.md) - [Managing your users](https://help.elationhealth.com/articles/hdb/how-do-i-create-a-new-user-or-role.md) - [Setting Up Multi Factor Authentication](https://help.elationhealth.com/articles/hdb/how-to-set-up-sso.md) - [View When Your Data Was Last Refreshed](https://help.elationhealth.com/articles/hdb/how-to-tell-when-my-data-was-last-refreshed.md) - [Creating a Custom Database](https://help.elationhealth.com/articles/hdb/creating-a-custom-database.md) - [Sharing Worksheets](https://help.elationhealth.com/articles/hdb/sharing-worksheets.md) - [Managing Network Policies](https://help.elationhealth.com/articles/hdb/create-network-policies.md) - [Connecting to Patient Matching SFTP Service](https://help.elationhealth.com/articles/hdb/connecting-to-patient-matching-sftp-service.md) - [Subscribe to Elation Release Feeds](https://help.elationhealth.com/articles/subscribe-to-release-feeds.md): Follow Elation API and Hosted Database changes automatically using RSS. ### Common Queries - [Appointments](https://help.elationhealth.com/articles/hdb/appointments.md) - [Elation Note](https://help.elationhealth.com/articles/hdb/elation-note.md) - [Health Maintenance](https://help.elationhealth.com/articles/hdb/health-maintenance.md): Report on preventive care items completed or recorded for your patients. - [Immunizations](https://help.elationhealth.com/articles/hdb/immunizations.md) - [Lab Orders](https://help.elationhealth.com/articles/hdb/lab-orders.md) - [Lab Results](https://help.elationhealth.com/articles/hdb/lab-results.md) - [Medication Orders](https://help.elationhealth.com/articles/hdb/med-orders.md) - [Medication Orders & Diagnosis Codes Used](https://help.elationhealth.com/articles/hdb/medication-orders-diagnosis-codes-used.md) - [Patient History](https://help.elationhealth.com/articles/hdb/patient-history.md): Report on the history entries recorded in your patients' charts. - [Patients](https://help.elationhealth.com/articles/hdb/patients.md): Common patient queries in the Hosted Database, and the behaviors to know before you count or filter patients. - [Referrals](https://help.elationhealth.com/articles/hdb/referrals.md) - [Visit Notes](https://help.elationhealth.com/articles/hdb/visit-notes.md): How visit notes are modeled in the hosted database: the note record, its content, and how it relates to patients, bills, orders, and documents. - [Visit Notes and Bills](https://help.elationhealth.com/articles/hdb/visit-notes-and-bills.md) ### Elation Billing - [Authorization](https://help.elationhealth.com/articles/hdb/authorization.md): Query prior authorizations issued by payers - look up authorized units, validity dates, and the claims billed against each authorization. - [Bill](https://help.elationhealth.com/articles/hdb/bill.md): Query the EHR-side bill a practice generates from a visit note - its billing status, the providers on it, and the Elation Billing claim it produced. - [Charge](https://help.elationhealth.com/articles/hdb/charge.md): Query Elation Billing charge line items - the per-CPT lines on a claim, with their charges, adjustments, payments, and outstanding balance. - [Charge DX](https://help.elationhealth.com/articles/hdb/charge-dx.md): Report on the diagnosis codes attached to each Elation Billing charge line. - [Claim](https://help.elationhealth.com/articles/hdb/claim.md): Query Elation Billing claims to see what was submitted to payers, the providers and authorizations attached, and the EHR-side bill each claim corresponds to. - [Claim Note](https://help.elationhealth.com/articles/hdb/claim-note.md): Query the notes billers leave on Elation Billing claims, including who wrote each note and when. - [Claim Queue](https://help.elationhealth.com/articles/hdb/claim-queue.md): See which claims were queued for submission to the clearinghouse, when, and by which biller. - [Clearinghouse transactions and messages](https://help.elationhealth.com/articles/hdb/clearinghouse-transaction.md): Clearinghouse submission, response, and message records from Elation Billing - a claim's lifecycle through the clearinghouse and the detail returned at each step. - [Elation Billing User](https://help.elationhealth.com/articles/hdb/elation-billing-user.md): Identify the billers, administrators, and staff who work claims in Elation Billing. - [Elation SSO User](https://help.elationhealth.com/articles/hdb/elation-sso-user.md): Resolve the Elation Billing user on claims, payments, and financial transactions back to the Elation EHR user. - [ERA Matched Adjustment](https://help.elationhealth.com/articles/hdb/era-matched-adjustment.md): Query electronic remittance advice charge-level adjustments to analyze payments, denials, and adjustments for Elation Billing customers. - [Financial Transaction](https://help.elationhealth.com/articles/hdb/financial-transaction.md): Query the most granular billing financial movements in Elation Billing - the payments and adjustments applied to each charge and claim. - [Insurance eligibility check](https://help.elationhealth.com/articles/hdb/insurance-eligibility-check.md): Insurance eligibility verification checks from Elation Billing, with their results. - [Legal Entity](https://help.elationhealth.com/articles/hdb/legal-entity.md): Query the Elation Billing legal entities - the tax-ID-holding billing groups a practice bills claims under. - [Patient Guarantor](https://help.elationhealth.com/articles/hdb/patient-guarantor.md): Look up the responsible party (guarantor) recorded for a patient in Elation Billing. - [Patient insurance eligibility](https://help.elationhealth.com/articles/hdb/patient-insurance-eligibility.md): Insurance eligibility and coverage detail from Elation Billing, keyed to a patient's insurance. - [Patient Statement Tracking](https://help.elationhealth.com/articles/hdb/patient-statement-tracking.md): See how many billing statements a patient has been sent and when the most recent one went out. - [Payer Address](https://help.elationhealth.com/articles/hdb/payer-address.md): Look up the addresses a practice mails paper claims to for each payer. - [Payment](https://help.elationhealth.com/articles/hdb/payment.md): Query insurance and patient payments recorded in Elation Billing - amounts, dates, and how they apply to claims. - [Payment Note](https://help.elationhealth.com/articles/hdb/payment-note.md): Query the notes attached to Elation Billing payments, including who wrote each note and when. - [Tag](https://help.elationhealth.com/articles/hdb/tag.md): Query the Elation Billing tags applied to claims, patients, and other billing entities. - [Tag System](https://help.elationhealth.com/articles/hdb/tag-system.md): Query the Elation Billing tag catalog - the tag definitions (label, color, type) a practice can apply to claims and patients. - [User Practice](https://help.elationhealth.com/articles/hdb/user-practice.md): Look up which practices each Elation Billing user belongs to. - [User Role](https://help.elationhealth.com/articles/hdb/user-role.md): Look up Elation Billing role definitions for users in your practice. - [Worklist](https://help.elationhealth.com/articles/hdb/worklist.md): Query Elation Billing biller worklists to see which claims are flagged for review and their outstanding balance. - [Worklist Reason](https://help.elationhealth.com/articles/hdb/worklist-reason.md): Query the reasons Elation Billing claims were placed on a biller worklist. ### Frequently Asked Questions - [What Data is Available?](https://help.elationhealth.com/articles/hdb/where-can-i-see-what-data-is-available.md) - [What kind of Access/Permissions do I get with my Snowflake Account?](https://help.elationhealth.com/articles/hdb/what-kind-of-accesspermissions-do-i-get.md) - [How to Setup Direct Share](https://help.elationhealth.com/articles/hdb/how-to-setup-direct-share.md) - [What Timezone is my data in?](https://help.elationhealth.com/articles/hdb/what-timezone-is-my-data-in.md) - [How often does my data refresh?](https://help.elationhealth.com/articles/hdb/does-my-data-refresh-in-realtime.md) - [Can I load data into the Hosted Database?](https://help.elationhealth.com/articles/hdb/can-i-load-data-into-the-hosted-database.md) - [Can you grant me write permissions?](https://help.elationhealth.com/articles/hdb/can-you-grant-me-write-permissions.md) ### Early Release - [Early Release](https://help.elationhealth.com/articles/hdb/early-release.md): Learn what the Hosted Database Early Release channel is, how to request access, and which changes are currently available early ahead of their General Availability date. ### Changelog - [Release Notes](https://help.elationhealth.com/articles/hdb/hdb-snowflake.md) ## Patient Passport ### Patient Passport - [Patient Passport](https://help.elationhealth.com/patient-passport.md): Find guides and resources for Patient Passport (also called the patient portal) — helping you access your health information, manage appointments, and communicate with your physician(s). - [Family and Friends Access](https://help.elationhealth.com/articles/patient-passport-family-and-friends-access.md): How to set up and use family and friends access in the Elation Patient Passport, gaining access, first-login verification, and switching between patient charts. - [Patient Portal FAQ: Elation Passport](https://help.elationhealth.com/articles/patient-passport-faq.md): Common questions about Elation Patient Passport (the patient portal), including how to sign up, log in, manage your account, and access your health information. - [Using Elation Passport, Your Patient Portal](https://help.elationhealth.com/articles/what-patient-passport-messaging-looks-like-to-a-patient.md): A complete guide to using Elation Patient Passport (the patient portal) — registering, logging in, messaging your practice, viewing appointments, and managing your health information. - [What's New in Patient Passport](https://help.elationhealth.com/articles/patient-passport-whats-new.md): A guide to everything that's new, changed, and the same in the updated Elation Patient Passport. ## OpenAPI Specs - [elation-api-full](/files/elation-api-full.yaml) - [api-authentication](/openapi/api-authentication.json) - [billing-api](/openapi/billing-api.yaml) - [care-gaps-api](/openapi/care-gaps-api.json) - [engenable-playground](/openapi/engenable-playground.json) - [event-subscription-api](/openapi/event-subscription-api.yaml) - [insurance-api](/openapi/insurance-api.json) - [insurance-api](/openapi/insurance-api.yaml) - [messaging-api](/openapi/messaging-api.yaml) - [orders-api](/openapi/orders-api.yaml) - [patient-document-api](/openapi/patient-document-api.yaml) - [patient-profile-api](/openapi/patient-profile-api.yaml) - [practice-api](/openapi/practice-api.yaml) - [premium-patient-insurance-api](/openapi/premium-patient-insurance-api.yaml) - [reference-data-api](/openapi/reference-data-api.yaml) - [scheduling-api](/openapi/scheduling-api.yaml) - [user-management-api](/openapi/user-management-api.yaml) - [visit-notes-api](/openapi/visit-notes-api.json) > The links below point to documentation indexes. Follow each `/_llms/` index recursively until you reach documentation pages. ## Indexes - [Elation EHR (526 pages)](https://help.elationhealth.com/_llms/elation-ehr.md): Documentation for Elation EHR. - [Elation EHR / Clinical Workflows (199 pages)](https://help.elationhealth.com/_llms/elation-ehr/clinical-workflows.md): Documentation for Elation EHR / Clinical Workflows. - [Elation Billing (122 pages)](https://help.elationhealth.com/_llms/elation-billing.md): Documentation for Elation Billing. - [API Reference (646 pages)](https://help.elationhealth.com/_llms/api-reference.md): Documentation for API Reference. - [API Reference / REST API (554 pages)](https://help.elationhealth.com/_llms/api-reference/rest-api.md): Documentation for API Reference / REST API.