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

ophthalmology price

opht_prcclinical

Billed or contracted cost associated with an ophthalmology service, procedure, or product such as corrective lenses or surgical implants, used in eye care revenue cycle systems to calculate patient liability, payer reimbursement, and cost reporting.

survey date

surv_dtquality

The calendar date on which a clinical, quality, or patient experience survey was administered or completed. Used in longitudinal care tracking, HEDIS measure reporting, and population health programs to establish when patient data was collected relative to care events.

Pharmacy Extern

pharm_extrnpharmacy

A pharmacy student or graduate completing a structured work experience program in a pharmacy setting before or after graduation. Pharmacy externs gain practical experience in dispensing, patient counseling, and pharmacy operations. Extern hours are tracked in pharmacy education and workforce data systems.

behavioral health encounter identifier

bh_enctr_idbehavioral

A unique identifier assigned to a single behavioral health visit, session, or service event recorded within a patient's treatment episode. This identifier links all clinical documentation, billing records, and outcome measurements associated with that specific encounter, and is distinct from the broader episode-of-care identifier that may span multiple encounters across a treatment course. Used in behavioral health data warehouses to join encounter-level facts to claims, clinical notes, and quality measure calculations.

location category

loc_catoperations

The classification grouping assigned to a physical service site, such as inpatient, outpatient, long-term care, or urgent care. Used in EHR, claims, and network management systems to segment facilities for reporting, contracting, and reimbursement processing.

triage policy number

triage_pol_nbrmember

The unique insurance policy identifier tied to a member's coverage at the time triage assessment was performed. Used in emergency department billing and claims systems to verify active policy, route claims to the correct payer, and apply plan-specific benefits for triage and initial evaluation services.

triage deleted indicator

triage_del_indclinical

A binary flag identifying whether a patient triage record has been logically deleted from the emergency department system. When set, this indicator excludes the assessment from active clinical views while preserving the record for audit, compliance, and historical reporting purposes.

facility identifier

fac_idoperations

A unique alphanumeric code assigned to a healthcare service location in EHR, claims, and payer systems, such as NPI, CMS Certification Number, or internal facility ID, used to route claims, validate provider-facility relationships, and support network directory management.

consumable approved by

cons_appr_byoperations

The name or identifier of the individual who authorized the procurement, use, or reimbursement of a single-use clinical supply item. Used in supply chain and clinical governance workflows to maintain accountability, support audit trails, and enforce approval hierarchies for consumable medical supply management.

nurse pulse

nrs_pulseclinical

The patient heart rate in beats per minute measured and recorded by a licensed nursing professional during a clinical assessment. Documented as a vital sign in EHR and clinical documentation systems to monitor cardiovascular status, detect arrhythmias, and inform treatment decisions across care settings.

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