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

# Health Maintenance

> Report on preventive care items completed or recorded for your patients.

One row per health maintenance item completion per patient. Health maintenance items track preventive care measures - cancer screenings, vaccinations, advance care planning, and similar recurring clinical tasks. Each row records when an item was completed, the clinician who completed it, and any note they entered at the time.

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

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

* Preventive care measure completion rates by patient, measure, or provider
* Clinician notes entered when completing a health maintenance item
* Quality measure reporting using `measure_code` (e.g., CMS124 for Cervical Cancer Screening)
* Abnormal or normal result flags per measure
* Associated lab reports (`lab_report_id`) and document tags (`doc_tag_id`)

<CodeGroup>
  ```sql Recent completions with patient and note theme={null}
  select
      hm.id as "HEALTH_MAINTENANCE_ID"
    , hm.patient_id
    , pt.first_name as "PATIENT_FIRST_NAME"
    , pt.last_name as "PATIENT_LAST_NAME"
    , pt.dob as "PATIENT_DOB"
    , hm.name as "MEASURE_NAME"
    , hm.measure_code
    , hm.date as "COMPLETION_DATE"
    , hm.note
    , hm.normal_result
    , hm.abnormal_result
    , concat(hm.firstname, ' ', hm.lastname) as "PHYSICIAN_NAME"
    , hm.confidential
    , hm.created_date
  from health_maintenance hm
    left join patient pt on pt.id = hm.patient_id
  where hm.deleted_date is null
  order by hm.date desc;
  ```

  ```sql Quality measure compliance by measure theme={null}
  select
      hm.measure_code
    , hm.name as "MEASURE_NAME"
    , count(distinct hm.patient_id) as "PATIENTS_WITH_COMPLETION"
    , min(hm.date) as "EARLIEST_COMPLETION"
    , max(hm.date) as "MOST_RECENT_COMPLETION"
  from health_maintenance hm
  where hm.deleted_date is null
    and hm.measure_code is not null
  group by hm.measure_code, hm.name
  order by hm.name;
  ```
</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>*