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

primary flag

prim_flgclinical

A boolean indicator identifying the primary or preferred record among multiple related records in a healthcare data system. Used to identify primary diagnosis codes, primary insurance coverage, primary care physicians, and primary addresses when multiple values exist for the same entity.

record procedure date

rec_proc_dtclinical

The calendar date on which a clinical procedure documented within a healthcare record was performed. Used for chronological sequencing of care events, claims adjudication alignment, and retrospective auditing of procedural timelines within patient medical records.

summary approval status

summ_appr_stsoperations

Indicates whether a consolidated clinical or administrative summary document has been reviewed and approved by an authorized clinician or administrator. Tracks the workflow state of the summary through review stages such as pending, approved, or rejected prior to distribution or filing.

data mesh

data_meshtechnology

A decentralized data architecture paradigm that treats data as a product owned and served by domain teams rather than managed by a central data engineering team, with each domain responsible for the quality, documentation, and accessibility of its own data products. In healthcare organizations, a data mesh approach assigns data product ownership to clinical, claims, pharmacy, and operations domains, reducing the central data team bottleneck while establishing platform-level standards for interoperability and governance.

hospital modified time

hosp_mod_tmprovider

The timestamp indicating the exact time a hospital record was last updated in the clinical or administrative system. Combined with the modified date, it provides a precise audit trail of data changes within inpatient facility information systems for compliance and governance.

patient race

pt_racemember

The racial category self-reported or recorded for a patient, based on standard classifications such as OMB categories. Captured in clinical and enrollment systems to support population health reporting, health equity analysis, and federally mandated demographic data collection.

coverage timestamp

cov_tsmember

The combined date and time value capturing when a specific insurance coverage event occurred or was recorded. Used in member enrollment and claims adjudication systems to establish an exact chronological record of coverage changes, eligibility updates, or benefit activations.

frequency unit

freq_untoperations

The unit of measure defining the interval or count of a medication or treatment administration schedule, such as doses per day or administrations per week. Used in clinical systems to standardize dosing frequency expressions and support accurate medication order entry and pharmacy dispensing workflows.

loinc effective date

loinc_eff_dtclinical

The date on which a LOINC code becomes active and valid for use in clinical observation reporting and lab result documentation. Used in terminology management systems to control when newly published or updated LOINC codes may be applied in EHR orders, lab interfaces, and interoperability data exchanges.

intervention date

intv_dtclinical

The calendar date on which a specific care management or clinical intervention was performed or initiated for a member. Used across case management, disease management, and utilization management programs to sequence care activities, measure response times, and support longitudinal reporting of member engagement.

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