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 languageintv_lang

The preferred or designated language in which a clinical intervention's instructions, communications, or materials are delivered to the patient or care team. Supports health equity and compliance requirements by ensuring interventions are communicated in the member's primary language.

intervention last nameintv_last_nm

The family surname of the individual — typically a care manager, clinician, or patient — associated with a recorded clinical intervention. Used in care management systems to attribute or link interventions to specific personnel or members within population health workflows.

intervention legal nameintv_legal_nm

The official registered name of the clinician, care manager, or member formally associated with a clinical intervention record. Used in care management and compliance systems to ensure proper attribution, audit trails, and regulatory documentation of intervention activities.

intervention levelintv_lvl

The hierarchical classification indicating the intensity, complexity, or escalation tier of a clinical intervention within a care management program. Distinguishes between low-touch outreach, moderate care coaching, and high-intensity clinical case management activities for stratification and reporting.

intervention license numberintv_lic_nbr

The professional state or board license identifier of the clinician or care manager who performed or authorized a clinical intervention. Used in care management and utilization management systems to validate credentialing, ensure regulatory compliance, and support audit documentation.

intervention marital statusintv_mar_sts

The recorded marital or relationship status of the member receiving a clinical intervention. Captured in care management and social determinants of health assessments to support holistic care planning, identify social support resources, and tailor intervention strategies to the member's household context.

intervention master identifierintv_mstr_id

The enterprise-level master unique identifier assigned to a clinical intervention record, enabling consistent cross-system tracking across care management platforms, EHRs, and data warehouses. Serves as the primary key for linking intervention data across disparate healthcare information systems.

intervention maximumintv_max

The upper threshold or limit value defined for a clinical intervention parameter, such as maximum dosage, maximum number of outreach attempts, or maximum allowable frequency of a care activity. Used in care management rules engines and clinical protocols to enforce safety and utilization boundaries.

intervention middle nameintv_mid_nm

The middle name or initial of the clinician, care manager, or member associated with a clinical intervention record. Used in care management systems alongside first and last name fields to ensure accurate person identification and reduce duplicate or mismatched records.

intervention minimumintv_min

The lower threshold or baseline value defined for a clinical intervention parameter, such as minimum required outreach contacts, minimum dosage, or minimum care activity frequency. Used in care management protocols and quality measurement to ensure intervention standards are met for enrolled members.

intervention mobileintv_mob

The mobile phone number associated with the member or clinician involved in a clinical intervention. Used in care management outreach workflows to facilitate SMS communications, telehealth scheduling, and real-time contact attempts as part of population health engagement programs.

intervention modified byintv_mod_by

The unique identifier of the user — typically a care manager, clinician, or system process — who last updated a clinical intervention record. Used in care management audit trails to maintain accountability, track workflow changes, and support compliance reviews of intervention documentation.

intervention modified dateintv_mod_dt

The calendar date on which a clinical intervention record was most recently updated in the care management system. Used in audit trails, reporting, and data governance processes to track the timeliness of intervention documentation and identify records requiring review or follow-up.

intervention modified timeintv_mod_tm

The timestamp indicating the exact time of day when a clinical intervention record was last updated. Combined with the modified date, this supports precise audit logging, concurrent edit detection, and chronological sequencing of care management workflow events.

intervention nameintv_nm

The standardized display label assigned to a clinical intervention, identifying the type of care activity such as medication counseling, care gap outreach, or disease management coaching. Used across care management platforms, reports, and care plans to present intervention details in a consistent, readable format.

intervention noteintv_nt

Free-text annotation or clinical commentary recorded in association with a care management intervention. Captures contextual details such as member response, barriers to engagement, follow-up actions, or clinical observations that supplement structured intervention data fields in population health workflows.

intervention numberintv_nbr

A system-assigned or sequential reference number uniquely identifying a clinical intervention record within a care management platform. Used to track, retrieve, and cross-reference intervention activities across care plans, utilization management systems, and population health reporting databases.

intervention onset dateintv_onset_dt

The date on which a clinical intervention or care management activity was first initiated or symptoms first appeared. Used in care management platforms to establish timelines for treatment protocols, measure intervention lag, and evaluate clinical response relative to condition progression.

intervention oxygen saturationintv_o2sat

The peripheral oxygen saturation (SpO2) measurement recorded as part of a clinical intervention, typically expressed as a percentage. Captured in clinical data systems to monitor respiratory status, guide oxygen therapy decisions, and document patient condition during acute care or care management encounters.

intervention paid amountintv_pd_amt

The actual dollar amount reimbursed or paid by a payer for a clinical intervention following adjudication. Recorded in claims and care management financial systems to support cost tracking, utilization management analysis, and reconciliation of billed charges against contracted payment rates.

PreviousPage 344 of 806Next