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

# 2026-07-10

This release adds five Elation Billing tables to the Hosted Database, completing the lookup-table set that surrounds Elation Billing claims, and documents the `claim` -> `legal_entity` relationship.

## New Tables

| Table            | Description                                                                                                |
| ---------------- | ---------------------------------------------------------------------------------------------------------- |
| legal\_entity    | The tax-ID-holding billing group a practice bills claims under. Referenced by `claim.legal_entity_id`.     |
| worklist         | Claims flagged onto a biller worklist, with the claim's outstanding balance at the time.                   |
| worklist\_reason | The reason a claim was placed on a biller worklist.                                                        |
| tag\_system      | The Elation Billing tag catalog - tag definitions (label, color, type), including global Elation defaults. |
| tag              | Individual tags applied to claims, patients, and other billing entities.                                   |

## Schema Changes

| Table | Column            | Description                                                                                                                                                                                    |
| ----- | ----------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| claim | `legal_entity_id` | Now documented as a foreign key to the new `legal_entity` table - the billing entity the claim was submitted under. The column already existed; this release adds the documented relationship. |

***

## Release Highlights

**legal\_entity**

The tax-ID-holding billing group a practice bills under - name, tax id, NPI, taxonomy, addresses, and the default-entity flag. Each claim records the entity it was billed under via `claim.legal_entity_id`, now documented as a foreign key so the relationship shows up in the schema/ERD. See the [Legal Entity article](/articles/hdb/legal-entity) for example queries.

**worklist**

Claims flagged onto a biller worklist, with the claim's outstanding balance captured when it was flagged. Joins to the claim via `claim_id` (the Elation Billing claim id, `claim.id` - not the EHR `bill`). See the [Worklist article](/articles/hdb/worklist) for example queries.

**worklist\_reason**

The free-text reason a claim was placed on a worklist, joined to the claim via `claim_id`. A worklisted claim can have one or more reasons. See the [Worklist Reason article](/articles/hdb/worklist-reason) for example queries.

**tag\_system**

The catalog of tags (label, color, type) a practice can apply, including the global Elation defaults (for example `QUEUED`, `BILLED`) replicated per practice with a null `practice_id`. The `custom` flag separates practice-created tags from Elation defaults. See the [Tag System article](/articles/hdb/tag-system) for example queries.

**tag**

Individual applied tags. The tagged object is identified polymorphically by `related_id` + `tag_type`; the label and color come from `tag_system` via `tag_system_id`. For claim-type tags, `related_id` is the Elation Billing claim id and joins to `claim.id`. See the [Tag article](/articles/hdb/tag) for example queries.

<Info>
  These tables are present only for practices on the Elation Billing product. If your practice is not on Elation Billing, they are not created in your Hosted Database.
</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>*