User Practice

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.

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.

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

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;

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.

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;

If you have any questions about this topic please reach out to Elation Support Portal with the subject line HDB - <your_question>

⌘I

Hosted Database

Overview

How Tos

Common Queries

Elation Billing

Frequently Asked Questions

Early Release

Changelog

Users in a practice

Practices a user belongs to

​Users in a practice

​Practices a user belongs to

Users in a practice

Practices a user belongs to