Pharmacy

Calculated numeric rating assigned to a medication order in pharmacy analytics and PBM systems, often reflecting adherence likelihood, risk stratification, or formulary compliance. Data engineers use this field in predictive models, member outreach prioritization, and medication management program workflows.

Ordinal number identifying the position of a medication order within a series of prescriptions in EHR and pharmacy systems, used to track fill sequence, refill count, or order iteration. Data engineers use this field to reconstruct therapy timelines and detect gaps in medication adherence datasets.

The date on which a medication order was dispensed, administered, or clinically serviced in pharmacy, PBM, and claims systems. Data engineers use this field as a primary temporal key for adjudication joins, days supply calculations, and longitudinal medication utilization analyses.

Coded or descriptive value indicating the clinical seriousness of the condition driving a medication order in EHR and pharmacy systems. Data engineers use this field to stratify patient populations, support risk adjustment models, and flag high-acuity medication orders for clinical review workflows.

The patient's biological sex recorded in association with a prescription record, used to validate sex-specific dosing guidelines, flag contraindicated medications, and support pharmacy disparity analysis and population health reporting across dispensing data systems.

Identifier capturing the origin system, channel, or provider of a medication order in EHR, pharmacy, and PBM platforms, such as electronic prescribing, fax, or telephonic entry. Data engineers use this field for data provenance tracking, channel attribution, and ingestion pipeline routing logic.

The date on which a medication order becomes active and therapy is intended to begin in EHR, pharmacy, and PBM systems. Data engineers use this field as the anchor point for calculating days supply, therapy duration windows, and medication adherence intervals across longitudinal claims datasets.

The specific clock time at which a medication order or therapy course is designated to begin, particularly relevant in inpatient settings, infusion therapy, and time-sensitive drug protocols where precise administration timing affects therapeutic efficacy and safety outcomes.

The U.S. state or territory associated with a prescription record, typically reflecting the dispensing pharmacy location, prescriber license jurisdiction, or patient mailing address. Used in pharmacy claims processing, controlled substance monitoring programs, and multi-state dispensing compliance.

Current state value of a medication order in pharmacy, PBM, and EHR systems, such as active, discontinued, expired, or on hold. Data engineers use this field to filter actionable records, support medication reconciliation workflows, and track order lifecycle transitions across clinical and adjudication data pipelines.

The street-level mailing or physical address associated with a prescription record, typically the patient's home address for mail-order delivery or the dispensing pharmacy location. Used in specialty pharmacy logistics, patient outreach, and pharmacy claims geographic reporting.

The concentration or potency of active ingredient in a prescribed medication, expressed as a numeric value with unit such as mg, mcg, or mg/mL. A critical dispensing attribute used by pharmacists to verify correct drug preparation, substitution, and dose accuracy in pharmacy systems.

An intermediate cost calculation on a prescription claim representing a portion of the total charge before all adjustments, copays, or plan-level pricing are applied. Used in pharmacy benefit adjudication and member cost-sharing calculations within PBM claims processing systems.

The date of a surgical procedure associated with a prescription record, used when medication orders are directly linked to perioperative care such as pre-surgical antibiotics, post-operative pain management, or anesthesia protocols captured in pharmacy and clinical data systems.

A unique system-generated key assigned to a prescription record within a pharmacy, EHR, or claims platform. Serves as the primary reference for tracking the prescription across dispensing, adjudication, and clinical workflows, enabling data linkage across multiple healthcare information systems.

The destination reference for a medication order in pharmacy and PBM systems, identifying the intended recipient, dispensing location, or therapeutic goal. Used in EHR routing logic and claims adjudication to validate dispensing accuracy and formulary compliance.

The NUCC taxonomy classification code identifying the prescribing clinician's specialty, such as internal medicine or psychiatry. Used in pharmacy claims and medication management systems to validate prescribing authority, support formulary rules, and enable specialty-based drug utilization reporting.

Records the patient's body temperature value documented at the time a medication order is written, supporting clinical decision-making for temperature-sensitive drug therapies such as antipyretics or antibiotics. Used in EHR and clinical data systems to correlate vital signs with prescribing events.

The date a prescription order becomes inactive or expires in pharmacy and PBM systems. Used in EHR and claims processing to halt further dispensing, trigger prior authorization renewals, and support medication adherence tracking and gap-in-care analytics.

The specific time-of-day a medication order was created, transmitted, or dispensed, recorded in EHR, pharmacy, and PBM systems. Critical for auditing controlled substance workflows, reconciling pharmacy transaction logs, and ensuring regulatory timestamp compliance.