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,391 operations terms

consultation addressconsult_addr

The physical location associated with a specialist consultation request, stored in EHR referral management and claims systems. The consult_addr field identifies the consulting provider's facility or office, supporting care coordination workflows, provider directory matching, and geographic analysis of specialist utilization patterns.

consultation effective dateconsult_eff_dt

The date on which a formal specialist consultation request becomes active within a patient care episode. Referenced in EHR referral management, prior authorization workflows, and utilization management systems to track consultation initiation, approval windows, and care coordination timelines.

consultation scheduled dateconsult_sched_dt

The calendar date on which a specialist consultation has been scheduled in response to a referring provider's request for expert clinical opinion. Used in care coordination and scheduling systems to track referral fulfillment timelines and ensure patients receive timely specialist evaluation.

consultation scheduled timeconsult_sched_tm

The planned clock time at which a specialist consultation appointment is scheduled to take place following a clinical referral or request for expert opinion. Used in scheduling and care coordination systems to manage specialist availability and patient appointment adherence.

consultation street addressconsult_st_addr

The physical street address of the facility or office where a specialist consultation is scheduled to occur. Used in care coordination workflows to direct patients to the correct consultation site and to associate the consult record with the appropriate service location.

consultation unitconsult_unt

The standard unit of measure associated with a specialist consultation in EHR or claims systems, such as minutes, sessions, or encounters. Used by data engineers to normalize utilization data, apply contracted billing rates, and support cost analysis across provider specialties.

consumable addresscons_addr

The physical location address associated with the storage, delivery, or requisition point of a single-use clinical supply item. Used in supply chain and inventory management systems to track where consumables are stocked, ordered from, or delivered within a healthcare facility.

consumable agecons_age

The elapsed time since a single-use clinical supply item was manufactured, received, or placed into inventory. Used in supply chain management to monitor shelf life, enforce expiration policies, and ensure patient safety by preventing use of outdated or degraded consumable medical supplies.

consumable allowed amountcons_alwd_amt

The maximum reimbursable dollar amount a payer will cover for a single-use clinical supply item used during patient care. Used in claims processing and supply cost management to determine payment limits and identify any patient cost-sharing responsibility for consumable medical supplies.

consumable amountcons_amt

The total monetary value or billed charge associated with a single-use clinical supply item consumed during patient care. Used in healthcare billing, cost accounting, and supply chain management to track expenditures and support accurate claims submission for consumable medical supplies.

consumable approval statuscons_appr_sts

The current authorization state indicating whether a single-use clinical supply item has been approved for procurement, use, or reimbursement. Used in supply chain and clinical operations workflows to enforce purchasing controls and ensure consumables meet formulary or payer authorization requirements before use.

consumable approved bycons_appr_by

The name or identifier of the individual who authorized the procurement, use, or reimbursement of a single-use clinical supply item. Used in supply chain and clinical governance workflows to maintain accountability, support audit trails, and enforce approval hierarchies for consumable medical supply management.

consumable arrival timecons_arrv_tm

The timestamp recording when a single-use medical supply item arrived at a healthcare facility or clinical unit. Used in supply chain and inventory management systems to track delivery timing, measure vendor performance, and ensure critical consumables are available for patient care procedures.

consumable arrived datecons_arrv_dt

The calendar date on which a single-use medical supply item was received at a healthcare facility or clinical unit. Used in supply chain management and inventory systems to reconcile purchase orders, verify delivery schedules, and maintain accurate stock availability records for clinical operations.

consumable assessmentcons_asmt

The clinical or operational evaluation narrative associated with a single-use medical supply item, capturing condition, usability, or suitability for patient care. Used in inventory management systems to document inspection findings, quality assessments, and decisions regarding acceptance or rejection of received supplies.

consumable balancecons_bal

The remaining financial obligation owed on a single-use medical supply item following partial payments, adjustments, or credits. Used in healthcare procurement and accounts payable systems to track outstanding vendor liabilities and reconcile consumable purchase transactions against budgeted supply expenditures.

consumable billed amountcons_bill_amt

The total dollar value invoiced for a single-use medical supply item by a vendor or supplier. Used in healthcare procurement and accounts payable systems to validate vendor invoices against purchase orders, process payments, and report supply expenditures for departmental cost accounting and budget management.

consumable birth datecons_birth_dt

The manufacture or production date assigned to a single-use medical supply item, representing the date the item was created or certified for use. Used in inventory management systems to enforce shelf-life compliance, support FIFO rotation policies, and prevent the clinical use of expired consumable supplies.

consumable blood pressurecons_bp

The arterial pressure measurement recorded in association with a single-use medical supply item used during a blood pressure assessment, such as a cuff or sensor. Used in clinical documentation systems to link vital sign readings to the specific consumable device used, supporting accuracy tracking and device performance monitoring.

consumable cancelled datecons_cncl_dt

The date on which a purchase order, requisition, or scheduled delivery of a single-use medical supply item was formally cancelled. Used in supply chain and procurement systems to reconcile open orders, release committed budget allocations, and maintain accurate inventory demand forecasting records.

PreviousPage 63 of 320Next