Clinical

The human-readable text label describing a pharmaceutical or healthcare product in PBM, pharmacy, or claims data systems, typically including drug name, strength, dosage form, and manufacturer details. Used by data engineers to populate drug master reference tables, support display fields in reporting tools, and validate NDC-to-description mappings.

The date on which a pharmaceutical product's validity, formulary inclusion, pricing contract, or dispensing eligibility ends within PBM, pharmacy, or supply chain data systems. Used by data engineers to enforce record lifecycle management, trigger formulary updates, and filter expired drug records from active claims adjudication pipelines.

A binary or coded indicator assigned to a pharmaceutical or healthcare product record in PBM, pharmacy, or claims data systems to denote special attributes such as formulary status, specialty drug designation, controlled substance classification, or prior authorization requirement. Used by data engineers to drive conditional logic in adjudication and reporting workflows.

A unique system-generated or standardized key assigned to a pharmaceutical or healthcare product within PBM, pharmacy, EHR, or claims data systems, commonly aligning with NDC, RxNorm, or internal surrogate keys. Serves as the primary join key across drug master, formulary, and claims fact tables in data warehouse environments.

Binary yes/no flag denoting whether a specific product attribute, coverage tier, or formulary condition applies within pharmacy, PBM, or member enrollment systems. Used in benefit configuration logic, eligibility processing, and downstream reporting to filter or segment product-related records.

Upper threshold value defining the maximum allowable quantity, benefit limit, or coverage amount for a healthcare product within PBM, pharmacy, or insurance plan systems. Used in adjudication rules, formulary management, and benefit design configuration to enforce plan-level product limits.

Lower threshold value defining the minimum required quantity, coverage floor, or eligibility criterion for a healthcare product within PBM, pharmacy benefit, or insurance plan systems. Applied in adjudication and formulary logic to enforce plan-level product baseline requirements.

The human-readable display name of a healthcare product such as a drug, medical device, insurance plan, or benefit package. Used in PBM formularies, member enrollment systems, and provider-facing EHR interfaces for identification, reporting, and member communication workflows.

Business-assigned numeric identifier for a healthcare product used in operational workflows and external system integrations. Referenced in PBM, pharmacy, and insurance plan systems to uniquely identify products across billing, formulary management, and partner data exchange processes.

Numeric percentage value associated with a specific product in pharmacy, PBM, or claims systems. Used in benefit calculations, formulary tier cost-sharing, rebate agreements, or discount rate allocations tied to drug or service products.

References the prior product identifier or version associated with a drug, benefit, or service item in PBM, pharmacy, or EHR systems. Used to track product substitutions, formulary changes, or NDC replacements across processing periods.

Numeric quantity value associated with a dispensed or billed product in pharmacy or claims systems. Represents units, tablets, milliliters, or supply days for a drug or medical item, used in adjudication and utilization reporting.

External or internal reference identifier linking a product to a source catalog, formulary, or contract in PBM, pharmacy, or claims systems. Supports cross-system product lookups, NDC mapping, and benefit plan product configuration validation.

Numeric ordering value assigned to a product within a claim line, prescription, or benefit configuration in pharmacy or PBM systems. Differentiates multiple products within a single transaction and supports proper adjudication sequencing and reporting.

Current state of a product record in pharmacy, PBM, or formulary systems. Common values include active, inactive, discontinued, or pending. Drives formulary eligibility, claim adjudication rules, and product availability in dispensing and benefit platforms.

Date and time value recording when a product record was created, updated, or processed in pharmacy, PBM, or claims systems. Supports audit trails, change tracking, adjudication sequencing, and data reconciliation across healthcare data pipelines.

Aggregate monetary or quantity value calculated for a product across claim lines, dispensing events, or benefit periods in PBM or pharmacy systems. Used in financial reporting, rebate calculations, utilization summaries, and formulary performance analytics.

Classification code identifying the category of a product in pharmacy, PBM, or medical claims systems. Common values include brand, generic, specialty, biologic, or DME. Drives formulary tier assignment, cost-sharing rules, and utilization management workflows.

Binary flag indicating whether a prosthetic device record is currently active within the healthcare system. Used in durable medical equipment (DME) claims and member benefit management to determine eligibility for prosthetic coverage, replacement, or ongoing authorization.

Categorical status value describing the current lifecycle state of a prosthetic device record, such as active, inactive, or suspended. Used in DME benefit administration to manage coverage determinations, prior authorization renewals, and member prosthetic entitlement tracking.