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 categorycons_cat

The classification grouping assigned to a single-use medical supply item based on its clinical purpose, material type, or usage context, such as wound care, surgical, or diagnostic. Used in inventory management and procurement systems to organize supply catalogs, streamline ordering workflows, and generate category-level expenditure reports.

consumable charge amountcons_chrg_amt

The fee assessed for a single-use medical supply item used during a patient encounter or clinical procedure. Used in healthcare billing and charge capture systems to pass supply costs through to payers or patients, support cost accounting for procedure-level profitability analysis, and meet revenue cycle reporting requirements.

consumable chief complaintcons_cc

The primary clinical indication or presenting concern that prompted the use of a single-use medical supply item during a patient encounter. Used in clinical documentation systems to link consumable utilization to specific patient symptoms or diagnoses, supporting appropriateness review and utilization management reporting.

consumable childcons_chld

A subordinate single-use medical supply item that is linked to a parent consumable in a hierarchical supply catalog or bill of materials structure. Used in inventory and procurement systems to manage component-level tracking, support kit assembly workflows, and ensure accurate cost allocation for supply bundles used in clinical procedures.

consumable citycons_city

The municipality associated with the source, delivery destination, or vendor location for a single-use medical supply item. Used in supply chain and procurement systems to validate shipping addresses, calculate freight costs, support geographic sourcing analysis, and ensure accurate delivery routing for clinical supply replenishment.

consumable classcons_cls

The hierarchical tier or regulatory classification assigned to a single-use medical supply item, such as FDA device class or internal supply tier designation. Used in inventory management and compliance systems to enforce handling requirements, apply appropriate procurement controls, and support regulatory reporting for clinical supply management.

consumable codecons_cd

The standardized alphanumeric identifier assigned to a single-use medical supply item within a supply catalog or charge master. Used across procurement, inventory, and billing systems to uniquely identify consumables, link transactions across platforms, and support accurate charge capture, cost tracking, and clinical supply utilization reporting.

consumable commentcons_cmt

A free-text notation entered by clinical or supply chain staff to provide additional context, instructions, or observations related to a single-use medical supply item. Used in inventory and procurement systems to capture exception notes, substitution rationale, quality concerns, or usage guidance not captured in structured data fields.

consumable completed datecons_cmpl_dt

The date on which the processing, delivery, or clinical use of a single-use medical supply item was finalized. Used in supply chain and clinical documentation systems to close open transactions, measure fulfillment cycle times, and confirm that consumable supply requirements for scheduled procedures or patient care episodes were fully satisfied.

consumable confidential indicatorcons_conf_ind

A flag denoting that information associated with a single-use medical supply item is subject to restricted access due to sensitive clinical use, patient privacy requirements, or legal considerations. Used in inventory and clinical documentation systems to control data visibility, enforce role-based access policies, and support HIPAA compliance workflows.

consumable countcons_cnt

The total number of units of a single-use medical supply item recorded within a transaction, inventory snapshot, or clinical usage event. Used in supply chain and charge capture systems to quantify consumption, calculate reorder needs, reconcile physical inventory against system records, and support per-procedure supply cost analysis.

consumable countrycons_ctry

The nation associated with the manufacturing origin, vendor location, or delivery destination of a single-use medical supply item. Used in supply chain and procurement systems to support country-of-origin compliance, apply import regulations, assess supply chain risk by geographic region, and meet trade reporting requirements for clinical consumables.

consumable created bycons_crtd_by

Identifies the user or system that created the single-use supply item record in the inventory or clinical supply management system. Used in audit trails to track accountability for consumable entries across hospital supply chain and materials management workflows.

consumable created datecons_crtd_dt

The calendar date on which the single-use supply item record was first entered into the inventory or clinical supply management system. Used in supply chain auditing to establish record provenance and support traceability of consumable items across healthcare facilities.

consumable created timecons_crtd_tm

The timestamp indicating when the single-use supply item record was first created in the inventory or clinical supply management system. Combined with the created date, this field supports precise audit logging and chronological tracking of consumable record entry in healthcare supply chain workflows.

consumable creatininecons_cr

Records the creatinine value associated with a single-use supply item or procedure requiring renal function assessment, such as contrast media administration. Used in clinical settings to ensure patient safety by verifying kidney function prior to consumable use in diagnostic or therapeutic procedures.

consumable datecons_dt

The primary calendar date associated with a single-use supply item event, such as the date of use, issue, or receipt. Used in healthcare supply chain and clinical documentation systems to establish when a consumable item was utilized or recorded within a patient care or inventory workflow.

consumable datetimecons_dttm

The combined date and time value capturing when a single-use supply item event occurred, including item use, issuance, or receipt. Used in clinical supply management systems to support precise temporal tracking of consumable activity across inpatient, surgical, and procedural care settings.

consumable dea numbercons_dea_nbr

The Drug Enforcement Administration registration number associated with a controlled substance consumable item. Used in pharmacy and clinical supply systems to ensure regulatory compliance, verify prescribing authority, and maintain required documentation for Schedule II through V single-use controlled substance supplies.

consumable death datecons_death_dt

The recorded date of patient death associated with a clinical encounter involving a single-use supply item. Used in clinical documentation and outcomes reporting systems to link consumable usage data to patient mortality events for quality measurement, infection control, or post-procedure complication analysis.

PreviousPage 64 of 320Next