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

Search all 100,000+ terms →

vital parent

vtl_prntclinical

Foreign key or hierarchical reference linking a vital sign record to its parent observation group, encounter, or taxonomy node in EHR and clinical data warehouse systems. Data engineers use this field to reconstruct hierarchical vital sign structures and navigate parent-child relationships in flowsheet data models.

organization master identifier

org_mstr_idoperations

The enterprise-level unique identifier assigned to a healthcare entity across all systems within a master data management framework. Used to link and deduplicate organization records across claims, enrollment, credentialing, and provider directory platforms for a single source of truth.

network detail

net_dtlprovider

The specific information for a provider group affiliation. 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 network management and reporting.

snomed temperature

snomed_tempclinical

The body temperature measurement associated with a SNOMED CT-coded clinical observation or vital sign finding. Captures quantitative temperature values linked to standardized terminology, supporting fever detection, sepsis screening, and longitudinal vital sign analysis within clinical datasets.

acuity time

acu_tmclinical

The time of day value for a condition severity level. Used to track temporal information related to acuity time. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for acuity management and reporting.

provider level

prvdr_lvlprovider

Coded attribute classifying a provider's tier, complexity, or billing authorization level within payer, EHR, and credentialing systems. Data engineers use this field to apply differential reimbursement logic, route claims by provider classification, and segment provider populations in network analytics and reporting pipelines.

subscriber language

subscr_langmember

The preferred communication language for a primary insurance policy holder. 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 subscriber management and reporting.

debit creatinine

db_crfinance

The kidney function marker for a charge or amount owed. 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 debit management and reporting.

frequency class

freq_clsfinance

Classification tier assigned to a medication or treatment administration frequency record, indicating the clinical or administrative priority level of the dosing schedule. Used to stratify frequency types within pharmacy and clinical systems for workflow prioritization and formulary management reporting.

group claim date

grp_clm_dtclaims

The claim submission date for a provider organization. Used to track temporal information related to group claim date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for group management and reporting.

100,000+ Healthcare Terms

Use the search above or on our homepage to find any provider, member, claims, or pharmacy term instantly.

Search All Terms