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

equipment flagequip_flg

A binary or Boolean indicator applied to a medical apparatus record in EHR, claims, or asset management systems to mark a specific condition such as recall status, maintenance required, or billing eligibility. Used by data engineers to filter or segment equipment datasets in downstream analytics pipelines.

equipment frequencyequip_freq

The prescribed rate at which a durable medical equipment item is used, replaced, or resupplied, such as monthly or quarterly. Used in DME authorization and claims processing to validate resupply orders against clinically approved schedules and prevent duplicate or premature billing for consumable equipment components.

equipment full nameequip_full_nm

The complete name of the patient or contact associated with a durable medical equipment order, combining first, middle, and last name components. Used in DME fulfillment and member verification to confirm recipient identity, support accurate delivery coordination, and link equipment records to the correct member enrollment file.

equipment genderequip_gndr

The gender of the patient associated with a durable medical equipment order or authorization record. Used in DME utilization analysis and population health reporting to identify access patterns, support compliance with non-discrimination regulations, and ensure equipment prescriptions are appropriate for the patient's clinical profile.

equipment glucoseequip_gluc

The blood glucose measurement associated with a patient for whom glucose-monitoring durable medical equipment has been ordered, such as a continuous glucose monitor or glucometer. Used in DME authorization workflows to document clinical necessity and validate that equipment requests meet payer coverage criteria for diabetic supply programs.

equipment group numberequip_grp_nbr

The insurance group or plan number associated with the member for whom a durable medical equipment item is being ordered or billed. Used in DME claims adjudication to identify the correct benefit plan, apply appropriate coverage rules, and coordinate benefits when multiple payers are responsible for equipment reimbursement.

equipment hemoglobinequip_hgb

The hemoglobin measurement associated with a patient for whom blood-monitoring durable medical equipment has been ordered. Used in DME prior authorization workflows to document clinical necessity for devices such as pulse oximeters or infusion equipment, ensuring requests meet established coverage criteria for respiratory or hematologic conditions.

equipment history present illnessequip_hpi

A narrative description of the patient's current medical condition that supports the clinical necessity for a prescribed durable medical equipment item. Used in DME prior authorization and appeals workflows to document the progression of symptoms, functional limitations, and treatment history justifying the equipment order to the payer.

equipment identifierequip_id

The unique alphanumeric key assigned to a medical apparatus in EHR, DME claims, and asset management systems. Maps to device registry entries, UDI codes, or internal inventory IDs and serves as the primary join key for equipment records across clinical, billing, and supply chain data platforms.

equipment indexequip_idx

The positional or sequential number identifying a medical apparatus within an ordered list or dataset in EHR and healthcare asset management systems. Used by data engineers to maintain row ordering, support pagination logic, and enable indexed lookups across large equipment inventory datasets.

equipment indicatorequip_ind

A coded Boolean or categorical value signaling a specific state or condition of a medical apparatus in EHR, claims, and DME authorization systems. Used to denote attributes such as active status, maintenance flag, or coverage eligibility within healthcare data models and reporting pipelines.

equipment instructionequip_instr

The standardized or free-text guidance associated with the operation, maintenance, or clinical use of a medical apparatus in EHR and asset management systems. Stored as structured or unstructured data fields to support compliance documentation, patient safety workflows, and device onboarding processes.

equipment keyequip_key

Surrogate primary key that uniquely identifies a medical equipment record in the data warehouse. Used to join equipment attributes across fact and dimension tables in clinical asset management, maintenance tracking, and utilization reporting systems.

equipment languageequip_lang

Indicates the language or communication protocol used by the medical device for interfacing with clinical systems. Relevant for device integration, such as HL7 or proprietary protocols used when equipment transmits readings to EHR or clinical data repositories.

equipment last nameequip_last_nm

Stores the last segment of a medical equipment name used in systems that parse device names into structured name components. Supports consistent sorting and display of equipment records in asset registries, maintenance logs, and clinical inventory management platforms.

equipment legal nameequip_legal_nm

The formally registered name of a medical device as recognized by regulatory bodies such as the FDA or manufacturer documentation. Used in compliance reporting, procurement records, and device identification to ensure equipment is referenced by its official designation.

equipment levelequip_lvl

The hierarchical classification tier assigned to a medical apparatus within EHR, DME, or facility management systems. Indicates the category of equipment such as primary, secondary, or support level, used by data engineers to organize device taxonomies and apply tiered business rules in healthcare data models.

equipment license numberequip_lic_nbr

The regulatory or state-issued license number assigned to a medical device authorizing its use in clinical settings. Used in compliance tracking, biomedical engineering records, and audits to verify that equipment meets required operational and safety certifications.

equipment marital statusequip_mar_sts

A legacy or repurposed field that may capture the operational pairing status of a medical device, such as whether it is paired, standalone, or decommissioned. Used in asset management systems to track device configuration and assignment relationships within clinical environments.

equipment master identifierequip_mstr_id

The enterprise-wide master identifier assigned to a medical device to uniquely distinguish it across all integrated clinical and operational systems. Used in master data management to consolidate equipment records, eliminate duplicates, and maintain a single authoritative source for device tracking.

PreviousPage 13 of 40Next