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

# Version 1.9.5: June 2026

<Info>
  Starting with the next release, HDB updates will be identified by **release date only** — no more version numbers. This makes it easier to see at a glance when a change shipped. Release notes will continue to live in this section, dated in `YYYY-MM-DD` form.
</Info>

This release deletes visit-note records consistently across `bill`, `bill_item`, and `bill_item_dx`, exposes a unified `is_deleted` flag on each of those tables, and retires a handful of columns that are no longer populated.

## Schema Changes

| Table          | Change                                                                                                                                    |
| -------------- | ----------------------------------------------------------------------------------------------------------------------------------------- |
| bill           | added `is_deleted` column                                                                                                                 |
| bill\_item     | added `is_deleted` column                                                                                                                 |
| bill\_item     | **deprecated** — `deletion_time` and `deleted_by_user_id` are now always `NULL` and will be removed in a future release                   |
| bill\_item\_dx | added `is_deleted` column                                                                                                                 |
| bill\_item\_dx | **deprecated** — `icd9_code`, `bill_item_deletion_time`, and `deletelog_id` are now always `NULL` and will be removed in a future release |

***

## Release Highlights

**Visit-note deletions now propagate to bills**

When a visit note is deleted, the bill (`bill`), its line items (`bill_item`), and the diagnosis codes on those line items (`bill_item_dx`) are now flagged as deleted along with it. Previously each table tracked deletion independently, so a deleted visit note could still appear to have live bills and CPT/DX rows.

**`is_deleted` on bill, bill\_item, and bill\_item\_dx**

A new boolean `is_deleted` column is now available on all three tables. Filter on `is_deleted = false` to scope queries to live records:

```sql theme={null}
select *
from bill
where is_deleted = false
```

For `bill_item`, the flag is `true` when the line item itself was deleted **or** when the parent bill is deleted. For `bill_item_dx`, the flag is `true` when the diagnosis row was deleted **or** when the parent bill item is deleted.

**Deprecated columns on `bill_item`**

The following columns are deprecated and now always return `NULL`. They remain in the schema for backwards compatibility and will be removed in a future release — migrate any queries that depend on them.

* `bill_item.deletion_time` — superseded by `bill_item.is_deleted`.
* `bill_item.deleted_by_user_id` — superseded by `bill_item.is_deleted`.

**Deprecated columns on `bill_item_dx`**

The following columns are deprecated and now always return `NULL`. They remain in the schema for backwards compatibility and will be removed in a future release — migrate any queries that depend on them.

* `bill_item_dx.icd9_code` — ICD-9 codes have not been used by Elation in production billing for many years; only `icd10_code` is populated going forward.
* `bill_item_dx.bill_item_deletion_time` — superseded by `bill_item_dx.is_deleted`.
* `bill_item_dx.deletelog_id` — superseded by `bill_item_dx.is_deleted`.

<Info>
  If you have existing queries that filter on `bill_item.deleted_by_user_id is null`, `bill_item_dx.deletelog_id is null`, or `bill_item_dx.bill_item_deletion_time is null` to exclude deleted records, update them to use `is_deleted = false`. See the [Visit Notes and Bills article](/articles/hdb/visit-notes-and-bills) for an updated example query.
</Info>

*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>*