Health Maintenance

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

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;

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;

If you have any questions about this topic please reach out to Elation Support Portal with the subject line HDB - <your_question>

Hosted Database

Overview

How Tos

Common Queries

Elation Billing

Frequently Asked Questions

Changelog