Elation SSO User - Elation Help Center

One row per Elation EHR user / Elation Billing user / warehouse, linking each Elation Billing user to their Elation EHR user account. Use it to resolve the Elation Billing user that appears on claims, payments, and financial transactions back to the Elation EHR user. This table’s columns and relationships are shown in the Hosted Database schema.

elation_sso_user.user_id is the Elation EHR user.id and is null when the Elation EHR user has no matching user in the warehouse. elation_billing_user_id is an Elation Billing identifier and does not resolve to an Elation EHR user on its own.

For reporting on but not limited to:

Mapping Elation Billing users to their Elation EHR user accounts
Finding the EHR user behind an Elation Billing user on a payment or financial transaction
Most recent Elation Billing login per user

Resolve an Elation Billing user to the EHR user

select
    s.elation_billing_user_id
  , s.user_id
  , u.first_name
  , u.last_name
  , s.last_login
from elation_sso_user s
  left join user u on u.id = s.user_id
where s.is_deleted = false;

Payments attributed to the EHR user who created them

select
    p.id as payment_id
  , p.amount
  , s.user_id as created_by_user_id
  , u.first_name
  , u.last_name
from payment p
  left join elation_sso_user s
    on s.elation_billing_user_id = p.created_by_elation_billing_user_id
   and s.warehouse_id = p.warehouse_id
  left join user u on u.id = s.user_id
where p.is_deleted = false;

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

⌘I