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

item codeitm_cd

A unique identifier assigned to a specific service, drug, supply, or billable unit within healthcare EHR, claims, or pharmacy systems. May correspond to NDC, HCPCS, CPT, or proprietary codes used for adjudication, formulary lookup, and reimbursement processing.

item countitm_cnt

The total number of individual items, units, or records associated with a transaction, claim batch, or billing cycle in healthcare data systems. Used in pharmacy dispensing reconciliation, claims volume reporting, and inventory management across PBM and provider platforms.

item currentitm_curr

Indicates the most recent or active state of an item record in healthcare EHR, claims, or PBM systems. Used to distinguish current values from historical or superseded entries during data reconciliation, member eligibility validation, and claims adjudication processes.

item dateitm_dt

The date associated with a specific item or transaction record in healthcare billing, pharmacy, or claims systems. May represent service date, dispensing date, or posting date used for adjudication timelines, eligibility verification, and financial period alignment in EHR platforms.

item descriptionitm_desc

A human-readable text label describing a specific service, drug, supply, or billable unit within healthcare EHR, claims, or pharmacy data systems. Used to support reporting, audit documentation, member explanation of benefits, and provider billing reference records.

item expirationitm_exp

The date on which a pharmaceutical, medical supply, or formulary item is no longer valid for dispensing or clinical use, as recorded in pharmacy management systems, PBM platforms, and hospital supply chain databases. Used to enforce expiration-based business rules in dispensing workflows and claims adjudication.

item flagitm_flg

A coded indicator applied to a pharmacy, claims, or supply chain item record to denote a special condition such as formulary exception, recall status, controlled substance designation, or billing alert within EHR, PBM, and claims processing systems. Drives downstream workflow routing and adjudication logic.

item identifieritm_id

A unique alphanumeric key assigned to a specific drug, supply, or service item within pharmacy, PBM, claims, and supply chain data systems. Serves as the primary reference key for linking item records across NDC codes, formulary tables, claims line items, and inventory management platforms.

item maximumitm_max

The upper threshold value for a line item in pharmacy, claims, or benefit configuration records. Used in PBM systems to enforce quantity limits, price caps, or benefit maximums per item within adjudication and plan design tables.

item minimumitm_min

The lower threshold value for a line item in pharmacy, claims, or benefit configuration records. Applied in PBM and EHR systems to enforce minimum dispensing quantities, copay floors, or required benefit thresholds during claims adjudication.

item nameitm_nm

The descriptive label assigned to a specific line item within pharmacy, claims, formulary, or benefit configuration records. Used across EHR, PBM, and claims systems to identify drug names, service descriptions, or benefit components in data pipelines.

item numberitm_nbr

A unique numeric or alphanumeric identifier assigned to a line item in pharmacy dispense records, claims, or formulary tables. Used in PBM, EHR, and EDI systems to reference specific products, services, or benefit components during processing and reconciliation.

item percentitm_pct

A percentage value applied to a specific line item in claims, remittance, or pharmacy benefit records. Used in PBM and claims systems to calculate coinsurance rates, plan liability splits, or discount allocations at the individual item level during adjudication.

item previousitm_prev

The prior value of a specific line item before an update or adjustment in claims, pharmacy, or benefit records. Used in EHR and PBM audit trails and change history tables to track modifications to adjudicated amounts, quantities, or benefit configurations over time.

item quantityitm_qty

The count or volume associated with a specific line item in pharmacy dispense, claims, or inventory records. Used in PBM and EHR systems to capture units dispensed, days supply, or service units billed, driving adjudication logic and utilization reporting.

item referenceitm_ref

A cross-reference identifier linking a line item to an external code set, formulary entry, or source system record in claims, pharmacy, or EHR data. Used in PBM and interoperability pipelines to trace item origin, support auditing, and enable cross-system data joins.

item sequenceitm_seq

An ordered numeric position assigned to a line item within a claim, pharmacy transaction, or benefit record. Used in EDI 837, NCPDP, and EHR systems to maintain processing order, support multi-line claim parsing, and ensure accurate data mapping during ingestion.

item statusitm_sts

The current processing or lifecycle state of a line item in claims, pharmacy, or benefit records, such as active, reversed, pending, or denied. Used in PBM and EHR systems to drive workflow routing, reporting filters, and adjudication outcome tracking across data pipelines.

item timestampitm_ts

The date and time a specific line item was created, modified, or processed within claims, pharmacy, or EHR transaction records. Used in PBM, EDI, and EHR systems for audit logging, sequencing adjudication events, and resolving data conflicts in integration pipelines.

item totalitm_tot

The aggregated monetary or quantity value for a specific line item in claims, pharmacy dispense, or remittance records. Used in PBM and claims systems to summarize allowed amounts, billed charges, or dispensed units at the item level for financial reconciliation and reporting.

PreviousPage 25 of 40Next