Skip to main content
One row per Elation Billing tag definition - the catalog of tags (label, color, type) a practice can apply. Includes both practice-created definitions and the global Elation defaults (for example QUEUED, BILLED), which are replicated into each practice’s data with a null practice_id. Applied tags in the tag table point back here via tag_system_id. This table’s columns and relationships are shown in the Hosted Database schema.
Global Elation default definitions carry a null practice_id; practice-created definitions carry the owning practice. The custom flag distinguishes the two (true = practice-created, false = Elation-provided). type records the entity a tag applies to - known values are claim and patient.
For reporting on but not limited to:
  • The full tag catalog available to a practice
  • Distinguishing custom (practice-created) tags from Elation defaults
  • Listing the global default tags shared across all practices
  • Resolving an applied tag (tag.tag_system_id) to its label and color

​
Tag catalog

Lists the active tag definitions, defaults first. 
select
    ts.id as tag_system_id
  , ts.practice_id
  , ts.type
  , ts.tag as label
  , ts.color
  , ts.custom
  , ts.readonly
from tag_system ts
where ts.is_deleted = false
order by ts.custom, ts.type, ts.tag;

​
Most-applied tags

Joins definitions to the applied tags in the tag table to rank which labels are used most. 
select
    ts.tag as label
  , ts.type
  , ts.custom
  , count(t.id) as times_applied
from tag_system ts
  left join tag t
    on t.tag_system_id = ts.id
   and t.is_deleted = false
where ts.is_deleted = false
group by ts.tag, ts.type, ts.custom
order by times_applied desc;
If you have any questions about this topic please reach out to Elation Support Portal with the subject line HDB - <your_question>