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 typetriage_typ

Classifies the method or protocol applied during the triage assessment, such as ESI, START, SALT, or Manchester Triage System. Used in emergency department and mass casualty documentation to distinguish between standard, pediatric, trauma, and disaster triage approaches across care settings.

triage updated datetriage_upd_dt

The most recent date on which a triage record was modified, reflecting changes to acuity level, vital signs, clinical notes, or patient status during the emergency encounter. Used in audit trails to track clinical reassessments and ensure data integrity within the emergency department information system.

triage urgencytriage_urg

Indicates the time-sensitivity level assigned to a patient during triage, reflecting how quickly clinical intervention is required to prevent deterioration. Derived from acuity scoring tools such as ESI, this value drives patient prioritization, bed assignment, and resource deployment in emergency department workflows.

triage versiontriage_ver

Tracks the iteration number of a patient triage assessment record, enabling audit trails and change history in emergency or urgent care settings. Increments each time the triage record is updated, supporting clinical documentation integrity and concurrent access control.

triage ziptriage_zip

The postal code associated with a patient at the time of triage assessment, typically reflecting the patient's home address. Used in emergency department workflows to analyze geographic patterns in patient volume, acuity levels, and care access disparities across service areas.

ultrasound active indicatorus_actv_ind

A binary flag indicating whether a specific ultrasound order, procedure record, or imaging protocol is currently active within the radiology or clinical documentation system. Used to filter valid records from historical or voided ultrasound entries during reporting and downstream processing.

ultrasound active statusus_actv_sts

Describes the current lifecycle state of an ultrasound procedure or imaging order, such as active, suspended, completed, or cancelled. Used in radiology information systems to manage workflow queues, track outstanding imaging orders, and ensure accurate procedure status reporting.

ultrasound admission dateus_admn_dt

Records the date a patient was admitted to a facility in relation to an ultrasound procedure encounter. Used in radiology and inpatient workflows to correlate imaging orders with hospital admissions, supporting clinical timelines, length-of-stay analysis, and inpatient billing reconciliation.

ultrasound ageus_age

The calculated age of the patient at the time an ultrasound procedure was performed or ordered. Used in radiology reporting and clinical analytics to stratify imaging utilization by patient demographics, support age-appropriate protocol selection, and enable population health assessments.

ultrasound allowed amountus_alwd_amt

The maximum reimbursable amount a payer has contractually agreed to pay for an ultrasound procedure after applying fee schedule rates and plan adjustments. Used in claims adjudication to calculate provider payment, patient cost-sharing obligations, and contractual adjustment amounts on ultrasound-related claims.

ultrasound amountus_amt

Represents a general monetary value associated with an ultrasound procedure encounter, which may reflect billed charges, payments, or adjustments depending on context. Used in financial reporting and claims reconciliation to track the overall cost or reimbursement associated with sonographic imaging services.

ultrasound approval statusus_appr_sts

Indicates the current authorization or prior approval state of an ultrasound procedure, such as pending, approved, denied, or not required. Used in utilization management and radiology workflows to ensure payer authorization requirements are met before imaging services are rendered, reducing claim denials.

ultrasound approved byus_appr_by

Captures the identifier or name of the clinician, radiologist, or administrative user who authorized or approved an ultrasound procedure order. Used in radiology information systems and utilization management workflows to maintain accountability, support audit trails, and document clinical decision authority.

ultrasound arrival timeus_arrv_tm

Records the specific time a patient arrived for a scheduled or unscheduled ultrasound procedure appointment. Used in radiology department operations to measure patient wait times, calculate turnaround metrics, optimize imaging suite scheduling, and support service level performance reporting.

ultrasound arrived dateus_arrv_dt

Records the calendar date on which a patient arrived for an ultrasound procedure at a radiology facility or imaging center. Used alongside arrival time to establish procedure encounter timelines, support scheduling analysis, and measure compliance with appointment adherence benchmarks.

ultrasound assessmentus_asmt

Contains the clinical interpretation or findings narrative documented by the radiologist or sonographer following an ultrasound examination. Used in radiology reports to communicate diagnostic conclusions to ordering providers, support care coordination, and populate structured clinical documentation for downstream coding and billing.

ultrasound balanceus_bal

The remaining unpaid financial obligation on an ultrasound procedure account after applying insurance payments, adjustments, and prior patient payments. Used in revenue cycle management to track patient responsibility balances, support billing follow-up workflows, and generate statements for ultrasound-related services.

ultrasound billed amountus_bill_amt

The gross charge amount submitted to a payer or patient for an ultrasound procedure before contractual adjustments, denials, or payments are applied. Used in claims processing and revenue cycle reporting to establish the starting financial value of ultrasound-related claims during adjudication and cost analysis.

ultrasound birth dateus_birth_dt

The date of birth of the patient associated with an ultrasound procedure record. Used in radiology and claims systems to verify patient identity, calculate patient age at time of service, confirm eligibility for age-specific imaging protocols, and support accurate demographic matching across health records.

ultrasound blood pressureus_bp

Documents the systolic and diastolic blood pressure reading recorded for a patient at the time of or in association with an ultrasound procedure encounter. Used in clinical documentation to capture pre-procedure vital signs, support safety screenings, and provide context for vascular or cardiac sonographic assessments.

PreviousPage 765 of 806Next