Supply

The numeric occurrence or quantity value associated with a clinical material item within supply chain, pharmacy, or inventory management systems, representing units on hand, ordered, or dispensed. Used in healthcare data pipelines to support inventory reconciliation, reorder point calculations, and utilization reporting across facilities.

The country associated with the delivery, shipping, or billing address for a clinical supply order. Used in supply chain operations to support international shipment routing, regulatory compliance for cross-border medical supply distribution, and geographic classification of supply transaction records.

The unique identifier of the user, clinician, or system that initially created or entered the supply order or clinical material record. Used for audit trail purposes, accountability tracking, and workflow routing to identify the originating source of a supply transaction within the clinical or administrative system.

Timestamp recording when a clinical supply item record was first entered into an EHR or inventory management system. Critical for data engineers auditing supply chain lineage, reconciling warehouse records, and tracking procurement-to-dispensing workflows in hospital and pharmacy systems.

The timestamp recording the exact date and time at which a supply order or clinical material record was first created in the system. Used to establish order chronology, support audit logging, measure workflow turnaround times, and sequence supply events within a patient encounter timeline.

The serum or urine creatinine lab value associated with a supply order, used to assess renal function when determining appropriate supply selection or dosing. Particularly relevant for supplies requiring renal dosage adjustments, contrast media administration, or nephrology-related clinical material orders.

Calendar date associated with a clinical material transaction or record in EHR, pharmacy, or inventory systems. Used by data engineers to align supply events with patient encounter timelines, claims adjudication periods, and formulary effective date ranges in PBM and hospital analytics pipelines.

Combined date and timestamp capturing the precise moment a clinical material event occurred in EHR or pharmacy dispensing systems. Enables data engineers to perform time-series analysis, sequence supply events within patient encounters, and reconcile timestamps across pharmacy, claims, and clinical data sources.

The Drug Enforcement Administration registration number assigned to the prescriber or dispensing entity associated with a controlled substance supply order. Required for legal dispensing of Schedule II-V supplies, used for regulatory compliance verification, controlled substance reporting, and audit trail documentation in pharmacy and clinical systems.

Date marking the expiration or decommissioning of a clinical supply item record in inventory or EHR systems, analogous to item lifecycle termination. Used by data engineers to filter inactive supply records, enforce referential integrity, and prevent inclusion of obsolete items in active formulary or procurement datasets.

The portion of a supply item's allowed cost applied toward the patient's annual insurance deductible before plan benefits take effect. Captured during claims adjudication and patient billing to accurately reflect member cost-sharing obligations and support explanation of benefits generation for supply transactions.

The calendar date on which a supply order or clinical material record was marked as deleted or logically removed from the active dataset. Used to maintain data integrity, support audit trails, and distinguish voided records from active supply transactions without permanently purging historical information.

A flag denoting that a supply order or clinical material record has been logically deleted or voided within the system without physical removal from the database. Enables soft-delete functionality, preserves historical audit trails, and prevents deleted supply records from appearing in active clinical or financial workflows.

Free-text or coded narrative field describing a clinical material item in EHR, pharmacy, or supply chain management systems. Data engineers use this field for NLP parsing, supply catalog normalization, and mapping proprietary item descriptions to standardized code sets such as UNSPSC, NDC, or HCPCS in analytics pipelines.

Granular attribute data associated with a specific clinical material item in EHR, inventory, or pharmacy systems, including specifications such as size, strength, or unit of measure. Data engineers rely on this field to enrich supply master records and support detailed cost analysis and utilization reporting across care settings.

The target date by which a supply order must be fulfilled, delivered, or a related payment obligation must be satisfied. Used in supply chain scheduling to prioritize order fulfillment, trigger escalation workflows for overdue orders, and track compliance with delivery timelines for clinical material requests.

The prescribed length of time over which a supply item is intended to be used or administered, such as the days supply for a durable medical equipment order or a course of wound care supplies. Used to calculate refill eligibility, manage inventory replenishment schedules, and support clinical treatment planning.

Date from which a clinical supply item record becomes active and valid within EHR, formulary, or inventory management systems. Data engineers use this field to apply slowly changing dimension logic, filter currently active supply records, and align supply availability windows with member eligibility and benefit period data in claims analytics.

Electronic mail address associated with a clinical supply item record, typically linking to a vendor, manufacturer, or procurement contact in supply chain or EHR systems. Data engineers use this field to support vendor master data management, automated procurement notifications, and supplier communication audit trails in healthcare operations platforms.

A flag identifying a supply order as an emergency or urgent request requiring expedited fulfillment, bypassing standard procurement workflows. Used to prioritize critical supply needs in clinical settings, trigger immediate dispensing or delivery processes, and track the volume and frequency of emergency supply requests for operational analysis.