Pharmacy

The fixed out-of-pocket dollar amount a member owes per covered service visit as stipulated within their insurance policy agreement. This cost-sharing value is established at policy issuance and governs member financial responsibility during medical claims adjudication and benefit administration.

The member cost-sharing dollar amount associated with services requiring prior authorization before care is rendered. This copay is applied when precertification is obtained and influences downstream claims adjudication, ensuring patient financial responsibility is captured for pre-approved procedures or specialist referrals.

A subset of drugs within a formulary that receive preferred cost-sharing status due to clinical equivalence to non-preferred alternatives combined with favorable pricing from manufacturer rebate negotiations, used in formulary design to channel member and prescriber utilization toward cost-effective therapeutic options. Preferred drug lists are common in Medicaid managed care and commercial pharmacy benefits.

The unique identifier assigned to a member's pharmacy benefit account, used to link prescription drug claims to the correct plan sponsor and benefit structure. This number enables pharmacies, PBMs, and payers to accurately adjudicate drug claims and track medication utilization across dispensing events.

A binary flag indicating whether a prescription is currently active and eligible for dispensing. Used in pharmacy benefit management systems to control refill eligibility, prevent dispensing of discontinued or expired orders, and support medication reconciliation workflows across clinical and claims environments.

A coded value representing the current lifecycle state of a prescription, such as active, suspended, discontinued, or expired. Used in pharmacy management systems to control dispensing eligibility, support medication adherence monitoring, and ensure accurate representation of a patient's current medication regimen.

Physical location field associated with a medication order in pharmacy management and PBM systems, capturing patient or delivery address used for mail-order routing, fraud detection, and jurisdiction-based dispensing compliance. Data engineers use this field to validate address standardization, match member records, and support specialty pharmacy shipment tracking.

The dollar value applied to modify the original prescription drug claim amount following repricing, formulary changes, DIR fees, or payer contract reconciliation. This adjustment is recorded in pharmacy claims processing to reflect the net reimbursement difference between the submitted charge and the adjudicated allowable amount.

Date field in pharmacy and EHR systems representing the hospital or facility admission date associated with an inpatient medication order. Data engineers use this timestamp to correlate pharmacy claims with institutional encounters, support discharge medication reconciliation workflows, and validate billing alignment between pharmacy and facility claims records.

The patient's age at the time a prescription was written or dispensed, captured in pharmacy claims and medication management systems. This value supports age-based clinical decision support, pediatric dosing validation, formulary eligibility checks, and regulatory compliance for controlled substance dispensing limits.

The maximum dollar amount a payer or pharmacy benefit manager will reimburse for a dispensed drug, based on contracted rates, MAC pricing, or formulary schedules. This value drives pharmacy claim adjudication and determines the split between plan payment and member cost-sharing obligations.

Numeric field in pharmacy claims and PBM adjudication systems representing the monetary value associated with a dispensed medication order, including ingredient cost, dispensing fees, or patient liability components. Data engineers use this field in cost analysis, rebate calculations, member cost-sharing validation, and financial reconciliation pipelines.

A coded value indicating whether a prescription or associated prior authorization request has been approved, denied, or pended by the payer or clinical review team. This status governs whether a pharmacy can proceed with dispensing and is critical for managing formulary exceptions and specialty drug access workflows.

The identifier or name of the clinician, pharmacist, or authorized reviewer who approved a prescription or prior authorization request. Captured in pharmacy and utilization management systems to maintain an audit trail of prescribing authority, formulary exceptions, and controlled substance approval accountability.

The recorded time at which a prescription order was received at the dispensing pharmacy or fulfillment center. Used in pharmacy workflow management to track order processing timelines, measure turnaround efficiency, prioritize dispensing queues, and meet regulatory or accreditation requirements for medication dispensing timeliness.

The calendar date on which a prescription was received at the dispensing pharmacy or mail-order fulfillment center. Used in pharmacy operations and claims processing to establish order receipt timelines, calculate days-to-dispense metrics, and support audit and compliance documentation for controlled substance tracking.

The clinical evaluation or pharmacist review notes associated with a prescription order, documenting appropriateness of therapy, drug interactions, dosing considerations, or formulary alternatives. Captured in pharmacy management and clinical systems to support medication therapy management, prior authorization decisions, and patient safety reviews.

The calculated mean value of prescription metrics such as average cost per prescription, average days supply, or average copay across a defined member population or time period. Used in PBM analytics, drug utilization reporting, and pharmacy benefit cost trend analysis.

Outstanding patient financial liability amount recorded in pharmacy billing and PBM systems after insurance adjudication is applied to a medication order. Data engineers use this field to calculate member cost-sharing, identify unpaid claim balances, reconcile accounts receivable, and support pharmacy revenue cycle management reporting workflows.

A pharmacy benefit manager is a third-party entity that administers prescription drug benefits on behalf of health insurers, self-insured employers, and government health programs, managing formularies, negotiating drug pricing with manufacturers and pharmacies, and processing pharmacy claims. In healthcare data architecture, the PBM identifier links pharmacy claims to the administering entity and is critical for pharmacy data pipelines where PBM adjudicated claims feed separately from medical claims into an integrated data warehouse. Understanding PBM data structures is essential for healthcare data engineers working on integrated medical-pharmacy analytics and total cost of care modeling.