Pharmacy

The lower threshold value associated with a drug, such as the minimum effective dose, minimum dispensing quantity, or minimum reimbursable amount. Used in pharmacy benefit management, clinical decision support, and claims adjudication to enforce therapeutic adequacy and coverage floor requirements for a medication.

A data quality artifact resulting from applying a person-level contact attribute to a drug entity. This field does not carry valid meaning in a pharmaceutical data context and should be flagged for removal or reassignment during drug reference data model reviews to prevent data integrity issues.

The identifier of the user or automated process that last updated a drug record within the pharmacy or drug reference system. Used for audit trail and data governance purposes to track changes to drug attributes such as dosage, formulary status, pricing, or regulatory classification over time.

Timestamp recording the most recent update to a drug record in pharmacy, PBM, or EHR systems, used to track formulary changes, dosage updates, or regulatory revisions. Critical for data engineers implementing change data capture, audit logging, and incremental data loads across drug master reference tables in healthcare pipelines.

The timestamp recording when a drug record was most recently updated in the pharmacy or drug reference system. Used in audit logging, data governance, and change management workflows to track modifications to drug attributes including pricing, formulary status, dosing guidelines, and regulatory classifications.

Human-readable label for a drug in compliance and formulary management systems, which may represent the brand name, generic name, or chemical name depending on context. Used across EHR, claims, and PBM platforms for display, reporting, and cross-system drug record matching against standard references like RxNorm or NDC databases.

Free-text or structured annotation attached to a drug record in pharmacy, EHR, or PBM systems, capturing clinical caveats, formulary exceptions, or administrative remarks. Used by data engineers to preserve contextual metadata in drug master tables and to surface relevant clinical or operational comments in downstream reporting systems.

Numeric reference code assigned to a drug within pharmacy and PBM processing systems, used to uniquely identify drug products in formulary databases, dispensing records, and claims transactions. Data engineers use this field to join drug records across prescription, claims, and member benefit tables in healthcare data warehouses.

A data quality artifact resulting from applying a clinical symptom attribute to a drug entity. In pharmaceutical reference data, onset date is not a valid drug-level attribute. This field may be relevant at the prescription or adverse event level and should be reviewed for correct placement in clinical data models.

A data quality artifact resulting from applying a patient vital sign measurement to a drug entity. Oxygen saturation is a patient-level clinical metric and holds no valid meaning as a drug attribute. This field should be reviewed for removal from drug reference data models and corrected in source system mappings.

The total dollar amount reimbursed for a drug on a pharmacy claim, reflecting payments made by the payer, plan, or benefit program after adjudication. Used in pharmacy claims analytics, formulary cost reporting, and drug spend management to track actual financial outlays associated with dispensed medications.

The date on which payment was issued for a pharmacy drug claim following adjudication by the payer or pharmacy benefit manager. Used in pharmacy claims reporting, financial reconciliation, and drug spend analytics to track when reimbursement was completed for dispensed medications under a benefit plan.

Reference to a higher-level drug entity in a hierarchical classification structure within pharmacy or PBM data systems, such as a brand drug serving as the parent to its generic equivalents. Used by data engineers to build drug taxonomy hierarchies, support formulary grouping logic, and enable rollup reporting in healthcare analytics platforms.

Numeric ratio value associated with a drug in healthcare data systems, representing metrics such as generic dispensing rate, ingredient concentration, or plan formulary coverage percentage. Used in PBM, claims, and pharmacy analytics to calculate performance benchmarks, cost-sharing splits, and ingredient-level dosage specifications across drug datasets.

Defined time span associated with a drug record in pharmacy or PBM systems, representing intervals such as days supply, coverage authorization duration, or formulary effective windows. Used by data engineers to enforce date-range logic in claims adjudication, prior authorization processing, and drug utilization reporting pipelines.

Telephone contact number stored within a drug record in pharmacy or PBM data systems, typically associated with the drug manufacturer, poison control reference, or pharmacy support line. Used in healthcare data platforms to facilitate drug recall communications, adverse event reporting, and formulary inquiry routing to appropriate contacts.

The pharmacy benefit plan or formulary tier under which a drug is covered for a member. Used in pharmacy benefit management and claims adjudication to determine coverage rules, cost-sharing obligations, prior authorization requirements, and reimbursement rates applicable to a specific medication within a health plan.

The identifier of the insurance or pharmacy benefit policy under which a drug claim is submitted or adjudicated. Used in pharmacy claims processing and benefit management to link drug dispensing transactions to the applicable coverage terms, formulary rules, and cost-sharing structure of a member's health plan.

The standardized display name selected for a drug in formularies, pharmacy systems, and clinical interfaces, which may differ from the legal or generic name. Used in drug reference databases and pharmacy benefit management to ensure consistent, user-friendly drug identification across prescribing, dispensing, and claims systems.

The monetary value assigned to a drug product, which may represent the wholesale acquisition cost, average wholesale price, or negotiated contract price. Used in pharmacy benefit management, claims adjudication, and formulary analytics to calculate member cost-sharing, reimbursement rates, and total drug expenditure reporting.