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

sample sex

smpl_sexclinical

The biological sex designation associated with a specimen donor, used to apply sex-specific reference ranges and interpret laboratory test results accurately. Used in laboratory information systems to ensure correct normal range application for analytes such as hormone levels, hemoglobin, and creatinine.

consultation middle name

consult_mid_nmclinical

The patient's middle name or initial recorded in association with a specialist consultation request. Supports accurate patient identity matching and disambiguation in clinical systems where multiple patients share the same first and last name, reducing the risk of misidentification errors.

statement adjustment amount

stmt_adj_amtclaims

The dollar value of modifications applied to a patient billing statement, including insurance payments, contractual discounts, or corrective adjustments reducing or increasing the patient-owed balance. Used in patient accounting systems to reconcile billed charges against final statement amounts.

chart quantity

chrt_qtyclinical

The numeric count of discrete items documented within a patient medical record, such as the number of medications, procedures, diagnoses, or lab results recorded. Used in clinical data analysis to measure documentation volume and completeness across patient encounters.

dosage datetime

dos_dttmclinical

The combined date and time value capturing when a specific medication dose was administered, prescribed, or recorded. Used in EHR, pharmacy, and PBM systems to timestamp dosing events with precision for medication administration records (MAR) and clinical audit trails.

pharmacist full name

phrm_full_nmpharmacy

The complete name of a licensed pharmacist, combining first, middle, and last name components. Used in pharmacy claims, dispensing records, credentialing systems, and regulatory submissions where a single concatenated name field is required for identification.

coinsurance claim date

coins_clm_dtclaims

The date on which a claim requiring member coinsurance cost-sharing was submitted to the payer. Used to track filing timeliness and associate coinsurance liability with the correct benefit period, deductible accumulation cycle, and plan year for member billing purposes.

manual flag

manual_flgtechnology

A boolean indicator identifying records that were manually entered or modified by a user rather than generated automatically by a healthcare data system. Used to distinguish system-generated transactions from manual adjustments in claims processing, enrollment, and provider data management.

subscriber end time

subscr_end_tmmember

The precise time at which a service encounter, authorization period, or enrollment transaction concluded for the subscriber, the primary insurance policy holder. Used in member management and claims systems to calculate service duration and establish exact coverage or transaction boundaries.

experience modified by

exp_mod_byquality

Username or system identifier of the user or process that last updated a patient care experience record, used for audit trail documentation, data governance accountability, and change tracking in clinical and administrative healthcare information systems.

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