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

denial type

den_typclaims

The categorical classification of a claim denial indicating the basis for rejection, such as clinical, administrative, eligibility, timely filing, or duplicate claim. Used in denial management systems to route appeals, prioritize rework queues, and analyze denial patterns by root cause across payers and service lines.

infectious disease enrollment status

id_enrl_stsclinical

Indicates whether a patient is currently active, inactive, or pending enrollment in an infectious disease management program such as an HIV care continuum, TB treatment program, or hepatitis treatment registry. Used to track patient engagement and program participation across disease management platforms.

pediatric death date

ped_death_dtclinical

The recorded date of death for a pediatric patient in EHR and vital statistics systems, used to close active care records, terminate enrollment eligibility, and support mortality reporting and quality measure calculations for patients under 18.

charge group number

chrg_grp_nbroperations

The insurance plan group identifier associated with the patient at the time a charge is captured, used in hospital billing systems to route claims to the correct payer contract, apply appropriate fee schedules, and determine coordination of benefits for the encounter.

physical surgery date

pe_surg_dtclinical

Date on which a surgical procedure was performed, as documented within the physical examination record. Used to correlate operative history with current clinical findings, supporting continuity of care, pre- and post-operative assessment tracking, and longitudinal patient records.

deductible sex

ded_sexclaims

The biological sex of a member enrolled under a deductible-bearing benefit plan. Used in actuarial analysis, health equity reporting, and population-level cost-sharing studies to assess deductible burden distribution and support regulatory reporting requirements across insurance plan demographic datasets.

problem charge amount

prob_chrg_amtoperations

The billed or estimated charge associated with diagnosing or treating a documented patient health problem. Used in clinical and revenue cycle workflows to link problem list conditions to associated encounter costs, supporting cost-of-care analysis and population health financial modeling.

capacity frequency

cap_freqoperations

The interval or recurrence schedule at which a benefit plan or contract capacity limit is evaluated, reset, or reported. Used in plan administration and utilization management systems to define how often maximum volume thresholds are measured against actual enrollment or service utilization counts.

room sequence

rm_seqoperations

The sequential ordering number identifying the position of a room assignment within a patient's inpatient encounter in ADT and EHR systems. Tracks multiple room transfers chronologically. Data engineers use rm_seq to reconstruct patient movement history and calculate length-of-stay segments across care settings.

dose instruction

dose_instrclinical

The administration guidance text associated with a prescribed medication dose, including directions such as take with food, inject subcutaneously, or avoid grapefruit. Transmitted from prescriber to pharmacist and patient to ensure safe, effective, and accurate medication use.

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