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 arrived dateproc_arrv_dt

The calendar date on which a patient arrived at the clinical facility for a procedure. Used in scheduling systems and encounter records to confirm patient presence, support appointment compliance tracking, and enable operational reporting on procedure visit timelines.

procedure assessmentproc_asmt

The clinician's documented evaluation or clinical judgment recorded in association with a procedure encounter, capturing findings, interpretations, or conclusions. Used in clinical documentation to support diagnosis coding, care planning, and continuity of care across treating providers.

procedure averageproc_avg

The mean calculated value across a set of procedure records, used in EHR and claims analytics to benchmark reimbursement rates, frequency of services, or cost metrics for specific CPT/HCPCS codes within a defined population or time period.

procedure balanceproc_bal

The outstanding financial amount remaining after payments and adjustments for a specific medical procedure on a claim. Used in EHR billing modules and claims systems to track unpaid procedure-level charges, patient responsibility, or underpayments from payers.

procedure billed amountproc_bill_amt

The gross dollar amount submitted by a provider on a claim for a specific procedure before payer adjustments, contractual discounts, or benefit plan reductions are applied. Used in revenue cycle management and claims analytics to assess charge capture accuracy and reimbursement rates.

procedure birth dateproc_birth_dt

The date of birth associated with a patient at the time a medical procedure was performed or recorded. Used in EHR and claims systems to validate age-based eligibility, medical necessity rules, and procedure appropriateness against CPT/HCPCS billing guidelines.

procedure blood pressureproc_bp

The systolic and diastolic arterial pressure reading recorded for a patient in the context of a procedure encounter, typically expressed in mmHg. Used in clinical documentation to capture pre-procedure vital signs, assess patient safety thresholds, and monitor physiological status during care.

procedure cancelled dateproc_cncl_dt

The calendar date on which a previously scheduled procedure was officially cancelled by the patient, provider, or facility. Used in scheduling and operational analytics to track cancellation patterns, measure appointment utilization, and support capacity planning and rescheduling workflows.

procedure categoryproc_cat

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

procedure charge amountproc_chrg_amt

The dollar amount charged by a provider or facility for delivering a specific procedure, representing the gross fee before insurance adjudication or contractual adjustments. Used in claims processing and financial reporting to initiate the reimbursement calculation and revenue cycle tracking.

procedure chief complaintproc_cc

The primary symptom, condition, or reason for care as reported by the patient at the time of a procedure encounter, typically documented in the patient's own words. Used in clinical documentation to establish medical necessity, guide diagnosis coding, and support care coordination.

procedure childproc_chld

A subordinate procedure record linked to a parent procedure in hierarchical data models within EHR and claims systems. Identifies component or add-on CPT codes, bundled services, or dependent procedures tied to a primary procedure for accurate billing and adjudication.

procedure cityproc_city

The name of the city where the procedure was performed or where the servicing facility is located. Used in geographic analysis of healthcare utilization, network adequacy assessments, and claims processing to validate place-of-service information and support regional reporting.

procedure classproc_cls

A classification tier categorizing a medical procedure by type, setting, or clinical domain within EHR and claims systems. Used to group CPT/HCPCS codes into categories such as surgical, diagnostic, or preventive for reporting, reimbursement logic, and utilization analytics.

procedure coinsurance amountproc_coins_amt

The member's share of procedure costs calculated as a percentage of the allowed amount after the deductible has been met, per the terms of the health benefit plan. Used in claims adjudication and member cost-sharing calculations to determine patient financial liability for rendered services.

procedure commentproc_cmt

A free-text annotation associated with a specific medical procedure record in EHR or claims systems. Used by clinicians or billing staff to document clarifications, special circumstances, modifier justifications, or payer-specific notes that supplement structured procedure code data.

procedure completed dateproc_cmpl_dt

The calendar date on which a procedure was fully performed and documented as complete in the clinical or administrative system. Used in claims submission, quality measure reporting, and care coordination workflows to confirm service delivery and trigger downstream billing or follow-up processes.

procedure confidential indicatorproc_conf_ind

A flag designating that a procedure record contains sensitive or protected health information requiring restricted access, such as behavioral health, substance use, or reproductive care services. Used to enforce privacy controls under HIPAA and state-specific confidentiality regulations within clinical data systems.

procedure contactproc_cntct

The designated communication reference point associated with a medical procedure record in EHR or practice management systems. Typically captures the provider, facility, or billing contact responsible for the procedure, supporting claims follow-up, authorization tracking, and coordination workflows.

procedure copay amountproc_cpay_amt

The fixed dollar amount a member is required to pay out-of-pocket at the time a procedure is rendered, as defined by their health benefit plan. Used in claims adjudication and member billing to calculate the patient's immediate financial responsibility separate from deductible and coinsurance obligations.

PreviousPage 515 of 806Next