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

This release adds six Elation Billing tables to the Hosted Database: two patient-level billing tables, the user-practice bridge, the SSO crosswalk that resolves Elation Billing users to their Elation EHR user accounts, and the payment and financial-transaction tables that record billing money movements.

## New Tables

| Table                        | Description                                                                                                                     |
| ---------------------------- | ------------------------------------------------------------------------------------------------------------------------------- |
| patient\_guarantor           | Responsible-party (guarantor) demographics for a patient's Elation Billing account. Joins to `patient` via `patient_id`.        |
| patient\_statement\_tracking | Billing statement state per patient - statements sent, last statement date, and send flag. Joins to `patient` via `patient_id`. |
| user\_practice               | Bridge associating Elation Billing users with the practices they belong to.                                                     |
| elation\_sso\_user           | Crosswalk from Elation Billing users to Elation EHR (`user`) accounts, via Elation Billing SSO.                                 |
| payment                      | Insurance and patient payments recorded in Elation Billing - amounts, dates, and how they apply to claims.                      |
| financial\_transaction       | The most granular billing financial movements - payments and adjustments applied to charges and claims.                         |

***

## Release Highlights

**patient\_guarantor**

The responsible party financially accountable for a patient's Elation Billing account - name, date of birth, address, phone, and email. Often the patient, sometimes a parent, spouse, or other party. HDB `patient` stays the source of truth for the patient's own demographics; this table adds only the responsible-party fields, which have no EHR equivalent. The responsible party's SSN is not exposed. See the [Patient Guarantor article](/articles/hdb/patient-guarantor) for example queries.

**patient\_statement\_tracking**

Billing statement state for each patient - how many statements have been sent, when the most recent went out, and whether statements should be sent at all. Joins to `patient` via `patient_id`. See the [Patient Statement Tracking article](/articles/hdb/patient-statement-tracking) for example queries.

**user\_practice**

Which practices each Elation Billing user belongs to, one row per membership. Ties the Elation Billing users that appear on claims, payments, and financial transactions to the practices they operate in. See the [User Practice article](/articles/hdb/user-practice) for example queries.

**elation\_sso\_user**

Resolves an Elation Billing user to their Elation EHR user account via Elation Billing single sign-on. `user_id` is the resolved HDB `user.id` (null when the EHR user has no HDB match). Use it to attribute claims, payments, and financial transactions to an Elation EHR user. See the [Elation SSO User article](/articles/hdb/elation-sso-user) for example queries.

**payment**

Insurance and patient payments recorded in Elation Billing, one row per payment - amount, dates, type and method, and how much has been applied to charges. Insurance payments have no EHR equivalent, so `patient_id` and `claim_id` are often empty. See the [Payment article](/articles/hdb/payment) for example queries.

**financial\_transaction**

The most granular record of billing financial movements - one row per payment or adjustment applied to a charge or claim, with its type, amount, and running balance. Links to the charge, claim, payment, patient, and patient insurance involved, where known. See the [Financial Transaction article](/articles/hdb/financial-transaction) 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>*