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 costproc_cst

The total expense incurred by a provider or health system for delivering a specific procedure, encompassing labor, supplies, facility overhead, and other direct costs. Used in cost accounting, contract modeling, and value-based care analytics to assess financial performance and procedure-level profitability.

procedure countproc_cnt

The numeric count of procedure records associated with a member, claim, or encounter within healthcare data systems. Used in EHR, claims, and PBM reporting to quantify service utilization, validate billing volumes, and support downstream analytics and member health management workflows.

procedure countryproc_ctry

The name or code of the country where the procedure was performed. Used in claims processing and international benefits administration to identify cross-border care, apply appropriate reimbursement policies, and support geographic reporting for members receiving services outside their home country.

procedure created byproc_crtd_by

The unique identifier or username of the system user who initially entered the procedure record into the clinical or administrative system. Used in audit logging and data governance workflows to establish record provenance, support compliance reviews, and maintain accountability for data entry accuracy.

procedure created dateproc_crtd_dt

The system-generated timestamp indicating when a procedure record was first created in an EHR, claims, or practice management system. Used for audit trails, data lineage tracking, and identifying processing latency between service delivery and record entry in healthcare data pipelines.

procedure created timeproc_crtd_tm

Timestamp recording when a procedure record was initially entered into the clinical or administrative system. Used in audit trails, workflow tracking, and data reconciliation to establish the precise moment a procedure was documented in EHR or claims processing systems.

procedure creatinineproc_cr

Creatinine lab value recorded in association with a clinical procedure, used to assess renal function prior to or following interventions such as contrast imaging or nephrotoxic treatments. Critical for procedure eligibility screening and post-procedure monitoring in clinical documentation systems.

procedure currentproc_curr

A flag or indicator identifying the most recent or active version of a procedure record within EHR and claims systems. Used to distinguish current procedure entries from historical or superseded records in versioned data models, ensuring accurate reporting and downstream data integrity.

procedure datetimeproc_dttm

The combined date and time value recording the precise moment a medical procedure was performed or documented in an EHR or claims system. Used for clinical sequencing, OR scheduling data, anesthesia duration calculations, and time-sensitive reporting in healthcare data pipelines.

procedure dea numberproc_dea_nbr

Drug Enforcement Administration registration number associated with a procedure involving controlled substances. Identifies the licensed prescriber or facility authorized to perform or order the procedure, required for regulatory compliance in pharmacy and clinical documentation workflows.

procedure death dateproc_death_dt

The recorded date of patient death associated with or following a medical procedure in EHR or claims systems. Used in mortality reporting, outcomes analysis, and post-procedure complication tracking to evaluate procedure-related risks and support quality measure calculations.

procedure deductible amountproc_ded_amt

Dollar amount applied toward a member's annual deductible for a specific procedure as adjudicated on a medical claim. Reflects the patient's out-of-pocket cost responsibility before insurance coverage activates, used in claims financial processing and member cost-sharing calculations.

procedure deleted dateproc_del_dt

Date on which a procedure record was marked as deleted or voided within the clinical or administrative system. Supports data lifecycle management, audit compliance, and historical record tracking in EHR and claims systems where soft deletion is used instead of permanent removal.

procedure deleted indicatorproc_del_ind

Boolean or coded flag indicating whether a procedure record has been logically deleted or voided in the system without physical removal. Used in clinical and claims data systems to filter inactive records from active reporting while preserving the historical audit trail.

procedure descriptionproc_desc

Free-text description for procedure within Utilization processes in Healthcare implementations. Used for reporting, integrations, and downstream analytics.

procedure detailproc_dtl

Granular descriptive information associated with a specific medical procedure record in EHR, claims, or surgical systems. Captures supplemental data such as laterality, approach, anatomical site, or clinical notes that provide context beyond the CPT/HCPCS code for accurate documentation and billing.

procedure discharge dateproc_dsch_dt

The date a patient was formally released from a facility following an inpatient or outpatient procedure in EHR and claims systems. Used to calculate length of stay, validate UB-04 claim fields, trigger post-discharge workflows, and support readmission and outcomes reporting.

procedure due dateproc_due_dt

Scheduled or required date by which a clinical procedure must be performed, reauthorized, or followed up on. Used in care management and utilization review workflows to track pending procedures, prior authorization expiration, and preventive care compliance timelines.

procedure durationproc_dur

Length of time, typically in minutes, from the start to the completion of a clinical procedure. Captured in operative and procedure notes for clinical documentation, anesthesia billing, resource utilization analysis, and surgical scheduling in hospital information systems.

procedure effectiveproc_eff

An indicator or attribute denoting that a procedure record is currently active and valid within an EHR or claims data system. Used to filter active procedure records from expired or future-dated entries in enrollment, authorization, and clinical data processing workflows.

PreviousPage 516 of 806Next