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

# User Practice

> Look up which practices each Elation Billing user belongs to.

One row per Elation Billing user-practice membership per warehouse - which practices each Elation Billing user belongs to. Use it to tie the Elation Billing users that appear on claims, payments, and financial transactions to the practices they operate in.

This table's columns and relationships are shown in the [Hosted Database schema](/articles/hdb/schema).

<Note>
  `user_practice.elation_billing_user_id` is an Elation Billing-internal user identifier and does not resolve to an HDB `user`. `practice_id` joins to `practice.id`.
</Note>

**For reporting on but not limited to:**

* Which practices a given Elation Billing user can work in
* Users associated with a particular practice
* Excluding soft-deleted memberships via the `is_deleted` flag

## Users in a practice

<CodeGroup>
  ```sql sql theme={null}
  select
      up.practice_id
    , up.elation_billing_user_id
    , up.created_timestamp as member_since
  from user_practice up
  where up.is_deleted = false
    and up.practice_id = <practice_id>
  order by up.elation_billing_user_id;
  ```
</CodeGroup>

## Practices a user belongs to

Joins to `practice` so each membership carries the practice name, not just the id. `elation_billing_user_id` has no name to resolve - it is an Elation Billing-internal identifier that does not map to an HDB `user`.

<CodeGroup>
  ```sql sql theme={null}
  select
      up.elation_billing_user_id
    , up.practice_id
    , pr.name as practice_name
  from user_practice up
    join practice pr on pr.id = up.practice_id
  where up.is_deleted = false
  order by up.elation_billing_user_id, pr.name;
  ```
</CodeGroup>

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