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

claim parent

clm_prntclaims

Identifier linking a subordinate claim to its originating or controlling claim record in payer and EHR systems, establishing parent-child relationships used in claim resubmissions, voids, and adjustments. Critical for data engineers modeling recursive claim hierarchies in adjudication and coordination-of-benefits pipelines.

wing end time

wng_end_tmoperations

The specific time at which a wing-related event, operational period, or record validity concludes within the healthcare facility management system. Used alongside the end date to precisely define the deactivation or closure of a building section, supporting time-sensitive facility scheduling and operational reporting.

remittance rating

remit_rtgclaims

A quality or performance assessment score assigned to a remittance transaction or payer, reflecting accuracy of payment, timeliness, and compliance with contractual terms. Used by provider revenue cycle teams to evaluate payer performance and prioritize follow-up on underpayments.

availability count

avail_cntclinical

The numeric total representing the number of open appointment slots or scheduling availability windows within a defined timeframe, location, or provider schedule. Used in capacity planning and scheduling analytics to monitor supply of available appointment time against patient demand.

Contraindication

CIclinical

A clinical condition or factor that makes a particular drug, procedure, or treatment inadvisable for a patient, coded in EHR and pharmacy systems using structured terminology such as SNOMED or RxNorm. Data engineers use contraindication data to support clinical decision support rules, drug safety alerting, and quality measure exclusion logic.

floor modified date

flr_mod_dtoperations

The calendar date on which a hospital floor's record was most recently updated in the facility management or hospital information system. Used in audit logging and data governance workflows to track the recency of configuration changes and support change management processes.

availability assessment

avail_asmtclinical

Free-text or structured clinical evaluation notes associated with an open scheduling slot, documenting the clinician's findings at the time of the encounter. Supports clinical documentation, care coordination, and downstream coding workflows in patient care settings.

Benzodiazepine

BZDpharmacy

A class of sedative medications that enhance the effect of GABA neurotransmitter producing calming effects. Benzodiazepines include diazepam, lorazepam, and alprazolam. Classified as Schedule IV controlled substances and tracked in prescription drug monitoring programs and pharmacy claims adjudication systems.

assistant duration

asst_durclinical

The total elapsed time a clinical assistant was engaged in a specific patient encounter, care activity, or organizational role. Used in workforce analytics, staffing models, and clinical operations reporting to evaluate time allocation, productivity, and support service utilization patterns.

visit total count

vst_tot_cntclinical

Represents the cumulative number of patient encounters recorded within a defined period or for a specific patient, provider, or care program. Used in utilization management, population health analytics, and quality reporting to quantify care access patterns and service volume metrics.

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