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 priorityproc_prty

A ranked or coded value indicating the urgency or scheduling precedence of a procedure within EHR, care management, or utilization management systems, such as elective, urgent, or emergent. Used in data pipelines to stratify procedure queues, support triage analytics, and enforce authorization prioritization rules.

procedure procedure dateproc_proc_dt

The specific calendar date on which a clinical procedure was performed on a patient. Used across claims, surgical records, and clinical documentation to establish the service date for billing, outcomes tracking, quality measurement, and longitudinal care analysis.

procedure pulseproc_pulse

The patient's heart rate in beats per minute recorded at the time of a clinical procedure. Captured as a vital sign in EHR procedural documentation to assess cardiovascular status, monitor patient stability, and support clinical decision-making during interventions.

procedure quantityproc_qty

The numeric count of units, sessions, or items associated with a procedure on a claim or encounter record in claims and EHR systems. Used in adjudication logic to validate billed units against payer-defined maximums, calculate reimbursement amounts, and detect quantity anomalies in fraud and abuse detection pipelines.

procedure raceproc_race

The patient's self-reported racial identity recorded in association with a procedure encounter. Used in clinical and population health data systems to support health equity analysis, identify disparities in procedural access or outcomes, and meet regulatory reporting requirements.

procedure rangeproc_rng

The minimum and maximum allowable values for a procedure-related measure, such as acceptable unit quantities, age eligibility limits, or dosage thresholds, as defined in claims editing, clinical decision support, or compliance systems. Used by data engineers to build validation rules and outlier detection logic in procedure processing pipelines.

procedure rateproc_rt

The reimbursement or payment rate applied to a procedure in claims, fee schedule, or value-based contract systems, expressed as a dollar amount per unit or a percentage of a reference rate such as Medicare fee schedule. Used in adjudication and financial analytics pipelines to calculate provider payments and cost benchmarks.

procedure ratingproc_rtg

A scored evaluation assigned to a procedure based on clinical outcome measures, patient satisfaction, quality benchmarks, or performance metrics. Used in quality management and value-based care programs to assess procedural effectiveness and support provider performance reporting.

procedure ratioproc_ratio

A calculated proportional value comparing two clinical or operational measures associated with a procedure, such as observed-to-expected outcomes, cost-to-reimbursement, or complication rates. Used in clinical analytics and quality reporting to benchmark procedural performance.

procedure reasonproc_rsn

Reason descriptor capturing the clinical or administrative justification for a pharmacy procedure in healthcare systems. Used in PBM and EHR integrations to support reporting, audit trails, and downstream analytics for procedure authorization workflows.

procedure received dateproc_rcvd_dt

The date on which a procedure-related document, referral, order, or claim was received by the processing entity. Used in claims intake workflows, prior authorization tracking, and referral management to measure processing lag and ensure timely clinical or administrative response.

procedure referenceproc_ref

External pointer or cross-system identifier linking a medical procedure to its source record in EHR, claims, or referral systems. Enables traceability across healthcare data platforms including payer adjudication systems and provider billing workflows.

procedure resolution dateproc_resol_dt

The date on which a procedure-related condition, complication, or clinical issue was considered resolved or closed. Used in clinical care management and chronic condition tracking to measure procedure recovery timelines and evaluate outcomes relative to treatment goals.

procedure respirationproc_resp

The patient's respiratory rate in breaths per minute recorded as a vital sign at the time of a clinical procedure. Documented in EHR procedural records to monitor pulmonary function, assess sedation response, and ensure patient safety throughout the intervention.

procedure resultproc_rslt

Outcome measurement or finding recorded after a medical treatment or intervention is performed. Captured in EHR and clinical data systems, this field supports quality reporting, HEDIS measure calculations, and longitudinal patient outcome analytics in healthcare platforms.

procedure review systemsproc_ros

Documents the body systems reviewed during clinical assessment prior to or following a medical procedure. Captures structured review of systems (ROS) data linked to a specific procedure encounter, supporting clinical documentation requirements and quality reporting in EHR systems.

procedure revisionproc_rev

The version or iteration number reflecting updates made to a procedure record, order, protocol, or documentation entry. Used in clinical data management systems to maintain an audit trail of changes and ensure that the most current procedure information is applied in care delivery.

procedure riskproc_rsk

A clinical or actuarial assessment of the potential adverse outcomes, complications, or patient safety concerns associated with performing a specific procedure. Used in pre-procedure evaluation, surgical planning, informed consent documentation, and risk-adjusted quality reporting programs.

procedure routeproc_rte

The anatomical or physiological pathway by which a procedure, medication administration, or therapeutic intervention is delivered, such as intravenous, intramuscular, oral, or topical. Documented in clinical and pharmacy records to ensure accurate treatment administration and safety monitoring.

procedure scheduled dateproc_sched_dt

The calendar date on which a medical procedure is planned to occur, recorded at time of scheduling. Used in surgical scheduling, pre-authorization workflows, and care coordination systems to track appointment planning and ensure timely delivery of clinical services.

PreviousPage 520 of 806Next