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.

Back to Glossary

Domain

Clinical

EHR, ICD-10, LOINC, SNOMED CT, patient care and clinical documentation

16,101 clinical terms

procedure timeproc_tm

The specific time of day at which a medical procedure was performed or recorded. Stored in EHR and surgical systems to support chronological sequencing of clinical events, anesthesia duration calculations, and compliance reporting within healthcare data environments.

procedure timestampproc_ts

System timestamp for procedure within Utilization processes in Healthcare implementations. Used for reporting, integrations, and downstream analytics.

procedure titleproc_ttl

The formal name or descriptive label assigned to a medical procedure, corresponding to standard clinical nomenclature such as CPT or ICD-10-PCS descriptions. Used in clinical documentation, patient-facing materials, and reporting systems to clearly identify the nature of the intervention performed.

procedure totalproc_tot

Aggregate sum value representing the total count or cumulative measurement associated with a procedure, such as total units administered or total billed charges. Used in claims, pharmacy, and encounter data systems for financial reconciliation and utilization reporting.

procedure total countproc_tot_cnt

The total number of times a specific procedure was performed within a defined period or encounter. Used in utilization reporting, claims analysis, and quality measurement to assess procedure volume, identify patterns of care, and support population health management initiatives.

procedure typeproc_typ

Category classification identifying the nature of a medical procedure, such as surgical, diagnostic, therapeutic, or preventive. Used across EHR, claims, and PBM systems to drive coding rules, benefit determination logic, and procedure-level analytics in healthcare data pipelines.

procedure unitproc_unt

The unit of measure applied to a procedure, such as minutes, milligrams, or service units. Critical in pharmacy, claims, and EHR systems for accurate quantity-based billing, drug dosage validation, and downstream analytics supporting utilization management workflows.

procedure updated dateproc_upd_dt

The date on which a procedure record was most recently modified in the source system. Used in data governance, audit trail maintenance, and ETL processing to identify changed records for incremental data loads and ensure clinical and administrative data remains current and accurate.

procedure urgencyproc_urg

A classification indicating the clinical time-sensitivity of a procedure, such as elective, urgent, or emergent. Used in surgical scheduling, prior authorization, and utilization management workflows to prioritize resource allocation and ensure appropriate response timelines for patient care.

procedure valueproc_val

A discrete measured data point associated with a clinical procedure, such as a numeric result, quantity, or scored metric. Used in EHR, lab, and claims systems to capture procedure-level outcomes, support quality measure calculations, and enable longitudinal analytics across healthcare datasets.

procedure versionproc_ver

A numeric or alphanumeric indicator identifying which iteration of a procedure record is current, used when records are subject to amendment or resubmission. Supports audit trail integrity, claims correction workflows, and version control in clinical data repositories and administrative systems.

procedure zipproc_zip

The postal ZIP code of the location where a medical procedure was performed. Used in claims processing to validate place of service, support geographic reimbursement adjustments such as geographic practice cost indices, and enable regional utilization and access-to-care analysis.

product amountprod_amt

The numeric monetary or quantity value associated with a pharmaceutical or healthcare product transaction in claims, PBM, or pharmacy data systems. Represents billed, allowed, or dispensed amounts at the product level and is used in cost aggregation, formulary analysis, and drug spend reporting pipelines.

product averageprod_avg

The calculated mean value of a healthcare product metric—such as cost, quantity dispensed, or utilization rate—aggregated across a defined population or time period in PBM, pharmacy, or claims data systems. Used by data engineers to establish benchmarks, detect pricing anomalies, and support formulary performance reporting.

product balanceprod_bal

The remaining financial or inventory quantity associated with a healthcare product at a given point in time within pharmacy, PBM, or supply chain data systems. Tracks outstanding amounts owed, remaining dispensing inventory, or unapplied credits and is used in drug cost reconciliation and accounts receivable workflows.

product categoryprod_cat

A hierarchical classification grouping pharmaceutical or healthcare products by therapeutic class, formulary tier, or supply type within PBM, pharmacy, and EHR data systems. Used by data engineers to segment drug spend, apply formulary rules, and enable category-level aggregations in clinical and financial analytics pipelines.

product codeprod_cd

A standardized identifier code assigned to a pharmaceutical or healthcare product within PBM, pharmacy, or claims data systems, commonly represented as NDC, HCPCS, or internal formulary codes. Used by data engineers to join product master tables, validate claim drug records, and support drug utilization reporting across data sources.

product countprod_cnt

The numeric tally of distinct or total healthcare product records, transactions, or dispensing events within PBM, pharmacy, or claims data systems over a defined period. Used by data engineers to measure utilization volume, validate data completeness, and support drug dispensing frequency analysis in population health pipelines.

product currentprod_curr

A flag or value indicating the active, present-state record of a pharmaceutical or healthcare product within PBM, formulary, or pharmacy data systems. Differentiates the most recent product version from historical records in slowly changing dimension tables, supporting accurate point-in-time reporting and formulary status tracking.

product dateprod_dt

A timestamp or calendar date associated with a pharmaceutical or healthcare product event—such as manufacture date, dispensing date, or formulary effective date—within PBM, pharmacy, or claims data systems. Used by data engineers to establish temporal context for product transactions, trend analysis, and date-range filtering in ETL pipelines.

PreviousPage 522 of 806Next