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

strength email

str_emlclinical

Email address associated with a specific drug strength record in pharmacy or formulary management systems. Used to contact manufacturers, compounding pharmacies, or regulatory contacts responsible for maintaining accurate drug concentration specifications and dosing information.

disorder payment status

dsrd_pmt_stsclaims

The payment processing state for a abnormal health state. Used to capture financial data associated with disorder transactions. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for disorder management and reporting.

range policy number

rng_pol_nbrclinical

Stores the policy or protocol identifier governing the application of a specific clinical reference range. Used in laboratory and clinical data systems to associate normal value limits with institutional or regulatory policies that define acceptable thresholds for diagnostic measurements and test results.

chemistry scheduled time

chem_sched_tmoperations

The specific time of day at which a clinical chemistry test or specimen collection is scheduled to be performed. Used in laboratory operations to manage phlebotomy rounds, time-sensitive chemistry assays such as trough drug levels, and equipment run schedules within the lab workflow.

hcpcs email

hcpcs_emlsupply

The electronic mail address associated with a HCPCS code record, typically linked to the billing entity, vendor, or supplier responsible for submitting claims under that procedure code. Used in claims administration and DME supplier communication workflows.

account effective

acct_efffinance

The date on which a healthcare account becomes active and eligible for transactions, benefit processing, or claims adjudication. Critical in member enrollment, PBM benefit plan configuration, and payer systems to establish coverage start dates and eligibility validation windows.

enrollment chief complaint

enrl_ccmember

The primary symptom reported for a plan membership registration. 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 enrollment management and reporting.

protocol sex

proto_sexclinical

Records the patient's biological sex classification as required by a standardized clinical protocol, where sex-specific criteria influence eligibility, dosing, or care pathway selection. Used to ensure protocol applicability and support sex-stratified clinical outcome reporting and quality measure calculations.

symptom age

symp_ageclinical

The patient's age at the time a specific symptom was first documented or reported. Used in clinical analytics and epidemiological research to analyze symptom onset patterns across age cohorts, supporting population health studies and age-stratified quality reporting for symptom prevalence and management.

scan unit

scn_untoperations

The standardized unit of measure applied to medical imaging procedures in RIS, PACS, and claims systems (e.g., per scan, per series). Critical for data engineers normalizing imaging utilization metrics, pricing logic, and procedure code mappings across EHR and billing platforms.

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