mdatool
Healthcare Data Dictionary for the Modern Data Stack
LibraryBlogPricing
mdatool
mdatool

The healthcare data dictionary for dbt, Snowflake, Databricks, and BigQuery. 100,000+ ISO-11179 standard terms, free SQL tools, and AI data modeling.

HIPAA-AlignedEnterprise Ready

Tools

  • SQL Linter
  • DDL Converter
  • Bulk Sanitizer
  • Naming Auditor
  • Name Generator
  • AI Data Modeling
  • HCC Calculator
  • Data Model Canvas

Library

  • Glossary
  • Guides
  • Blog

Company

  • About
  • Contact
  • Pricing

Account

  • Sign Up Free
  • Sign In
  • Upgrade to Pro
  • Dashboard

Legal

  • Privacy Policy
  • Terms of Service

© 2026 mdatool. All rights reserved.

Built for healthcare data teams.

Back to Glossary

Domain

Clinical

EHR, ICD-10, LOINC, SNOMED CT, patient care and clinical documentation

16,101 clinical terms

triage maximumtriage_max

The upper boundary value for a clinical measurement or scoring parameter captured during the emergency department triage assessment, such as a maximum acceptable vital sign threshold or acuity score ceiling. Used in clinical decision rules and quality reporting to flag patients exceeding defined limits.

triage middle nametriage_mid_nm

The patient's middle name or initial recorded during emergency department triage registration. Used to disambiguate patients with identical first and last names, support accurate matching against the enterprise master patient index, and ensure complete demographic documentation at ED intake.

triage minimumtriage_min

The lower boundary value for a clinical measurement or scoring parameter captured during the emergency department triage assessment, such as a minimum vital sign threshold or acuity score floor. Used in clinical decision rules and quality reporting to identify patients falling below defined clinical limits.

triage mobiletriage_mob

The mobile phone number recorded during emergency department or urgent care triage intake for a patient. Used to contact patients or caregivers regarding care status, follow-up instructions, or appointment scheduling following initial clinical priority assessment.

triage modified bytriage_mod_by

The unique identifier of the clinical user, such as a nurse or triage clinician, who last updated a patient triage record. Supports audit trail requirements by tracking accountability for changes made to acuity levels, vital signs, or chief complaint documentation.

triage modified datetriage_mod_dt

The calendar date on which a patient triage record was last updated in the clinical system. Used in emergency department workflows to audit changes to acuity classification, chief complaint, or vital sign documentation after the initial triage assessment was completed.

triage modified timetriage_mod_tm

The timestamp recording when a patient triage record was last updated in the clinical system. Combined with the modified date, this supports emergency department audit trails and helps clinicians track interval changes to acuity ratings or patient condition documentation.

triage nametriage_nm

The human-readable label assigned to a triage classification level or protocol within the clinical system. Typically corresponds to standard acuity scale designations such as ESI levels or Canadian Triage and Acuity Scale categories displayed in emergency department workflows.

triage notetriage_nt

Free-text clinical documentation entered by a triage nurse or clinician during the initial patient assessment in an emergency or urgent care setting. Captures chief complaint details, symptom descriptions, mechanism of injury, or other observations informing the patient acuity classification.

triage numbertriage_nbr

The unique sequential or system-generated identifier assigned to a patient triage encounter in the emergency department or urgent care setting. Used to reference, track, and link triage assessments to downstream clinical events such as bed assignments, orders, and discharge documentation.

triage onset datetriage_onset_dt

The calendar date on which a patient's presenting symptoms or condition first began, as reported during triage intake. Captured to help clinicians assess acuity, differentiate acute from chronic presentations, and determine appropriate urgency of care in emergency or urgent care settings.

triage oxygen saturationtriage_o2sat

The peripheral oxygen saturation percentage measured by pulse oximetry during a patient's initial triage assessment. A critical vital sign used in emergency department acuity scoring to identify respiratory distress, sepsis risk, or other conditions requiring immediate clinical intervention.

triage paid amounttriage_pd_amt

The dollar amount reimbursed or collected for services associated with a triage encounter, including facility fees for emergency department or urgent care assessment. Used in revenue cycle reporting to reconcile triage-related charges against insurance payments or patient responsibility balances.

triage paid datetriage_pd_dt

The calendar date on which payment was received or posted for charges associated with a triage encounter. Used in revenue cycle management to track reimbursement timelines, reconcile accounts receivable, and report on payer performance for emergency and urgent care triage services.

triage parenttriage_prnt

The higher-level triage record or encounter to which a subordinate triage entry is linked in a hierarchical clinical data structure. Used to associate related triage events, such as reassessments or escalations, back to the originating patient encounter in the emergency department system.

triage percentagetriage_pct

A calculated ratio used in triage analytics or acuity scoring, such as the percentage of patients assigned to a specific ESI level, the proportion of high-acuity cases, or a vital sign-derived index used during initial patient priority assessment in emergency department workflows.

triage periodtriage_prd

The defined time interval associated with a triage process, such as the door-to-triage time window, an acuity reassessment interval, or a reporting period used to measure emergency department throughput and compliance with triage completion benchmarks for quality improvement.

triage phonetriage_ph

The primary telephone number recorded during emergency department or urgent care triage intake for contacting the patient or their designated representative. Used to support follow-up communications, care coordination, and callback services related to the triage encounter.

triage preferred nametriage_pref_nm

The name by which a patient prefers to be addressed, as documented during the triage intake process. Supports patient-centered care by ensuring clinical staff in emergency and urgent care settings address patients respectfully, including those whose preferred name differs from their legal name.

triage pricetriage_prc

The charge amount associated with the triage encounter or acuity-based facility fee billed for the initial patient assessment in an emergency department or urgent care setting. Used in revenue cycle management to establish expected reimbursement based on triage level and payer contract rates.

PreviousPage 762 of 806Next