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 nation name for a clinical material item. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for supply management and reporting.

The creating user identifier for a clinical material item. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for supply management and reporting.

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 record creation time for a clinical material item. Used to track temporal information related to supply created time. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for supply management and reporting.

The kidney function marker for a clinical material item. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for supply management and reporting.

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 number for a clinical material item. Used as a unique reference to identify and track the supply across healthcare systems. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for supply management and reporting.

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 insurance threshold value for a clinical material item. Used to capture financial data associated with supply transactions. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for supply management and reporting.

The record deletion date for a clinical material item. Used to track temporal information related to supply deleted date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for supply management and reporting.

The removal status flag for a clinical material item. Used to track the current state or condition of the supply. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for supply management and reporting.

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 payment deadline date for a clinical material item. Used to track temporal information related to supply due date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for supply management and reporting.

The time span length for a clinical material item. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for supply management and reporting.

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.

The urgent status flag for a clinical material item. Used to track the current state or condition of the supply. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for supply management and reporting.