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

consultation totalconsult_tot

The aggregate count or sum of specialist consultation requests within a defined period or patient cohort, as tracked in EHR or claims systems. Used by data engineers to measure referral volume, calculate utilization rates, and support population health reporting.

consultation total countconsult_tot_cnt

The aggregate number of specialist consultation requests associated with a patient, encounter, or reporting period. Used in utilization management and clinical analytics to measure consultation volume, monitor referral patterns, and support population health reporting across care settings.

consultation typeconsult_typ

The classification category of a specialist consultation request in EHR or referral management systems, such as inpatient, outpatient, telemedicine, or urgent. Used to segment referral data, apply appropriate billing rules, and support utilization analytics by care setting.

consultation updated dateconsult_upd_dt

The most recent date on which a specialist consultation request record was modified, amended, or supplemented with new clinical information. Used in audit trails and clinical data governance processes to track record changes and ensure data integrity across health information systems.

consultation urgencyconsult_urg

The clinical priority or time-sensitivity level assigned to a specialist consultation request, such as routine, urgent, or emergent. Used in care coordination and referral management systems to triage and schedule specialist reviews in alignment with the patient's acuity and clinical need.

consultation valueconsult_val

The discrete data point captured for a specialist consultation event in EHR or claims systems, representing clinical, financial, or operational attributes. Used by data engineers to populate analytic datasets, validate referral records, and support quality and cost reporting.

consultation versionconsult_ver

The sequential version number assigned to a specialist consultation request record, incrementing each time the record is updated or amended. Used in clinical data systems to maintain version history, support audit compliance, and distinguish between original and revised consultation documentation.

consultation zipconsult_zip

The five or nine digit postal code associated with the location of the consulting specialist, referring facility, or patient address linked to a consultation request. Used in referral management and geographic analytics to support network adequacy reporting and care access assessments.

consumable active indicatorcons_actv_ind

A binary flag indicating whether a consumable medical supply item is currently active and available for clinical use. Used in supply chain and inventory management systems to filter active versus retired or discontinued single-use items and ensure accurate procurement and dispensing workflows.

consumable active statuscons_actv_sts

The current lifecycle state of a consumable medical supply item, indicating whether it is active, inactive, recalled, or discontinued within the facility's inventory system. Used in supply chain management to govern ordering eligibility, stock replenishment, and compliance with formulary or approved supply lists.

consumable admission datecons_admn_dt

The inpatient admission date associated with the clinical encounter during which a consumable medical supply item was used or issued. Used in hospital billing and supply chain systems to link single-use supply consumption to specific inpatient episodes for cost allocation and claims adjudication.

consumable discharge datecons_dsch_dt

The inpatient discharge date associated with the clinical encounter during which a consumable medical supply item was used or issued. Used in hospital billing and supply chain systems to align single-use supply usage with episode end dates for accurate cost reporting and claims processing.

consumable durationcons_dur

The total time span over which a consumable medical supply item is intended to be used or remains effective, such as the wear time for a wound dressing or catheter. Used in clinical protocols and supply management systems to guide reorder schedules and patient care instructions.

consumable emergency indicatorcons_emerg_ind

A binary flag designating that a consumable medical supply item was used or requested in an emergent clinical situation. Used in supply chain and billing systems to prioritize urgent inventory fulfillment, trigger expedited procurement workflows, and support emergency care cost tracking and reporting.

consumable history present illnesscons_hpi

The clinical narrative describing the patient's current condition and symptom history that necessitated the use of a consumable medical supply item during an encounter. Captured in clinical documentation to provide context for supply utilization and support medical necessity determinations in billing review.

consumable instructioncons_instr

The clinical or operational guidance text associated with the use, handling, or application of a consumable medical supply item. Used in clinical workflows and supply management systems to ensure correct usage at the point of care, support patient education, and maintain compliance with manufacturer or facility protocols.

consumable labelcons_lbl

The human-readable display name assigned to a single-use medical supply item, such as a syringe, dressing, or catheter, used in clinical supply chain systems to identify the item in chargemaster records, procedure documentation, and cost tracking workflows.

consumable notecons_nt

Free-text annotation associated with a single-use medical supply item documenting special handling instructions, substitution details, or clinical usage context. Captured in supply chain and clinical documentation systems to support accurate inventory management and patient charge reconciliation.

consumable procedure datecons_proc_dt

The calendar date on which a single-use medical supply item was consumed during a clinical procedure. Used in hospital billing and supply chain systems to align supply usage with the corresponding procedure encounter for accurate cost allocation and claims submission.

consumable rangecons_rng

The acceptable value span or quantity limits defined for a single-use medical supply item, such as minimum and maximum usage thresholds per procedure. Used in clinical supply chain and charge capture systems to validate consumption data and flag outliers for review.

PreviousPage 133 of 806Next