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 effective dateproc_eff_dt

The date on which a procedure record, authorization, or associated benefit becomes active within EHR, claims, or payer systems. Used to validate claim submission windows, apply correct fee schedules, and ensure procedures align with active member coverage and contract periods.

procedure emailproc_eml

The electronic mail address associated with the provider, facility, or billing contact linked to a specific procedure record in EHR or practice management systems. Used for electronic remittance notifications, prior authorization correspondence, and provider communication workflows in healthcare data systems.

procedure emergency indicatorproc_emerg_ind

Flag identifying whether a procedure was performed under emergency conditions, bypassing standard prior authorization or scheduling requirements. Used in claims adjudication and utilization management to apply appropriate reimbursement rules and exemptions for emergent clinical interventions.

procedure end dateproc_end_dt

The date marking the completion or expiration of a procedure record, authorization, or associated service window in EHR and claims systems. Used to define the service duration boundary, close open procedure records, and validate claim dates against authorized or contracted service periods.

procedure end timeproc_end_tm

Timestamp marking the completion of a clinical procedure, used alongside start time to calculate duration and support anesthesia billing, operative documentation, and resource scheduling. Captured in surgical, procedural, and clinical workflow systems for operational and billing purposes.

procedure enrollment statusproc_enrl_sts

Indicates whether a member was actively enrolled in a health plan or program at the time a procedure was performed. Used in claims eligibility validation and coverage determination to confirm benefit applicability and prevent payment errors during claims adjudication.

procedure entered byproc_ent_by

Identifier of the user, clinician, or staff member who entered the procedure record into the clinical or administrative system. Used in audit logging, data quality reviews, and workflow accountability tracking within EHR and practice management systems.

procedure ethnicityproc_ethn

Ethnicity of the patient associated with a procedure, captured to support population health reporting, health equity analysis, and regulatory compliance under HEDIS and CMS requirements. Used to identify disparities in procedure utilization and outcomes across demographic groups.

procedure expirationproc_exp

Indicates that a procedure code, authorization, or clinical protocol has reached its end-of-validity state within EHR, claims, or prior authorization systems. Used by data engineers to filter expired procedure records and prevent invalid code submission in billing pipelines.

procedure expiration dateproc_exp_dt

The date after which a procedure code, prior authorization, or clinical protocol is no longer valid for claim submission or treatment execution. Referenced in claims adjudication, EHR, and PBM systems to reject or flag procedures billed beyond their approved validity window.

procedure external identifierproc_ext_id

Unique identifier assigned to a procedure record by an external system, such as a referring facility, clearinghouse, or trading partner. Used for cross-system record matching, interoperability, and data reconciliation when integrating claims or clinical data from multiple sources.

procedure faxproc_fax

Fax number associated with the facility or provider linked to a procedure record, used for transmitting clinical documentation such as referral orders, prior authorization requests, and operative reports between healthcare entities in administrative and care coordination workflows.

procedure feeproc_fee

Billed or allowed charge amount associated with a specific clinical procedure, as submitted on a medical claim or documented in a fee schedule. Used in claims pricing, provider contract rate comparisons, remittance processing, and healthcare cost analysis workflows.

procedure first nameproc_first_nm

First name of the patient or associated individual linked to a procedure record, used for identity verification, patient matching, and display in clinical and administrative systems. Supports accurate record linkage across EHR, claims, and care management platforms.

procedure flagproc_flg

A binary or categorical marker applied to a procedure record in claims, EHR, or utilization management systems to indicate a specific condition such as duplicate billing, high-cost status, prior auth required, or quality measure inclusion. Used in ETL logic for downstream filtering and reporting.

procedure frequencyproc_freq

Number of times a procedure is performed or ordered within a defined time period, such as daily, weekly, or per course of treatment. Used in clinical order management, utilization review, and prior authorization to validate medical necessity and coverage limits.

procedure full nameproc_full_nm

Complete name of the patient or associated individual linked to a procedure record, combining first, middle, and last name components. Used for identity verification, reporting, and display in clinical documentation, claims processing, and care coordination systems.

procedure genderproc_gndr

Gender of the patient associated with a procedure, used to validate gender-specific procedure eligibility, support clinical documentation accuracy, and enable demographic analysis in population health, HEDIS reporting, and health equity assessments across clinical and claims data systems.

procedure glucoseproc_gluc

The blood glucose level recorded at the time of a clinical procedure, used to assess metabolic status and determine procedural safety. Captures pre-, intra-, or post-procedure glucose readings in surgical, anesthesia, or bedside clinical documentation workflows.

procedure group numberproc_grp_nbr

The insurance group number associated with the patient's health plan at the time a clinical procedure was performed. Used in claims processing and billing workflows to link procedure records to the correct payer contract and facilitate accurate reimbursement adjudication.

PreviousPage 517 of 806Next