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

Operations

Scheduling, facilities, departments, workflows, and staff

6,492 operations terms

intervention medical record numberintv_mrn

The unique patient medical record number linked to a specific clinical intervention, ensuring the intervention is accurately attributed to the correct patient in the health record. Used across EHR and care management systems to maintain patient identity integrity and support longitudinal care tracking.

intervention scheduled dateintv_sched_dt

The calendar date on which a clinical intervention, such as a care coordination visit, counseling session, or therapeutic procedure, is planned to occur. Used in care management and clinical operations systems to schedule, monitor, and report on upcoming patient interventions.

intervention scheduled timeintv_sched_tm

The specific time of day at which a clinical intervention is planned to be delivered, such as a care management call, telehealth session, or procedure appointment. Used alongside the scheduled date in clinical workflows to coordinate patient and clinician availability and ensure timely care delivery.

intervention street addressintv_st_addr

The full street address of the location where a clinical intervention is scheduled or delivered, such as a clinic, community site, or patient residence for home-based care. Used in care management and field services programs to document and verify the physical site of service for each intervention.

intervention unitintv_unt

The unit of measure used to quantify a clinical intervention, such as the number of sessions, hours of care, dosage units administered, or service encounters completed. Used in care management and billing systems to standardize intervention volume tracking for reporting, cost analysis, and outcome measurement.

intolerance addressintol_addr

The physical location, such as a clinic or care setting, where a patient's food or drug intolerance was identified, documented, or managed. Used in clinical data systems to record the site of intolerance assessment and support care coordination across settings when managing patients with known sensitivities.

intolerance approval statusintol_appr_sts

The review or validation state of a documented food or drug intolerance record, indicating whether the intolerance has been clinically confirmed, pending verification, or flagged for review. Used in EHR medication management workflows to ensure intolerance records are validated before influencing prescribing or dispensing decisions.

intolerance charge amountintol_chrg_amt

The cost associated with clinical services rendered in the assessment, documentation, or management of a patient's food or drug intolerance, such as allergy testing or consultation fees. Used in billing and clinical data systems to capture charges tied to intolerance evaluation and ongoing monitoring activities.

intolerance effective dateintol_eff_dt

The date on which a patient's food or drug intolerance was formally documented or became clinically active in the health record. Used in EHR and pharmacy systems to establish when an intolerance should begin influencing clinical decision support alerts, prescribing guidance, and medication dispensing rules.

intolerance medical record numberintol_mrn

The unique patient medical record number associated with a documented food or drug intolerance, linking the intolerance record to the correct patient within the health system. Used to ensure accurate patient identification when sharing intolerance data across care settings, pharmacy systems, and clinical decision support tools.

intolerance scheduled dateintol_sched_dt

The date on which a patient is scheduled for a clinical appointment or evaluation related to a known or suspected food or drug intolerance, such as a follow-up allergy consultation or intolerance testing. Used in scheduling and clinical workflows to track planned encounters associated with intolerance management.

intolerance scheduled timeintol_sched_tm

The specific time of day at which a patient's appointment related to a food or drug intolerance evaluation or management is planned. Used in clinical scheduling systems alongside the scheduled date to coordinate patient visits for intolerance assessments, consultations, or follow-up care reviews.

intolerance street addressintol_st_addr

The physical street address associated with where an adverse food or drug intolerance reaction was documented or treated. Used in clinical records to capture location context for intolerance events, supporting care coordination and patient safety reporting across EHR systems.

intolerance unitintol_unt

The unit of measure associated with the substance triggering an adverse food or drug intolerance reaction, such as milligrams or milliliters. Used in clinical documentation to quantify the dose or amount linked to the intolerance event recorded in patient health records.

invoice scheduled dateinv_sched_dt

The calendar date on which an invoice or billing statement is scheduled for submission or processing within a healthcare revenue cycle system. Used to track billing timelines, ensure timely claim submission, and support accounts receivable management in healthcare financial operations.

invoice scheduled timeinv_sched_tm

The specific time of day at which an invoice or billing statement is scheduled for submission or processing within a healthcare revenue cycle system. Used alongside the scheduled date to sequence billing operations and support automated claim submission workflows.

invoice unitinv_unt

The unit of measure applied to line items on a healthcare invoice, such as per visit, per day, or per dose. Used in revenue cycle management to quantify billable services or supplies, ensuring accurate charge capture and reimbursement calculations on submitted claims.

item addressitm_addr

The physical or logical address associated with a billable item, service location, or data record in healthcare claims, EHR, or provider billing systems. Used to identify delivery sites, provider locations, or member addresses for claims routing and reimbursement processing.

item effectiveitm_eff

The date on which a specific item, rate, or record becomes active and applicable within healthcare billing, formulary, or member enrollment systems. Used to manage time-based validity of pricing, coverage rules, and benefit configurations in EHR and PBM platforms.

left without being seen flaglwbs_flg

A flag identifying emergency department patients who registered and were triaged but departed without receiving a medical evaluation by a physician or advanced practice provider. LWBS rates are a key ED access and capacity metric — high rates indicate excessive wait times, insufficient staffing, or capacity constraints that are causing patients to seek care elsewhere or go untreated.

PreviousPage 138 of 325Next