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

remittance parent

remit_prntclaims

The identifier linking a remittance transaction to its parent remittance batch or summary-level ERA record. Establishes the hierarchical relationship between individual claim payment details and the overarching remittance advice document in claims payment processing.

organization dea number

org_dea_nbroperations

The Drug Enforcement Administration registration number assigned to a healthcare organization, such as a hospital, pharmacy, or clinic, authorizing the entity to prescribe, dispense, or handle controlled substances. Required for pharmacy claims processing and regulatory compliance reporting.

sign frequency

sgn_freqfinance

The rate or interval at which a clinical sign is measured or assessed for a patient, such as vital signs recorded every four hours. Used in clinical documentation and care management systems to monitor protocol adherence and ensure timely observation of patient condition changes.

adjustment mobile

adj_mobclaims

The mobile phone number of the member, patient, or billing contact associated with a financial adjustment on a healthcare claim or account. Used in claims communication workflows to notify relevant parties of payment changes, appeal outcomes, or requests for additional documentation.

guarantor route

guar_rteclinical

Designated pathway or method by which billing communications, statements, or collection activities are directed to the financially responsible party. Used in patient accounting systems to manage delivery preferences such as mail, electronic billing, or in-person financial counseling for guarantor account management.

approval plan

appr_plnmember

Identifies the specific health plan associated with a prior authorization or service approval request. Used in utilization management to link approval decisions to the member's benefit plan, ensuring services are reviewed against correct coverage rules and medical necessity criteria.

adjustment cancelled date

adj_cncl_dtclaims

The calendar date on which a pending or approved claims adjustment transaction was voided or withdrawn from processing. Captured in claims adjudication systems to maintain a complete financial audit trail and support reconciliation of cancelled versus processed adjustment activity.

chart fax

chrt_faxclinical

The facsimile number associated with the facility, provider, or contact linked to a patient medical chart, used for transmitting clinical documentation. Supports secure exchange of medical records, referral communications, and orders between healthcare entities where electronic health information exchange is unavailable or insufficient.

operation marital status

op_mar_stsoperations

The marital or domestic relationship status of the patient at the time of a surgical procedure, as recorded in the operative or admission record. Used in clinical data systems for demographic completeness, social history documentation, and administrative reporting associated with the patient's surgical encounter.

value note

val_ntquality

Free-text annotation associated with a clinical or administrative data value, capturing supplemental context, clinician observations, or workflow remarks. Used in EHR documentation, care coordination, and clinical data warehouses to provide qualitative detail that structured fields cannot fully express.

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