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.

Reference Library

Healthcare Data Glossary — 100,000+ Terms

100,000+ healthcare data terms standardized for dbt, Snowflake, Databricks, and BigQuery

Browse by Domain

Clinical

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

Operations

Scheduling, facilities, departments, workflows, and staff

Claims

ICD-10, CPT, EDI 837/835, adjudication and remittance

Member

Enrollment, eligibility, demographics and plan attribution

Pharmacy

NDC codes, dispensing, PBM, RxNorm and formulary management

Quality

HEDIS, Stars ratings, measures, outcomes and accreditation

Finance

Revenue, costs, budgets, invoices and capitation

Provider

NPI, credentialing, taxonomy and provider networks

Laboratory

Lab results, specimens, LOINC codes and pathology

Supply

Inventory, equipment, devices and procurement

Technology

Systems, databases, interfaces and data standards

Behavioral

Mental health, substance use, psychology and counseling

Population

Public health, prevention, epidemiology and wellness

Featured Terms

refill full name

rfll_full_nmpharmacy

The complete name for a prescription renewal. Used to display and describe the refill in a human-readable format. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for refill management and reporting.

bed type

bed_typoperations

Classifies a hospital bed according to its clinical designation, such as ICU, medical-surgical, telemetry, or psychiatric, within ADT and facility management systems. Used in EHR and claims data to support billing, capacity planning, and care setting identification across inpatient workflows.

mri payment amount

mri_pmt_amtclaims

The payment transaction value for a magnetic resonance imaging. Used to capture financial data associated with mri transactions. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for mri management and reporting.

charge taxonomy code

chrg_tax_cdoperations

The Health Care Provider Taxonomy Code associated with a billable charge, identifying the clinical specialty or provider type performing the service. Used in claim submission to satisfy payer requirements for specialty-specific reimbursement and to validate provider credentials against performed procedures.

adjustment detail

adj_dtlclaims

Granular line-item information captured within a financial adjustment record in claims processing and revenue cycle systems. Includes specific adjustment amounts, codes, dates, and affected service lines. Used to support detailed financial reconciliation, audit reviews, and dispute resolution at the claim line level in payer and provider data platforms.

urology range

uro_rngclinical

The acceptable minimum and maximum value boundaries for a urology-related clinical measurement, such as creatinine levels, urinary flow rates, or PSA values. Used in lab result interpretation and clinical decision support to flag abnormal urinary system indicators.

instrument oxygen saturation

inst_o2satclinical

The oxygen saturation measurement value captured or recorded by a clinical instrument such as a pulse oximeter or patient monitoring device. Used in clinical data systems to document SpO2 readings linked to specific devices, supporting equipment performance validation and patient vital sign documentation.

counselor discharge date

cnsl_dsch_dtclinical

The date on which a mental health counselor formally discharged a patient from a behavioral health treatment program or inpatient psychiatric episode. Used in clinical documentation, claims processing, and utilization management systems to mark the end of an active treatment relationship and trigger follow-up care workflows.

copay type

cpay_typpharmacy

A classification code identifying the category of patient cost-sharing amount, such as specialist, generic drug, urgent care, or emergency, within Pharmacy and payer benefit systems. Used to apply tier-specific adjudication rules, reporting logic, and downstream analytics segmentation.

complication route

cmpl_rteclinical

The designated pathway by which a treatment, medication, or intervention is administered in response to a secondary adverse condition, such as oral, intravenous, or topical. Captured in clinical records and pharmacy data to ensure accurate medication administration documentation and treatment protocol adherence.

100,000+ Healthcare Terms

Use the search above to find any provider, member, claims, or pharmacy term instantly.

Search All Terms

Cite this dictionary: Mudbhary, S. (2026). Healthcare Data Dictionary — ISO-11179 Standard Terms. Zenodo. https://doi.org/10.5281/zenodo.20497719