Supply

Structured or free-text guidance associated with a clinical material item in EHR or pharmacy systems, detailing handling, storage, or administration requirements. Data engineers parse and standardize this field to support clinical decision support rule engines, dispensing workflow automation, and regulatory documentation in pharmacy and hospital data platforms.

A surrogate or natural key value uniquely identifying a supply record within the clinical data system or data warehouse. Used as a primary reference for joining supply transactions across tables, enabling consistent tracking of supply items through ordering, dispensing, billing, and reporting workflows.

The preferred or documented language associated with a supply record, typically reflecting the patient's communication language for instructions related to supply use. Supports patient education documentation, labeling requirements, and health literacy compliance for clinical supply dispensing and home health supply delivery.

The surname of the individual associated with a supply record, such as the ordering provider, requesting patient, or responsible staff member. Used to identify and link the person to the supply transaction within clinical documentation, ordering workflows, and inventory or charge management records.

The officially registered legal name associated with a supply record, typically the patient or authorized requestor's formal name as recorded in legal or enrollment documents. Used to ensure accurate identification during billing, insurance verification, and regulatory reporting for clinical supply transactions.

Hierarchical classification position of a clinical material item within an organizational taxonomy in EHR, formulary, or inventory management systems, such as category, subcategory, or item tier. Data engineers use this field to build supply hierarchy models, aggregate utilization metrics, and support multi-level cost attribution in healthcare analytics warehouses.

The professional license identifier of the clinician or entity authorized to order or dispense a clinical supply item. Used to validate ordering authority, support regulatory compliance, and maintain an auditable record of licensed personnel responsible for supply orders within clinical and pharmacy workflows.

The marital status of the patient associated with a supply order or record. Captured as part of patient demographic data linked to the supply encounter, supporting eligibility verification, insurance coordination of benefits determinations, and demographic completeness requirements in clinical and billing documentation.

The enterprise-level unique identifier assigned to a clinical supply or medical material item across all healthcare systems. Enables consistent tracking of supplies such as surgical instruments, consumables, and durable medical equipment across inventory, procurement, and clinical use records.

The upper threshold quantity defined for a clinical supply item within inventory management systems. When on-hand stock reaches this level, reorder or replenishment is halted. Used in hospital materials management to prevent overstocking of medical consumables, surgical supplies, or clinical equipment.

The patient medical record number linked to a clinical supply transaction, associating a specific supply item with the patient encounter during which it was consumed or dispensed. Supports charge capture, cost allocation, and clinical documentation for supplies used during patient care.

The middle name or initial associated with an individual linked to a clinical supply record, such as a requisitioner, patient, or authorized user. Used to disambiguate individuals with similar names in supply chain and materials management workflows within healthcare systems.

The lower threshold quantity defined for a clinical supply item within inventory management systems. When on-hand stock falls to or below this level, a reorder or replenishment request is automatically triggered to ensure continuous availability of medical consumables or clinical materials.

The mobile phone number associated with a contact person linked to a clinical supply record, such as a vendor representative, requisitioner, or department contact. Used to facilitate communication regarding supply orders, deliveries, or procurement inquiries within healthcare materials management.

The system user identifier of the individual who last updated a clinical supply record. Captures the username or employee ID to support audit trail requirements, change management accountability, and compliance tracking within healthcare inventory and materials management systems.

Timestamp recording the most recent update to a clinical supply item record in EHR, pharmacy, or inventory management systems. Data engineers use this field to drive incremental data loads, detect record changes for CDC pipelines, and maintain audit history in healthcare data warehouses tracking supply master data modifications over time.

The timestamp recording when a clinical supply record was most recently updated in the healthcare materials management system. Used for audit trail purposes, data synchronization, and change history tracking across inventory, procurement, and clinical supply documentation workflows.

Display label or standardized name assigned to a clinical material item in EHR, pharmacy, or supply chain systems, often aligned to manufacturer nomenclature or internal catalog naming conventions. Data engineers use this field for supply catalog normalization, duplicate detection, and user-facing reporting dimensions in healthcare analytics and procurement platforms.

Annotation or supplemental text field attached to a clinical material item record in EHR, pharmacy, or inventory systems, capturing ad hoc instructions, exceptions, or contextual observations. Data engineers process this field for NLP extraction, audit documentation, and enrichment of supply master records in healthcare data warehousing pipelines.

Numeric reference value assigned to a clinical material item for identification or cataloging purposes in EHR, pharmacy, or supply chain management systems, such as a catalog number or lot number. Data engineers use this field to link supply records across procurement, dispensing, and claims datasets in healthcare data integration workflows.