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

This release adds a granular `billing_status_detail` column and provider reference columns to the `bill` table, exposing the provider roles recorded in the visit note billing section.

<Note>
  **Early release.** These columns are available now to early-release Hosted Database clients and become generally available on the standard `bill` table on **2026-07-13**.
</Note>

## Schema Changes

| Table | Column                                                                                             | Description                                        |
| ----- | -------------------------------------------------------------------------------------------------- | -------------------------------------------------- |
| bill  | `billing_status_detail`                                                                            | Detailed billing status for each bill              |
| bill  | `rendering_provider_id`, `supervising_provider_id`, `billing_provider_id`, `referring_provider_id` | Provider roles from the visit note billing section |

***

## Release Highlights

**Billing Status Detail**

The existing `billing_status` column collapses eight underlying bill statuses into four categories (`Unbilled`, `Billed`, `UnresolvedError`, `ResolvedError`). The new `billing_status_detail` column exposes the full status shown in Billing Home, so you no longer have to reconstruct it. `billing_status` is unchanged. Values:

| Status            | Meaning                             |
| ----------------- | ----------------------------------- |
| Awaiting sign-off | Unbilled, visit note not yet signed |
| Signed            | Unbilled, visit note signed         |
| Received by PMS   | Billed                              |
| Sent to PMS       | Transmitted to a PMS                |
| Marked as billed  | Billed manually                     |
| Failed to send    | Errored (unresolved or resolved)    |

**Provider reference columns on `bill`**

The `bill` table now carries the provider roles from the visit note billing section. Previously only `visit_note.physician_user_id` was available, which does not always match the rendering provider shown on the bill.

Three of the columns identify Elation user accounts. Resolve them to provider name, NPI, and credentials by joining the `user` table on `user.physician_id`:

* `rendering_provider_id` — the provider who rendered the services on the bill.
* `supervising_provider_id` — the supervising provider.
* `billing_provider_id` — the billing provider (for example, incident-to billing).

```sql theme={null}
select
    b.id as bill_id
  , ru.first_name as rendering_first_name
  , ru.last_name  as rendering_last_name
from bill b
left join user ru on ru.physician_id = b.rendering_provider_id
```

The remaining column is a record ID into the bill's referring-provider record, not a user account:

* `referring_provider_id` — the referring-provider record; its name and state are already surfaced on `bill` as `referring_provider` and `referring_provider_state`.

<Info>
  Join the three user-backed `*_provider_id` columns to `user` on `user.physician_id`, not `user.id`.
</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>*