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

> Look up Elation Billing role definitions for users in your practice.

Lookup table mapping Elation Billing role identifiers to their human-readable names (for example Admin, Biller, Staff). Use it to translate role IDs that appear on user records into the labels shown in the Elation Billing application.

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

* Resolving role IDs on user records to readable labels
* Listing every role available in Elation Billing
* Filtering out soft-deleted roles via the `is_deleted` flag

## All active roles

<CodeGroup>
  ```sql sql theme={null}
  select
      ur.id as role_id
    , ur.role as role_name
    , ur.is_deleted
    , ur.hdb_last_sync
  from user_role ur
  where ur.is_deleted = false
  order by ur.id;
  ```
</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>*