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

deductible cost

ded_cstfinance

The dollar amount applied toward a member's annual deductible for a specific claim or service. Represents the portion of healthcare expenses the member must pay out-of-pocket before the health plan begins covering costs, tracked across claims to monitor benefit year accumulation.

patient expiration date

pt_exp_dtmember

Date after which a patient's record, authorization, or benefit coverage is no longer valid in EHR, payer, or PBM systems. Used in eligibility verification workflows, prior authorization management, claims adjudication edits, and member disenrollment tracking across healthcare data pipelines.

therapist active indicator

thrp_actv_indclinical

A binary flag indicating whether a licensed therapy professional, such as a physical, occupational, or speech therapist, currently holds an active status within the credentialing or workforce management system, determining eligibility to provide and bill for patient services.

schedule end time

sched_end_tmoperations

The clock time at which a scheduled appointment or clinical activity is expected to conclude. Used in patient scheduling systems alongside start time to calculate appointment duration, manage sequential bookings, and prevent conflicts in provider or facility resource allocation.

balance claim date

bal_clm_dtclaims

The date a claim was submitted to a payer for an outstanding patient or account balance, typically following primary adjudication or coordination of benefits. Used in revenue cycle management to track billing timeliness, support collections workflows, and measure days in accounts receivable for unpaid balances.

workflow resolution date

wf_resol_dtoperations

The calendar date on which a healthcare workflow item, such as a grievance, authorization request, or clinical issue, was formally closed or resolved. Used to measure turnaround compliance, track regulatory timeframes, and report on case closure rates in utilization management and member services workflows.

verification creatinine

verif_crclaims

The kidney function marker for a correctness confirmation. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for verification management and reporting.

implant arrival time

impl_arrv_tmmember

Captures the specific time a surgically placed medical device physically arrived at the facility or surgical suite. Critical for tracking implant supply chain logistics, ensuring device availability before scheduled procedures, and documenting chain of custody for regulatory compliance.

drug mobile

drg_mobpharmacy

A data quality artifact resulting from applying a person-level contact attribute to a drug entity. This field does not carry valid meaning in a pharmaceutical data context and should be flagged for removal or reassignment during drug reference data model reviews to prevent data integrity issues.

range date

rng_dtclinical

The calendar date associated with a reference range definition in clinical laboratory or diagnostic systems. Captures when a specific normal value interval was recorded or applied, supporting time-based tracking of range validity across clinical data workflows.

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