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

consumable modified datecons_mod_dt

The calendar date on which a single-use clinical supply item record was most recently updated. Supports audit trail and data governance requirements in inventory and supply chain management systems, enabling tracking of record changes over time for compliance and reporting purposes.

consumable modified timecons_mod_tm

The timestamp indicating when a single-use clinical supply item record was most recently updated. Combined with the modified date, this supports precise audit trail tracking in inventory and supply chain management systems, enabling accurate sequencing of record changes for compliance purposes.

consumable namecons_nm

The human-readable label assigned to a single-use clinical supply item within inventory and supply chain management systems. Used to identify and display the consumable in procurement workflows, charge master records, clinical documentation, and materials management reporting across healthcare operations.

consumable numbercons_nbr

A numeric or alphanumeric reference code assigned to a single-use clinical supply item within inventory and supply chain management systems. Used to identify, catalog, and track the consumable across procurement, receiving, dispensing, and billing workflows in healthcare materials management.

consumable onset datecons_onset_dt

The date on which use or deployment of a single-use clinical supply item was initiated. In supply chain and clinical contexts, this may capture when a consumable was first applied or activated during a patient care episode, supporting charge capture and utilization tracking.

consumable oxygen saturationcons_o2sat

An oxygen saturation measurement value associated with the use of a single-use clinical supply item such as a pulse oximetry probe or respiratory consumable. Links the clinical reading to the specific consumable used during patient monitoring, supporting device utilization and outcomes tracking.

consumable paid amountcons_pd_amt

The monetary value paid for a single-use clinical supply item, recorded in supply chain or financial management systems. Supports cost accounting, charge capture reconciliation, vendor payment processing, and budget analysis for consumable expenditures within healthcare materials management.

consumable paid datecons_pd_dt

The date on which payment was made or processed for a single-use clinical supply item. Recorded in supply chain and financial management systems to support accounts payable tracking, vendor reconciliation, and consumable procurement cost reporting within healthcare materials management workflows.

consumable parentcons_prnt

The identifier of a higher-level item or category to which a single-use clinical supply item belongs within a hierarchical inventory structure. Used in supply chain management systems to organize consumables under product families, kits, or procedure packs for reporting and procurement purposes.

consumable percentagecons_pct

A ratio or percentage value associated with a single-use clinical supply item, used in supply chain and financial management systems. May represent markup percentage, usage rate, waste factor, formulary compliance rate, or cost allocation percentage for consumable items in healthcare materials management.

consumable periodcons_prd

The defined time interval associated with a single-use clinical supply item, such as a contract period, usage period, or reporting cycle. Used in supply chain and procurement systems to manage consumable contracts, measure utilization over time, and support period-based cost reporting.

consumable phonecons_ph

A telephone contact number associated with a vendor, supplier, or department linked to a single-use clinical supply item record. Used in supply chain and inventory management systems to facilitate procurement inquiries, vendor communication, and reorder contact for specific consumable items.

consumable preferred namecons_pref_nm

The standardized display name assigned to a single-use medical supply item within inventory and supply chain systems. This name is used across procurement, clinical documentation, and charge capture workflows to ensure consistent identification of disposable items such as syringes, gloves, or wound dressings.

consumable pricecons_prc

The monetary cost assigned to a single-use medical supply item, used in hospital inventory management, supply chain procurement, and patient charge capture workflows. This value supports cost accounting, budget tracking, and billing reconciliation for disposable clinical supplies consumed during patient care encounters.

consumable primary indicatorcons_prim_ind

A flag that designates whether a single-use medical supply item is the primary or preferred option within a category of equivalent consumables. Used in supply chain and clinical systems to identify the default item for ordering, substitution logic, and formulary management when multiple comparable disposable items exist.

consumable prioritycons_prty

A ranking value that determines the order of preference or urgency for procuring or dispensing a single-use medical supply item. Used in supply chain management systems to support reorder sequencing, stockout mitigation, and critical supply allocation during inventory shortages or high-demand clinical situations.

consumable pulsecons_pulse

A supply chain activity metric representing the usage frequency or demand cycle of a single-use medical supply item over a defined period. Used in inventory analytics to monitor consumption velocity, identify high-turnover disposables, and optimize par levels and reorder triggers within hospital supply management systems.

consumable quantitycons_qty

The numeric count or unit volume of a single-use medical supply item available, ordered, dispensed, or consumed within a clinical or supply chain transaction. Used in inventory management, charge capture, and procurement workflows to track stock levels, usage rates, and replenishment needs for disposable clinical supplies.

consumable racecons_race

A classification attribute used in supply chain systems to categorize single-use medical supply items into product families or groupings based on shared material composition, regulatory classification, or clinical application. Supports formulary organization, procurement grouping, and substitution logic across comparable disposable supply categories.

consumable ratecons_rt

The unit cost or per-item price applied to a single-use medical supply item for billing, cost allocation, or contract pricing purposes. Used in supply chain finance and charge capture systems to calculate total supply expenditure, support vendor contract management, and ensure accurate patient or departmental cost attribution.

PreviousPage 67 of 320Next