Pharmacy

Timestamp recording the most recent update made to a medication order record in EHR, pharmacy, or PBM systems. Used in ETL pipelines for incremental data loads, audit logging, and detecting amendments such as quantity changes, prescriber edits, or authorization updates.

The exact date and timestamp when a medication order record was last updated in the pharmacy or clinical system. Used in audit trail logging to track prescription changes such as dose adjustments, quantity modifications, refill authorizations, or clinical status updates for compliance and safety review.

Display name for a prescription in pharmacy and EHR systems, typically capturing the drug brand or generic label, strength, and form. Used by data engineers to standardize medication naming across PBM, claims, and clinical data pipelines.

Free-text annotation attached to a medication order in EHR and pharmacy systems, capturing pharmacist instructions, clinical warnings, or dispensing remarks. Critical for data engineers reconciling structured and unstructured medication data across PBM and clinical platforms.

Unique business identifier assigned to a prescription for operational and external reference in pharmacy, PBM, and claims systems. Data engineers use this key to link dispensing records, adjudication events, and refill transactions across downstream data pipelines.

The date on which the patient's condition or symptoms began that led to the medication order being written. Used in pharmacy and clinical documentation to establish medical necessity, support prior authorization requests, and correlate treatment initiation with the clinical timeline of the diagnosed condition.

The patient's peripheral blood oxygen saturation level recorded at the time of or in association with a medication order. Used in clinical documentation for respiratory medications, home oxygen prescriptions, and conditions like COPD or heart failure where SpO2 values inform dosing decisions and medical necessity.

The total dollar amount actually paid for a dispensed medication order after plan benefits, copays, and adjustments are applied. Used in pharmacy claims adjudication and financial reconciliation to record net reimbursement to the dispensing pharmacy from payers, patients, or pharmacy benefit managers.

The date on which payment was processed and remitted for a dispensed medication order. Used in pharmacy billing and accounts receivable systems to track cash flow, reconcile pharmacy claims against explanation of benefits remittances, and identify outstanding or denied prescription claims.

Identifier linking a medication order to its originating or superior prescription record in EHR and PBM systems, enabling tracking of refills, substitutions, and order hierarchies. Essential for data engineers modeling medication lineage and continuity of therapy workflows.

The percentage value associated with a prescription cost sharing or reimbursement calculation in a pharmacy benefit plan. Used in PBM claims adjudication to calculate coinsurance amounts, generic substitution rates, and formulary tier cost sharing percentages applied to prescription drug claims.

The defined time span during which a medication order is valid and active in pharmacy, PBM, and EHR systems, typically bounded by fill date and days supply. Data engineers use this field to calculate therapy gaps, overlap windows, and adherence metrics in analytics pipelines.

Telephone contact number associated with a medication order in pharmacy and EHR systems, typically referencing the prescribing provider, pharmacy location, or patient callback number. Data engineers use this field for provider directory matching and outreach workflow integrations.

The pharmacy benefit plan or treatment protocol associated with a medication order, identifying the coverage plan under which the prescription will be adjudicated. Used in pharmacy benefit management systems to apply correct formulary rules, tier pricing, copay structures, and coverage limitations during claims processing.

The insurance policy identifier associated with the patient's pharmacy benefit coverage at the time a medication order is dispensed. Used during pharmacy claims adjudication to route the claim to the correct payer, apply the appropriate benefit structure, and validate member eligibility for drug coverage.

The patient's preferred or chosen name associated with a medication order, used in pharmacy systems to personalize dispensing labels, patient communications, and medication counseling interactions. Supports inclusive care practices by allowing use of a name other than the patient's legal name in pharmacy workflows.

A reference to the prior version or fill of a prescription record in a pharmacy data system. Used in prescription refill management and claims reconciliation to track prescription history, link refills to original prescriptions, and support prior authorization renewal workflows.

The retail or negotiated cost of a dispensed medication order before insurance benefits are applied, representing the pharmacy's submitted charge. Used in pharmacy claims processing, formulary management, and drug cost transparency reporting to evaluate medication affordability and plan cost exposure.

A flag designating whether a medication order represents the patient's primary active prescription for a given drug or therapeutic category. Used in pharmacy management systems to distinguish the principal medication from duplicates, alternatives, or secondary fills during drug utilization review and medication reconciliation.

Categorical ranking indicating the urgency or clinical importance of a medication order in EHR and pharmacy systems, such as STAT, urgent, or routine. Data engineers use this field to drive workflow prioritization logic and SLA monitoring in dispensing and clinical operations pipelines.