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 engineers & architects.

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

payer termination date

pyr_term_dtmember

The ending date value for a insurance company entity. Used to track temporal information related to payer termination date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for payer management and reporting.

note npi number

nt_npiprovider

The national provider identifier for a clinical documentation entry. Used as a unique reference to identify and track the note across healthcare systems. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for note management and reporting.

copay end date

cpay_end_dtpharmacy

In claims, PBM, and member enrollment systems, the copay end date is the date on which a specified patient cost-sharing amount ceases to apply for a benefit plan or drug tier. Used in benefits configuration tables and claims adjudication engines to terminate active copay rules and transition members to updated cost-sharing schedules at renewal or mid-year changes.

ndc reference

ndc_refpharmacy

The external pointer for a national drug code. 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 ndc management and reporting.

problem service date

prob_svc_dtclaims

The date a healthcare service was delivered in relation to a documented active problem or diagnosis in EHR problem list records. Used by data engineers to correlate clinical conditions with care events, support chronic disease management analytics, and validate longitudinal patient data in clinical and claims systems.

survey modified date

surv_mod_dtquality

Records the calendar date when a patient satisfaction or clinical survey record was last updated. Used in audit logging and data governance workflows to track changes over time and ensure data integrity across healthcare survey management systems.

bill reference

bill_reffinance

An external identifier or cross-reference number linking a healthcare billing statement to a related document, prior claim, authorization, or payer transaction. Used in claims reconciliation and denial management to trace billing activity across systems and associate remittance advice with the originating service charge.

admission oxygen saturation

admn_o2satclinical

The blood oxygen level for a hospital inpatient entry. 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 admission management and reporting.

culture fee

cult_feelaboratory

The charge amount billed for performing a microbiology culture laboratory test, representing the service cost assigned to the culture procedure. Used in revenue cycle management, claims adjudication, and patient billing to capture the financial value of culture and sensitivity testing services.

workflow termination date

wf_term_dtoperations

The date on which a healthcare workflow process is formally ended, closed, or deactivated. Used to track the lifecycle completion of clinical tasks, administrative processes, authorization periods, or care management episodes within health 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