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

# Release Notes

The current entity relationship diagram is at [dbdocs.io/hosteddb\_support/hosted\_database\_snowflake](https://dbdocs.io/hosteddb_support/hosted_database_snowflake).

## GA Releases

<Update label="2026-07-28" tags={["GA"]}>
  `patient_problem_code`: use the single `is_deleted` boolean to filter deleted rows. `deletion_time` and `deleted_by_user_id` are deprecated — they remain on the table but are now always `null` and will be fully removed at a future date. Also fixes duplicate-code and deleted-problem inconsistencies so deletion state matches the Elation application.

  [Full release notes](/articles/hdb/2026-07-28)
</Update>

<Update label="2026-07-27" tags={["GA"]}>
  Three Elation Billing tables: `insurance_eligibility_check`, `patient_insurance_eligibility`, `clearinghouse_transaction`. Also renames `patient_guarantor.guarantor` to the boolean `is_guarantor`.

  [Full release notes](/articles/hdb/2026-07-27)
</Update>

<Update label="2026-07-22" tags={["GA"]}>
  Six Elation Billing tables: `patient_guarantor`, `patient_statement_tracking`, `user_practice`, `elation_sso_user`, `payment`, `financial_transaction`.

  [Full release notes](/articles/hdb/2026-07-22)
</Update>

<Update label="2026-07-13" tags={["GA"]}>
  Detailed billing status on each bill, plus the rendering, supervising, billing, and referring providers.

  [Full release notes](/articles/hdb/2026-07-13)
</Update>

<Update label="2026-07-10" tags={["GA"]}>
  Five Elation Billing lookup tables (`legal_entity`, `worklist`, `worklist_reason`, `tag_system`, `tag`); `claim.legal_entity_id` documented as a foreign key.

  [Full release notes](/articles/hdb/2026-07-10)
</Update>

<Update label="Version 1.9.5" tags={["GA"]}>
  Consistent visit-note deletion across `bill`, `bill_item`, `bill_item_dx`; unified `is_deleted` flag.

  [Full release notes](/articles/hdb/2026-06-30-ver-195)
</Update>

<Update label="Version 1.9.4" tags={["GA"]}>
  New `elation_billing` schema: `era_matched_adjustment`, `user_role`, `claim`, `authorization`.

  [Full release notes](/articles/hdb/2026-06-29-ver-194)
</Update>

<Update label="Version 1.9.2" tags={["GA"]}>
  `recurring_event_group` and `recurring_event_schedule` promoted to GA.

  [Full release notes](/articles/hdb/2026-06-17-ver-192)
</Update>

<Update label="Version 1.9" tags={["GA"]}>
  `office_messages` `report_id`; `med_order` prescription lifecycle; Elation Note beta tables.

  [Full release notes](/articles/hdb/2025-12-16-ver-19)
</Update>

<Update label="Version 1.8" tags={["GA"]}>
  `physician_license` expansion; ethnicity fields overhaul; `loinc_code` replaces `loinc_id`.

  [Full release notes](/articles/hdb/2025-01-15-ver-18)
</Update>

<Update label="Version 1.7" tags={["GA"]}>
  Timestamp standardization to `TIMESTAMPNTZ(9)`; Event Streaming migration.

  [Full release notes](/articles/hdb/2024-07-29-ver-17)
</Update>

<Update label="Version 1.6" tags={["GA"]}>
  `medication_rxnorm.is_deleted`; `appointment` `in_person_or_virtual` and `instructions`.

  [Full release notes](/articles/hdb/2024-02-13-ver-16)
</Update>

<Update label="Version 1.5" tags={["GA"]}>
  `med_order.days_supply`; `patient` `full_name`, `consented`, `gender_identity` update.

  [Full release notes](/articles/hdb/2023-11-06-ver-15)
</Update>

<Update label="Version 1.4" tags={["GA"]}>
  New `physician_license` and `provider_availability` tables; `visit_note` time columns.

  [Full release notes](/articles/hdb/2023-10-05-ver-14)
</Update>

<Update label="Version 1.3" tags={["GA"]}>
  `patient` `primary_care_provider_id`, `primary_care_provider_npi`, `pronouns`.

  [Full release notes](/articles/hdb/2023-09-06-ver-13)
</Update>

<Update label="Version 1.2" tags={["GA"]}>
  `patient.deceased_date`; `visit_note_bullet.is_deleted`; `user.direct_message_address`.

  [Full release notes](/articles/hdb/2023-08-01-ver-12)
</Update>

<Update label="Hot Fix" tags={["GA"]}>
  `patient_employer.is_deleted`.

  [Full release notes](/articles/hdb/2023-06-07-hotfix)
</Update>

<Update label="Version 1.1.1" tags={["GA"]}>
  `referral_order` lifecycle columns; `misc_orders.is_deleted` and `resolution_state`.

  [Full release notes](/articles/hdb/2023-05-12-ver-111)
</Update>

<Update label="Version 1.1" tags={["GA"]}>
  Audit columns for `patient_tag` and `document_tag`; `patient.patient_status`.

  [Full release notes](/articles/hdb/2023-04-14-ver-11)
</Update>

<Update label="Version 1.0.1" tags={["GA"]}>
  `appointment.service_location_id`; `service_location.name`.

  [Full release notes](/articles/hdb/2023-04-07-ver-101)
</Update>

## Beta Releases

<Update label="Version 1.4beta / 1.0" tags={["Beta"]}>
  `bill_item_dx` schema overhaul; `visit_note_bullet.replaced_by_visit_note_bullet_id`.
</Update>

<Update label="Version 1.3beta" tags={["Beta"]}>
  `clinical_form_collection.is_deleted`; `visit_note_bullet` audit columns.
</Update>

<Update label="Version 1.2beta" tags={["Beta"]}>
  `is_deleted` added to 10 tables; unique key rebuild required.
</Update>

<Update label="Version 1.1beta" tags={["Beta"]}>
  `uq_{tablename}` and `hdb_last_sync` added to all tables.
</Update>

<Update label="Version 1.0beta" tags={["Beta"]}>
  Views replaced by tables (`report`, `report_addendum`, `report_document_tag`).
</Update>