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 hemoglobinproc_hgb

The hemoglobin concentration recorded in association with a clinical procedure, used to evaluate a patient's blood oxygen-carrying capacity and assess surgical or anesthesia risk. Captured as part of pre-procedure lab assessments in clinical and perioperative documentation.

procedure history present illnessproc_hpi

A structured narrative describing the patient's current medical condition and symptoms relevant to the procedure being performed. Documents the clinical context, symptom onset, duration, and progression, forming a core component of procedure-level clinical documentation and patient encounter records.

procedure identifierproc_id

Unique identifier for procedure within Eligibility processes in Healthcare implementations. Used for reporting, integrations, and downstream analytics.

procedure indexproc_idx

A numeric position or sequence identifier assigned to a procedure within a claim, encounter, or episode record in EHR and claims systems. Used by data engineers to order multiple procedures on a single claim and maintain referential integrity across procedure line-level tables.

procedure indicatorproc_ind

A boolean or coded field in claims, EHR, or utilization management systems that signals the presence, type, or special handling requirement of a procedure. Commonly used in quality reporting pipelines and adjudication logic to trigger conditional processing rules for specific procedure categories.

procedure instructionproc_instr

Structured or free-text guidance associated with a procedure record in EHR or care management systems, detailing pre-procedure preparation, contraindications, or post-procedure protocols. Ingested into clinical data warehouses to support care coordination analytics and provider workflow automation pipelines.

procedure keyproc_key

A surrogate or system-generated primary key that uniquely identifies a procedure record within the clinical data warehouse or source system. Used to join procedure tables across datasets and support data lineage, deduplication, and referential integrity in healthcare analytics environments.

procedure labelproc_lbl

A human-readable display name or descriptive text assigned to a clinical procedure for use in user interfaces, clinical reports, and patient-facing documentation. Provides a standardized or customized string representation of the procedure code or type across health information systems.

procedure languageproc_lang

The language in which procedure-related documentation, instructions, or patient communications are recorded or delivered. Supports multilingual clinical workflows and ensures that informed consent, pre-procedure instructions, and clinical notes are accessible to patients in their preferred language.

procedure last nameproc_last_nm

The surname of the patient associated with a clinical procedure record. Used to match procedure records to patient demographic profiles during clinical documentation, medical record reconciliation, and identity verification workflows within health information systems.

procedure legal nameproc_legal_nm

The patient's official legally registered full name as documented in association with a clinical procedure. Used for identity verification, medical record matching, consent documentation, and compliance with regulatory requirements governing patient identification during clinical care.

procedure levelproc_lvl

Business attribute for procedure within Compliance processes in Healthcare implementations. Used for reporting, integrations, and downstream analytics.

procedure license numberproc_lic_nbr

The state-issued professional license number of the clinician who performed or supervised a clinical procedure. Used in credentialing verification, claims submission, and regulatory compliance reporting to confirm that the performing provider holds an active, valid license for the procedure rendered.

procedure marital statusproc_mar_sts

The documented marital or domestic relationship status of the patient at the time a clinical procedure was recorded. Used in social history documentation and demographic profiling within clinical records, and may influence insurance coordination of benefits determinations in claims processing.

procedure master identifierproc_mstr_id

The enterprise master patient or procedure identifier assigned by a master data management system to uniquely and consistently identify a procedure record across multiple source systems. Enables accurate patient matching and data integration in enterprise clinical data warehouses and HIE environments.

procedure maximumproc_max

The upper threshold or maximum allowable value for a clinical parameter, dosage, frequency, or quantity associated with a procedure. Used in clinical decision support, order validation, and utilization management workflows to enforce safe practice limits and payer-defined benefit caps.

procedure medical record numberproc_mrn

The facility-assigned medical record number of the patient linked to a specific clinical procedure. Used to associate procedure records with the correct patient chart within an EHR, supporting clinical documentation integrity, care coordination, and longitudinal patient history tracking.

procedure middle nameproc_mid_nm

The middle name or initial of the patient associated with a clinical procedure record. Supports accurate patient identity verification and duplicate record resolution during medical record matching, demographic reconciliation, and identity management processes within clinical systems.

procedure minimumproc_min

The lower threshold or minimum required value for a clinical parameter, dosage, quantity, or frequency associated with a procedure. Used in clinical decision support rules and order entry validation to ensure procedural safety standards and payer-defined utilization requirements are met.

procedure mobileproc_mob

The mobile phone number of the patient or responsible party associated with a clinical procedure record. Used to facilitate appointment reminders, pre-procedure instructions, post-procedure follow-up communications, and patient outreach within clinical care coordination workflows.

PreviousPage 518 of 806Next