Supply

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.

The timestamp marking when a clinical supply order or administration was completed. Captures the precise time a supply item's dispensing, infusion, or usage period concluded, supporting nursing documentation, charge capture, and clinical workflow auditing in inpatient and outpatient settings.

The username or identifier of the clinical staff member who recorded the supply order or transaction in the system. Used for audit trails, accountability tracking, and charge reconciliation when reviewing supply usage documentation in EHR and clinical data warehouse environments.

Records the ethnicity associated with a supply record context, likely linked to the patient receiving the supply or the ordering encounter. Supports demographic reporting, health equity analysis, and regulatory compliance when tracking supply utilization patterns across diverse patient populations.

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.

A reference identifier assigned by an external system, such as a vendor platform, inventory management system, or interfacing application, to uniquely identify a clinical supply item. Enables cross-system reconciliation, supply chain tracking, and integration between EHR and external procurement or billing systems.

The facsimile number associated with a supply order contact, vendor, or ordering entity. Used to facilitate communication with suppliers or external parties involved in procurement, restocking, or authorization of clinical supply items within healthcare inventory and ordering workflows.

The charge amount billed or allocated for a clinical supply item used during patient care. Captured for cost accounting, claim submission, and revenue cycle processing. Reflects the billable or cost-center value assigned to medical supplies consumed in clinical encounters or procedures.

The first name of the individual associated with a supply record, such as the ordering clinician, requesting patient, or responsible staff member. Used to identify the person linked to the supply transaction within clinical documentation, ordering workflows, or inventory management records.

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.

The scheduled interval or dosing frequency at which a clinical supply item is administered or replenished, such as daily, every 8 hours, or as needed. Drives nursing administration schedules, supply dispensing timelines, and clinical order management within EHR and medication administration record systems.

The complete descriptive name of a clinical supply item, including product name, size, or specification details. Used to clearly identify the supply in clinical documentation, charge capture records, inventory systems, and reporting to distinguish items from similar products in the supply catalog.

The gender classification associated with the patient or individual linked to a supply record or order. Supports demographic tracking, health equity reporting, and appropriate supply selection for gender-specific clinical items within EHR clinical documentation and supply utilization analytics.

The glucose measurement or value associated with a supply record, typically documenting blood sugar readings linked to diabetic supply orders such as test strips, lancets, or insulin delivery devices. Supports clinical monitoring, supply justification, and chronic disease management documentation in the EHR.

An insurance group identifier associated with a supply order or claim, linking the supply transaction to a patient's health plan group enrollment. Used during billing and claims adjudication to validate coverage eligibility for durable medical equipment and clinical supply items under group insurance policies.

The hemoglobin measurement associated with a clinical supply record, typically documenting lab values linked to supply orders for blood products, anemia management supplies, or related diagnostic items. Supports clinical decision-making, medical necessity documentation, and supply utilization tracking for hematology-related orders.

A narrative field capturing the history of present illness associated with a supply order, documenting the clinical rationale or patient condition that necessitated the supply. Supports medical necessity justification, prior authorization requests, and clinical documentation integrity for ordered supply items.

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.

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.

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.