> ## 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: December 2025

## Product Enhancements

| Table                        | Updates                                 |
| ---------------------------- | --------------------------------------- |
| office\_messages             | added report\_id column                 |
| office\_messages\_recipients | added removed\_from\_thread column      |
| office\_messages\_recipients | added removed\_at column                |
| appointment                  | added is\_blocking column               |
| med\_order                   | added supervising\_physician\_id column |
| med\_order                   | added fulfillment\_state column         |
| med\_order                   | added num\_samples column               |
| med\_order                   | added patient\_adherence column         |
| provider\_letter             | added viewed\_at column                 |
| referral\_order              | removed clinical\_reason column         |

## Bug Fixes

| Table            | Description                                                                                         |
| ---------------- | --------------------------------------------------------------------------------------------------- |
| patient\_problem | fixed duplicate row issue caused by incorrect fields in unique key: **all unique keys will change** |
| patient\_phone   | fixed bug where deleted phone numbers (empty strings) were hidden instead of shown                  |

## New Tables (Beta)

The following tables are in **beta** and may be altered without prior notification. The older `vn2_*` visit note tables will be removed in a future release.

| Table                                  | Description                                                              |
| -------------------------------------- | ------------------------------------------------------------------------ |
| elation\_note                          | Cleaned, structured data to reconstruct custom note blocks by note       |
| elation\_note\_structured\_data        | Granular form data linking to questions and blocks                       |
| elation\_note\_response\_option        | Response options for checkbox, dropdown, and radio button question types |
| elation\_note\_question                | Current state of each question in a custom block                         |
| elation\_note\_custom\_block\_snapshot | Snapshot of the custom block at the time the note was created (static)   |
| elation\_note\_custom\_block           | Current active state of a custom block (may drift from note content)     |

***

## Release Highlights

**office\_messages: report\_id**

If a report is attached to an office message, `report_id` now links to the `report` table.

**office\_messages\_recipients: thread removal tracking**

`removed_from_thread` (boolean) and `removed_at` (timestamp) were added to track when recipients are removed from a message thread.

**appointment: is\_blocking**

The `is_blocking` flag indicates whether an appointment blocks the provider's schedule. Defaults to `true`.

**med\_order: prescription lifecycle and sample tracking**

* `supervising_physician_id`: the supervising physician for the order
* `fulfillment_state`: current state of the prescription: `new`, `failure`, `error`, `sent`, `complete`, `pending_complete`, `denied`, `sending`
* `num_samples`: populated when the medication is a sample
* `patient_adherence`: patient adherence data for the medication

**provider\_letter: viewed\_at**

Records the timestamp when a provider letter was initially viewed.

**referral\_order: clinical\_reason removed**

The `clinical_reason` column has been removed. Use the `body` column instead, which is pulled from the body of the referral.

**patient\_problem: unique key change**

A bug caused duplicate rows due to incorrect fields being included in the unique key. All unique keys for this table will change as a result of this fix. Customers doing incremental builds will need to account for this.

**patient\_phone: empty string deletions now visible**

When a phone number was manually removed from a chart, it was previously filtered out. It will now appear as an empty phone number (not as deleted).

**New Elation Note tables (beta)**

Six new tables expose structured data from Elation's custom note blocks. See the [entity relationship diagram](https://dbdocs.io/hosteddb_support/hosted_database_snowflake) for details on how these tables relate.

<img src="https://mintcdn.com/elationhealth/aqLVKRo1Jpffmnwl/images/reference/hdb-elation-note-table-relationships.png?fit=max&auto=format&n=aqLVKRo1Jpffmnwl&q=85&s=518e253cf52e6737d42904ab5d58f0ba" alt="" width="2553" height="1566" data-path="images/reference/hdb-elation-note-table-relationships.png" />

<Warning>
  These tables are beta. Schema may change without notice. The `vn2_*` tables will be removed in a future release.
</Warning>