mdatool
LibraryBlogPricing
mdatool
mdatool

Healthcare data architecture platform for data engineers, architects, and analysts building modern health systems.

HIPAA-AlignedEnterprise Ready

Tools

  • SQL Linter
  • DDL Converter
  • Bulk Sanitizer
  • Naming Auditor
  • Name Generator
  • AI Data Modeling
  • HCC Calculator

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 engineers & architects.

Back to Glossary

Domain

Supply

Inventory, equipment, devices and procurement

800 supply terms

hcpcs timestamphcpcs_ts

The date and time value for a healthcare common procedure coding system. Used to track temporal information related to hcpcs timestamp. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for hcpcs management and reporting.

hcpcs titlehcpcs_ttl

The formal designation for a healthcare common procedure coding system. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for hcpcs management and reporting.

hcpcs totalhcpcs_tot

The sum value for a healthcare common procedure coding system. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for hcpcs management and reporting.

hcpcs total counthcpcs_tot_cnt

The sum of occurrences for a healthcare common procedure coding system. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for hcpcs management and reporting.

hcpcs typehcpcs_typ

The category classification for a healthcare common procedure coding system. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for hcpcs management and reporting.

hcpcs updated datehcpcs_upd_dt

The last change date for a healthcare common procedure coding system. Used to track temporal information related to hcpcs updated date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for hcpcs management and reporting.

hcpcs urgencyhcpcs_urg

The time sensitivity level for a healthcare common procedure coding system. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for hcpcs management and reporting.

hcpcs versionhcpcs_ver

The record version number for a healthcare common procedure coding system. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for hcpcs management and reporting.

hcpcs ziphcpcs_zip

The postal code for a healthcare common procedure coding system. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for hcpcs management and reporting.

inventory addressinvt_addr

A data field in pharmacy and healthcare supply chain systems storing the physical or logical location associated with a specific inventory item, such as warehouse bin, shelf, or dispensing unit location. The invt_addr field supports accurate picking, restocking, cycle counting, and automated dispensing cabinet integration within inventory management and ERP platforms.

inventory amountinvt_amt

The total monetary value of pharmaceutical or medical supply stock recorded in pharmacy management, EHR, or PBM systems. Used in financial reconciliation, cost tracking, and procurement workflows to assess inventory valuation at a given point in time.

inventory averageinvt_avg

The calculated mean quantity or value of pharmaceutical or medical supply stock over a defined period in pharmacy or supply chain systems. Used in PBM and hospital EHR platforms to forecast demand, optimize reorder cycles, and reduce waste or stockouts.

inventory balanceinvt_bal

The remaining quantity or monetary value of drugs, devices, or medical supplies currently on hand within pharmacy, hospital, or PBM inventory systems. Critical for reconciling dispensed versus received stock and ensuring accurate drug supply chain reporting.

inventory categoryinvt_cat

A classification grouping assigned to pharmaceutical or medical supply items in EHR, pharmacy, or supply chain systems. Common categories include controlled substances, biologics, durable medical equipment, or OTC drugs, enabling structured reporting and regulatory compliance tracking.

inventory codeinvt_cd

A standardized alphanumeric identifier assigned to a pharmaceutical product or medical supply item within pharmacy management, PBM, or hospital EHR systems. May align with NDC, HCPCS, or internal catalog codes used for procurement, dispensing, and claims adjudication.

inventory countinvt_cnt

The numeric quantity of a specific pharmaceutical or medical supply item physically present or recorded in a pharmacy, hospital, or PBM system at a given time. Used in cycle counting, audit reconciliation, and regulatory compliance for controlled substance tracking.

inventory currentinvt_curr

The real-time or most recently updated stock level of a pharmaceutical or medical supply item in a pharmacy management or EHR system. Reflects adjustments from dispensing, receiving, returns, or waste events and is used in active procurement and replenishment decisions.

inventory dateinvt_dt

The specific date on which an inventory count, adjustment, receipt, or valuation event was recorded in a pharmacy, PBM, or hospital supply chain system. Essential for audit trails, trend analysis, expiration tracking, and regulatory compliance reporting.

inventory descriptioninvt_desc

A descriptive text field providing details about a pharmaceutical product or medical supply item in EHR, pharmacy, or supply chain systems. Typically includes drug name, form, strength, and packaging details, supporting item identification during procurement and dispensing workflows.

inventory effectiveinvt_eff

The date on which an inventory record, price, or stock level change becomes active within a pharmacy management, PBM, or hospital supply chain system. Used to manage time-sensitive formulary updates, contract pricing activations, and supply availability windows.

PreviousPage 23 of 40Next