> ## Documentation Index
> Fetch the complete documentation index at: https://help.elationhealth.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Insurance eligibility check

> Insurance eligibility verification checks from Elation Billing - one row per check, with its result.

One row per insurance eligibility check per warehouse. Each row is a verification request sent to a payer (via the ClaimMD clearinghouse) to confirm a patient's insurance coverage, along with its result. This data is specific to Elation Billing; there is no EHR-side equivalent. Join to `patient` and `patient_insurance` for the patient and the policy that were checked.

This table's columns and relationships are shown in the [Hosted Database schema](/articles/hdb/schema).

<Note>
  `is_eligible` is the payer's determination for the check (true = active/eligible coverage, false = inactive) - it is the source of the eligibility status carried on `patient_insurance`. `is_internal` marks checks initiated by an internal Elation pathway (EHR insurance sync or agentic billing) rather than by a billing user.
</Note>

**For reporting on but not limited to:**

* Whether a patient's coverage came back eligible, and when it was last checked
* Eligibility check volume and outcomes over time
* How checks were run (electronic, manual, or error)
* Which checks were internal/automated versus user-initiated

## Recent eligibility results for a patient

<CodeGroup>
  ```sql sql theme={null}
  select
      e.date_of_service
    , p.full_name
    , pi.carrier
    , e.is_eligible
    , e.type
  from insurance_eligibility_check e
    left join patient p on p.id = e.patient_id
    left join patient_insurance pi on pi.id = e.patient_insurance_id
  where e.date_of_service >= dateadd(month, -3, current_date())
    and not e.is_deleted
  order by e.date_of_service desc;
  ```
</CodeGroup>

*If you have any questions about this topic please reach out to [Elation Support Portal](/articles/support-portal-introduction) with the subject line HDB - \<your\_question>*