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

instrument effective dateinst_eff_dt

The calendar date on which a medical tool, device, or clinical instrument becomes active and valid for use within EHR or clinical data systems. Used to enforce date-range validations, track device lifecycle events, and support regulatory compliance in medical equipment and instrument management workflows.

instrument scheduled dateinst_sched_dt

The date on which a clinical instrument, such as a diagnostic device or surgical tool, is scheduled for use, maintenance, calibration, or sterilization. Used in facility operations and clinical workflow systems to coordinate equipment availability and ensure readiness for procedures, reducing scheduling conflicts and patient care delays.

instrument scheduled timeinst_sched_tm

The specific time at which a clinical instrument is scheduled for use, maintenance, or sterilization processing. Used in operating room management and biomedical equipment systems to coordinate instrument availability with procedure schedules, ensuring clinical tools are prepared and available at the correct time for patient care delivery.

instrument street addressinst_st_addr

The street-level component of the physical address where a clinical instrument is located, stored, or assigned for use. Used in biomedical equipment management and asset tracking systems to maintain accurate location records for medical devices, supporting maintenance scheduling, compliance audits, and instrument lifecycle management.

instrument unitinst_unt

Standardized unit of measure associated with a medical tool or clinical instrument in EHR and clinical data systems. Defines the quantitative metric used when recording instrument-based measurements or readings, such as mmHg for blood pressure devices or cm for measurement tools, supporting data accuracy and clinical documentation integrity.

insurer addressins_addr

The full mailing or physical address of the insurance company responsible for coverage and claims adjudication. Used in claims processing, member enrollment, and provider contracting systems to route correspondence, coordinate benefits, and fulfill regulatory requirements for payer identification and contact information.

insurer approval statusins_appr_sts

The current authorization or credentialing state of an insurance company within a healthcare system, such as active, suspended, or terminated. Used in claims adjudication and payer management workflows to verify that an insurer is in good standing before processing claims, coordinating benefits, or executing contractual agreements.

insurer charge amountins_chrg_amt

The monetary amount charged to or billed against an insurance company for covered healthcare services. Used in claims processing and accounts receivable systems to record expected reimbursement values from payers, supporting revenue cycle management, remittance reconciliation, and financial reporting across healthcare billing operations.

insurer effective dateins_eff_dt

The date on which an insurance company's contract, participation agreement, or coverage policy becomes active within a healthcare system. Used in payer contracting, claims adjudication, and member eligibility systems to establish the valid start of insurer agreements, ensuring claims are processed under the correct contract terms.

insurer medical record numberins_mrn

A medical record number assigned or referenced by an insurance company to identify a specific patient or member within their claims and utilization management systems. Used to cross-reference clinical records with payer data during claims adjudication, prior authorization, and care management coordination between providers and insurers.

insurer scheduled dateins_sched_dt

The date on which a specific insurer-related activity is scheduled, such as a contract renewal review, claims audit, or benefit coordination meeting. Used in payer relations and revenue cycle management systems to track planned interactions with insurance companies, ensuring timely follow-up on contractual obligations and reimbursement negotiations.

insurer scheduled timeins_sched_tm

The specific time of day associated with a scheduled interaction or event involving the insurer, such as a prior authorization review, eligibility verification call, or claims adjudication appointment. Used in insurance operations workflows to coordinate time-sensitive payer activities.

insurer street addressins_st_addr

The physical street address of the insurance company responsible for coverage, including the mailing or claims submission location. Used in claims processing, member enrollment, and payer contracting to route correspondence, paper claims, and appeals to the correct payer office.

insurer unitins_unt

The specific department, division, or business unit within the insurance company responsible for processing a claim, managing a policy, or handling member inquiries. Used in payer operations to route cases to the appropriate internal team for adjudication or member services.

interoperability data request countinterop_req_cnt

The total number of data requests received or fulfilled through standardized interoperability APIs such as HL7 FHIR under the CMS Interoperability and Patient Access Rule, used to track API utilization, measure compliance with information blocking prohibition requirements, and analyze patient-initiated data access patterns across covered health plans and providers.

intervention addressintv_addr

The physical location where a clinical intervention, such as a care management visit, behavioral health session, or preventive service, is delivered or coordinated. Used in care management and population health programs to document site-of-service for tracking and reporting purposes.

intervention approval statusintv_appr_sts

The current authorization or review state of a planned or completed clinical intervention, such as pending, approved, denied, or under review. Used in utilization management workflows to track whether a care plan intervention has received necessary clinical or administrative approval before delivery.

intervention charge amountintv_chrg_amt

The billed or estimated cost associated with delivering a specific clinical intervention, such as a care management program, therapeutic procedure, or preventive service. Used in care management and value-based care programs to capture financial data for cost tracking, reporting, and outcomes analysis.

intervention effective dateintv_eff_dt

The date on which a clinical intervention becomes active or is formally initiated for a patient, such as enrollment in a disease management program or start of a therapeutic protocol. Used in care management systems to establish the intervention timeline and measure duration and outcomes.

intervention group numberintv_grp_nbr

A numeric identifier associated with a cohort or group of patients receiving the same clinical intervention, such as a shared care management program or clinical trial arm. Used in population health and care management systems to link individual interventions to group-level tracking and reporting.

PreviousPage 137 of 325Next