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

intervention paid dateintv_pd_dt

The date on which payment was issued to the rendering clinician or facility for a completed clinical intervention. Used in claims processing and care management financial systems to reconcile remittance records, track payment cycles, and support accounts receivable reporting and audit workflows.

intervention parentintv_prnt

The higher-level intervention or care plan activity to which a subordinate clinical action is linked in a hierarchical relationship. Used in care management systems to organize nested interventions, support rollup reporting, and maintain structural relationships between complex multi-step treatment or disease management programs.

intervention percentageintv_pct

A proportional value expressed as a percentage associated with a clinical intervention, such as completion rate, compliance rate, or goal achievement level. Used in care management and quality reporting systems to measure intervention effectiveness and track progress toward defined clinical or behavioral health outcomes.

intervention periodintv_prd

The defined time span during which a clinical intervention is active, scheduled, or expected to produce measurable outcomes. Used in care management and utilization management systems to track intervention duration, enforce protocol timelines, and evaluate whether goals are achieved within clinically appropriate timeframes.

intervention phoneintv_ph

The telephone number associated with a clinical intervention contact event, such as a care manager outreach call or telephonic counseling session. Captured in care management platforms to document contact attempts, support member engagement tracking, and maintain audit records of outreach activities.

intervention preferred nameintv_pref_nm

The human-readable display label assigned to a clinical intervention for use in care management dashboards, member-facing communications, and clinical documentation. Allows standardized intervention types to be presented with context-appropriate terminology across different care programs, populations, and reporting environments.

intervention priceintv_prc

The established or billed cost associated with delivering a specific clinical intervention, prior to payer adjudication or contractual adjustments. Used in care management and claims systems to support cost modeling, budget forecasting, and comparison of actual paid amounts against expected intervention pricing benchmarks.

intervention primary indicatorintv_prim_ind

A flag identifying whether a clinical intervention is designated as the primary or principal action within a care plan containing multiple concurrent interventions. Used in care management systems to distinguish lead interventions from supporting activities for prioritization, reporting, and clinical decision support workflows.

intervention priorityintv_prty

A ranking or urgency classification assigned to a clinical intervention indicating the order in which it should be addressed relative to other active care plan activities. Used in care management platforms to guide clinician workflow, ensure high-acuity interventions receive timely attention, and support escalation protocols.

intervention procedure dateintv_proc_dt

The date on which a clinical procedure associated with an intervention was performed. Recorded in clinical and claims data systems to establish service timelines, support prior authorization compliance verification, and enable longitudinal analysis of procedure timing relative to diagnosis and care plan milestones.

intervention pulseintv_pulse

The heart rate measurement in beats per minute recorded during or in association with a clinical intervention. Captured in clinical data systems to document vital signs at the time of a care encounter, monitor cardiovascular status, and inform clinical decision-making for interventions related to cardiac or chronic disease management.

intervention quantityintv_qty

The numeric count or volume of a clinical intervention delivered, such as the number of counseling sessions, medication doses administered, or units of a procedure performed. Used in care management and claims systems to track service utilization, enforce authorization limits, and measure adherence to prescribed treatment plans.

intervention raceintv_race

The racial identity of the member associated with a clinical intervention, collected to support health equity analysis and population health reporting. Used in care management and analytics systems to identify disparities in intervention delivery, outcomes, and access across racial demographic groups within managed care populations.

intervention rangeintv_rng

The minimum and maximum acceptable values defining the expected or normal bounds for a clinical measurement captured during an intervention, such as a vital sign or lab result threshold. Used in clinical data systems to flag out-of-range values, trigger alerts, and support protocol-driven clinical decision support workflows.

intervention rateintv_rt

The reimbursement or contracted rate applied per unit of a clinical intervention, used to calculate expected payment amounts prior to or during claims adjudication. Recorded in care management financial and claims systems to support cost modeling, contract compliance monitoring, and fee schedule management across service categories.

intervention ratingintv_rtg

A scored or qualitative assessment assigned to a clinical intervention reflecting its effectiveness, member satisfaction, or clinical quality. Used in care management and quality improvement systems to evaluate program performance, benchmark intervention outcomes across populations, and support continuous improvement initiatives for clinical protocols.

intervention ratiointv_ratio

A proportional relationship between two clinical values associated with an intervention, such as the ratio of completed to planned sessions or the relationship between a lab result numerator and denominator. Used in care management analytics to measure intervention efficiency, clinical balance metrics, and population health performance indicators.

intervention reasonintv_rsn

Coded or free-text explanation documenting why a specific clinical intervention was initiated, such as disease progression, patient request, or care gap identification. Used in care management platforms to justify therapeutic actions and support clinical decision audits.

intervention received dateintv_rcvd_dt

The calendar date on which a patient confirmed receipt or completion of a planned clinical intervention, such as a wellness outreach, medication counseling, or preventive service. Used in care management tracking to measure program engagement and close care gaps.

intervention referenceintv_ref

An external identifier or pointer linking a documented clinical intervention to a related record, guideline, authorization, or case management system. Enables cross-system traceability between care plans, utilization management decisions, and clinical workflow platforms.

PreviousPage 345 of 806Next