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

Supply

Inventory, equipment, devices and procurement

800 supply terms

supply statussupl_sts

Coded value representing the current processing or fulfillment state of a clinical supply item, such as pending, active, or closed, in EHR and inventory systems. Data engineers use this field to filter active supply records, drive workflow state machines, and monitor supply pipeline completeness across healthcare data platforms.

supply street addresssupl_st_addr

The physical street address of the vendor, distributor, or delivery location associated with a clinical supply item. Used in procurement and supply chain management to coordinate shipments, validate vendor records, and maintain accurate sourcing information for inventory and compliance purposes.

supply strengthsupl_str

The concentration or potency of a clinical supply item, particularly for pharmaceuticals or solutions, expressed as the amount of active ingredient per unit volume or weight. Used in pharmacy and clinical workflows to ensure accurate dispensing, dosing calculations, and substitution validation.

supply subtotalsupl_subtot

The partial cost or quantity sum for a subset of clinical supply items within a larger order or requisition, prior to applying taxes, discounts, or additional charges. Used in procurement and financial management to support itemized billing, budget tracking, and purchase order reconciliation.

supply system identifiersupl_sys_id

The unique system-generated identifier assigned to a clinical supply item record within a healthcare information or inventory management system. Used as the primary key to link supply transactions, track usage history, reconcile orders, and maintain referential integrity across supply chain data systems.

supply targetsupl_tgt

Destination identifier indicating the facility, patient, care unit, or system to which a clinical supply item is directed in EHR and procurement systems. Data engineers use this field to route supply records, support facility-level reporting, and enable targeted delivery tracking across healthcare data integration pipelines.

supply taxonomy codesupl_tax_cd

The standardized classification code assigned to a clinical supply item based on product category, type, or material composition, drawn from healthcare supply taxonomies such as UNSPSC or HPIS. Used to organize inventory, support procurement reporting, and enable cross-system supply data comparisons.

supply temperaturesupl_temp

The required storage or transport temperature for a clinical supply item, or the patient body temperature recorded at the time of supply administration. Used to enforce cold chain compliance for temperature-sensitive supplies and to document clinical conditions at the time of supply use.

supply termination datesupl_term_dt

The date on which a clinical supply item, contract, or standing order was permanently discontinued or removed from active inventory. Used in supply chain management to track product lifecycle, enforce formulary changes, and ensure expired or discontinued items are removed from ordering workflows.

supply timesupl_tm

Time-of-day value recording when a clinical supply item was ordered, dispensed, or administered as captured in EHR and pharmacy systems. Data engineers use this field for intraday event sequencing, timestamp precision in clinical timelines, and latency analysis across supply transaction datasets.

supply timestampsupl_ts

The precise date and time a clinical supply item was dispensed, administered, or recorded in EHR or inventory systems. Critical for data engineers reconciling pharmacy dispensing events, surgical supply usage, and charge capture workflows across clinical and billing platforms.

supply titlesupl_ttl

The formal name or official designation assigned to a clinical supply item in the inventory or product catalog. Used as the human-readable label for the supply record, supporting staff identification during ordering, dispensing, and documentation workflows across clinical and supply chain systems.

supply totalsupl_tot

The aggregated quantity or cost sum of clinical supply items consumed within a defined period, encounter, or cost center. Used in hospital ERP, charge capture, and claims systems to reconcile supply utilization against billing records and departmental budget reporting.

supply total countsupl_tot_cnt

The aggregate number of units of a clinical supply item across all transactions, orders, or dispensing events within a specified period. Used in inventory management and utilization reporting to measure consumption rates, forecast demand, and support budget planning for clinical materials.

supply typesupl_typ

The categorical classification assigned to a clinical material item, such as durable medical equipment, surgical implant, or disposable consumable. Used in EHR, inventory management, and claims systems to route supply charges to correct cost centers and billing codes.

supply updated datesupl_upd_dt

The most recent date on which a clinical supply item record was modified in the inventory or materials management system. Tracks changes to quantity, location, status, or other supply attributes, supporting audit trails and inventory accuracy.

supply urgencysupl_urg

Indicates the priority or time-sensitivity level assigned to a clinical supply requisition or order, such as routine, urgent, or stat. Used in hospital materials management to prioritize fulfillment, ensuring critical supplies reach care units without delay.

supply valuesupl_val

The quantified monetary or unit measure assigned to a clinical supply item at the point of dispensing or administration. Referenced in hospital charge master, EHR supply documentation, and claims adjudication systems to validate reimbursement accuracy and cost allocation.

supply versionsupl_ver

A sequential version number assigned to a clinical supply item record to track revisions over time in the materials management or inventory system. Enables data lineage and audit control, ensuring the most current supply specifications or formulary details are applied.

supply zipsupl_zip

The postal ZIP code associated with the shipping, storage, or delivery location of a clinical supply item. Used in healthcare supply chain and materials management systems to route orders, calculate freight costs, and verify vendor or warehouse delivery addresses.

PreviousPage 40 of 40