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 resolution dateintv_resol_dt

The calendar date on which a clinical intervention was formally closed, completed, or determined to no longer be required. Used in care management and disease management programs to calculate intervention duration and assess timely closure of open care actions.

intervention respirationintv_resp

The patient's recorded respiratory rate, measured in breaths per minute, captured at the time of or in context with a clinical intervention. Used in acute care and remote monitoring workflows to assess patient stability and inform intervention urgency and escalation decisions.

intervention resultintv_rslt

The documented clinical outcome or measured finding produced by a specific intervention, such as a lab value, assessment score, or patient response. Used in care management and quality reporting to evaluate intervention effectiveness and support population health analytics.

intervention revisionintv_rev

A version or iteration counter tracking how many times a clinical intervention record has been updated, modified, or amended. Used in care management systems to maintain an audit trail of changes to intervention plans and support data governance and compliance reviews.

intervention riskintv_rsk

A coded or scored assessment of the potential clinical, safety, or operational risk associated with performing or withholding a specific intervention for a patient. Used in care management stratification to prioritize outreach and allocate resources to high-risk member populations.

intervention routeintv_rte

The method or anatomical pathway through which a clinical intervention, particularly a medication or treatment, is administered, such as oral, intravenous, or subcutaneous. Used in pharmacy and clinical documentation systems to ensure safe and accurate treatment delivery.

intervention scoreintv_scr

A numeric value calculated from clinical assessments or screening tools administered as part of a patient intervention, such as a PHQ-9 depression score or HCC risk score. Used in care management platforms to stratify patients, guide clinical decisions, and track outcome changes over time.

intervention sequenceintv_seq

A numeric value indicating the ordered position of an intervention within a series of planned clinical actions or care plan steps for a patient. Used in care management and chronic disease programs to enforce protocol adherence and track multi-step treatment progression.

intervention severityintv_sev

A coded or scaled rating indicating the clinical seriousness of the condition or event that prompted a specific intervention, ranging from mild to life-threatening. Used in care management and utilization review workflows to prioritize case escalation and allocate appropriate clinical resources.

intervention sexintv_sex

The biological sex of the patient at the time of a clinical intervention, used to apply sex-specific clinical guidelines, eligibility criteria, or screening protocols. Supports gender-stratified quality measures and HEDIS reporting within care management and population health programs.

intervention sourceintv_src

Identifies the originating system, program, clinician, or data feed that initiated or submitted a clinical intervention record, such as a health plan referral, EHR trigger, or member self-report. Used in care management analytics to evaluate channel effectiveness and data provenance.

intervention start dateintv_start_dt

The calendar date on which a clinical intervention was initiated or first delivered to a patient, marking the beginning of the active treatment or care management activity. Used to calculate intervention duration, measure timeliness, and support HEDIS and quality program reporting.

intervention start timeintv_start_tm

The specific time of day at which a clinical intervention was initiated, recorded alongside the start date for precise temporal tracking. Used in acute care, care management, and utilization review workflows to assess response times, measure protocol adherence, and audit clinical timelines.

intervention stateintv_st

The US state or territory associated with the location where a clinical intervention was delivered or where the managing care team operates. Used in care management reporting and compliance workflows to apply state-specific regulatory requirements and geographic performance analytics.

intervention statusintv_sts

A coded value representing the current lifecycle stage of a clinical intervention, such as pending, in progress, completed, or cancelled. Used in care management platforms to monitor open activities, trigger follow-up workflows, and report on program completion rates across member populations.

intervention strengthintv_str

The concentration or potency of a medication or therapeutic agent associated with a clinical intervention, expressed in units such as mg or mcg per dose. Used in pharmacy management and medication reconciliation workflows to ensure accurate prescribing, dispensing, and patient safety monitoring.

intervention subtotalintv_subtot

A partial aggregated cost, count, or utilization value representing a subset of services or activities within a clinical intervention episode. Used in care management financial reporting and program analytics to itemize intervention components before applying adjustments or combining with other cost categories.

intervention surgery dateintv_surg_dt

The calendar date on which a surgical intervention was performed for a patient. Used in clinical data systems to establish procedure timelines, measure surgical outcomes, calculate recovery periods, and coordinate post-operative care planning and follow-up scheduling.

intervention targetintv_tgt

The specific anatomical site, condition, behavioral goal, or clinical outcome that a healthcare intervention is designed to address. Used in care management and clinical documentation systems to link interventions to measurable patient health objectives and treatment plan components.

intervention taxonomy codeintv_tax_cd

A standardized classification code that categorizes a clinical intervention by its type, method, or domain within a recognized coding system such as SNOMED CT or CPT. Used to enable consistent reporting, cross-system interoperability, and analysis of intervention patterns across patient populations.

PreviousPage 346 of 806Next