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

supply end datesupl_end_dt

Date on which a clinical material item record or contract period concludes in EHR, inventory, or PBM formulary systems. Data engineers use this field alongside effective dates to construct valid date ranges, implement SCD Type 2 logic, and exclude expired supply records from active reporting datasets in healthcare data warehouses.

supply end timesupl_end_tm

The completion time value for a clinical material item. Used to track temporal information related to supply end time. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for supply management and reporting.

supply entered bysupl_ent_by

The data entry user for a clinical material item. 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 supply management and reporting.

supply ethnicitysupl_ethn

The cultural classification for a clinical material item. 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 supply management and reporting.

supply expiration datesupl_exp_dt

Date after which a clinical supply item is no longer safe or authorized for patient use, as tracked in pharmacy dispensing, EHR, and hospital inventory systems. Critical for data engineers building expiration monitoring pipelines, regulatory compliance reporting, and waste reduction analytics across inpatient and outpatient care settings.

supply external identifiersupl_ext_id

The external system reference id for a clinical material item. Used as a unique reference to identify and track the supply across healthcare systems. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for supply management and reporting.

supply faxsupl_fax

The facsimile number for a clinical material item. 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 supply management and reporting.

supply feesupl_fee

The service charge for a clinical material item. 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 supply management and reporting.

supply first namesupl_first_nm

The given name for a clinical material item. Used to display and describe the supply in a human-readable format. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for supply management and reporting.

supply flagsupl_flg

Binary indicator field marking a specific status condition for a clinical material item in EHR, pharmacy, or inventory systems, such as hazardous material designation, formulary inclusion, or recall status. Data engineers use supply flags to apply conditional filtering logic, segment supply populations, and drive business rules in healthcare data pipelines.

supply frequencysupl_freq

The dosing schedule for a clinical material item. 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 supply management and reporting.

supply full namesupl_full_nm

The complete name for a clinical material item. Used to display and describe the supply in a human-readable format. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for supply management and reporting.

supply gendersupl_gndr

The sex classification for a clinical material item. 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 supply management and reporting.

supply glucosesupl_gluc

The blood sugar level for a clinical material item. 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 supply management and reporting.

supply group numbersupl_grp_nbr

The insurance group identifier for a clinical material item. Used as a unique reference to identify and track the supply across healthcare systems. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for supply management and reporting.

supply hemoglobinsupl_hgb

The blood hemoglobin level for a clinical material item. 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 supply management and reporting.

supply history present illnesssupl_hpi

The current condition narrative for a clinical material item. 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 supply management and reporting.

supply identifiersupl_id

Primary key or unique reference value assigned to a clinical material item within EHR, pharmacy, or supply chain management systems. Data engineers use this field as a join key across inventory, claims, and procurement datasets to ensure accurate supply record linkage, deduplication, and master data management in enterprise healthcare data platforms.

supply indexsupl_idx

Positional or sequence number assigned to a clinical material item within an ordered list or array in EHR or supply chain systems. Data engineers use this field to maintain ordering integrity when processing multi-item supply transactions, ranked formulary lists, or paginated inventory exports in healthcare data pipelines and API integrations.

supply indicatorsupl_ind

Boolean or coded field denoting a specific condition or classification state for a clinical material item in EHR, pharmacy, or claims systems, such as controlled substance status or preferred brand designation. Data engineers use this field to apply conditional logic, segment supply cohorts, and enforce business rules across healthcare analytics workflows.

PreviousPage 36 of 40Next