Tag System

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>

⌘I

Hosted Database

Overview

How Tos

Common Queries

Elation Billing

Frequently Asked Questions

Early Release

Changelog

Tag catalog

Most-applied tags

​Tag catalog

​Most-applied tags

Tag catalog

Most-applied tags