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

beneficiary risk

benf_rskmember

A quantified or categorized assessment of the health, financial, or operational risk associated with a health insurance beneficiary. Used in risk stratification models, care management programs, and actuarial analyses to identify high-risk members, allocate care resources, and inform risk adjustment submissions.

disease comment

dis_cmtclinical

Stores free-text annotations, clinical notes, or administrative remarks associated with a disease record in a registry or clinical data system. Used to capture contextual information not represented in structured fields, such as atypical presentations, care coordination notes, or documentation of exceptions relevant to disease management workflows.

benefit payment amount

bnft_pmt_amtclaims

The dollar value paid by a health plan for a specific covered benefit after applying deductibles, copayments, coinsurance, and any applicable coordination of benefits. Recorded in claims remittance systems and used in financial reporting to measure plan expenditures by benefit category.

order start date

ord_start_dtclinical

The date on which a clinical order is initiated or scheduled to begin execution within EHR, pharmacy, or care management systems. Used in data warehouses to calculate order duration, align with authorization start dates, and support longitudinal care analysis across Epic, Cerner, PBM, and claims adjudication platforms.

requirement cancelled date

req_cncl_dtoperations

The calendar date on which a regulatory, clinical, or administrative requirement was cancelled or withdrawn. Used in prior authorization, utilization management, and compliance systems to mark the end of an active requirement, support audit trails, and ensure downstream claim adjudication reflects the correct requirement status.

vaccination system identifier

vacc_sys_idpopulation

A unique system-generated key assigned to a vaccination record within a specific health information system or immunization registry. Used to precisely identify, retrieve, and link vaccine administration events across clinical, billing, and public health reporting platforms.

instrument label

inst_lblclinical

The human-readable display text or short descriptive name used to identify a clinical instrument or assessment tool within user interfaces and reports. Used to present instrument names in a consistent, recognizable format across EHR, care management, and clinical reporting systems for end-user navigation.

route description

rte_descclinical

The human-readable text label describing how a medication or treatment is administered, such as oral, intravenous, or topical. Used in pharmacy dispensing, medication orders, and clinical documentation to clearly communicate the intended administration pathway to clinicians and pharmacists.

sample score

smpl_scrclinical

A numerical value derived from laboratory specimen analysis or quality assessment, such as a composite diagnostic score, specimen adequacy rating, or quantitative test result index. Used in clinical data systems to support risk stratification, clinical decision-making, and population health analytics.

service coinsurance amount

svc_coins_amtclaims

The patient's share of healthcare service costs calculated as a percentage of the allowed amount after the deductible has been met, per the terms of their insurance plan. Used in claims adjudication and patient billing to determine member financial responsibility for rendered services.

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