> ## 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.

# Patient insurance eligibility

> Insurance eligibility and coverage detail from Elation Billing, keyed to a patient's insurance.

One row per patient insurance per warehouse. This table adds the eligibility and coverage fields Elation Billing tracks - eligibility status and check date, Medicare code, and the coverage window - that the `patient_insurance` policy record does not carry. Join back to `patient_insurance` via `patient_insurance_id` for the policy itself (member id, group, rank, subscriber demographics).

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

<Note>
  `patient_insurance_id` is null for the small share of Elation Billing insurance records that do not crosswalk to an EHR `patient_insurance` row; use `patient_id` as a fallback to attribute those records to a patient.
</Note>

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

* Current insurance eligibility status and when it was last verified
* Coverage start and end dates for a patient's insurance
* Which insurance record is the current one on file (versus superseded or deleted)
* Medicare Secondary Payer value codes

## Current insurance eligibility and coverage for a patient

<CodeGroup>
  ```sql sql theme={null}
  select
      pie.patient_id
    , p.full_name
    , pi.carrier
    , pie.coverage_start
    , pie.coverage_end
    , pie.eligibility_status
    , pie.eligibility_date
  from patient_insurance_eligibility pie
    left join patient p on p.id = pie.patient_id
    left join patient_insurance pi on pi.id = pie.patient_insurance_id
  where pie.is_active          -- the current, non-superseded record (not "coverage in effect")
    and not pie.is_deleted;
  ```
</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>*