Skip to main content
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

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