Pharmacy

The unique identifier of the user, clinician, or system that originally entered the prescription order into the pharmacy or clinical information system. Used in audit trails and workflow accountability to track order origination and support compliance reviews within medication management systems.

Timestamp indicating when a prescription record was first written to the database in EHR, pharmacy, or PBM systems. Critical for data lineage, audit trails, and distinguishing record creation from prescription written date or dispense date in claims processing.

The timestamp recording the exact time a prescription order was entered or generated in the pharmacy or clinical system. Used in pharmacy workflow analytics to measure order processing intervals, identify bottlenecks in the dispensing cycle, and support medication turnaround time auditing.

The serum creatinine lab value associated with a patient at the time of prescribing, used to assess kidney function and guide dosing decisions for renally cleared medications. Captured in clinical pharmacy systems to support dose adjustment protocols and prevent adverse drug events in patients with impaired renal function.

A flag or indicator identifying the most recent or active version of a prescription record in a pharmacy data system. Used in prescription data warehouses implementing slowly changing dimension patterns to distinguish current prescription information from historical fill and refill records.

Calendar date on which a medication order was written or issued by a prescriber. Used in pharmacy dispensing systems, PBM claims adjudication, and EHR platforms to validate fill timing, days supply calculations, and refill eligibility windows.

Combined date and timestamp capturing the exact moment a medication order was created or processed. Used in EHR, pharmacy dispensing, and PBM systems to sequence events, resolve duplicate claims, and support time-sensitive clinical decision alerts.

The Drug Enforcement Administration registration number assigned to the prescribing clinician authorizing a controlled substance order. Required by federal law on prescriptions for Schedule II-V medications, used in pharmacy dispensing systems to validate prescriber authority and support DEA compliance reporting.

Date of patient death recorded in association with an active or recent prescription record. Used in EHR and PBM systems to halt refill processing, trigger member disenrollment workflows, and flag open prescription records for closure in pharmacy systems.

The dollar amount applied to a member's pharmacy deductible for a specific prescription claim before plan coverage begins. Captured during pharmacy claims adjudication to track member accumulation toward their annual deductible threshold and calculate remaining plan financial liability under the pharmacy benefit.

The calendar date on which a prescription record was removed or voided from the active pharmacy system. Used in pharmacy data management and audit tracking to maintain a historical record of order cancellations, discontinuations, or data corrections, supporting regulatory compliance and medication safety reviews.

A flag that identifies whether a prescription record has been voided, cancelled, or logically removed from active processing in the pharmacy system. Used in data integrity workflows to exclude invalid records from claims adjudication, utilization reporting, and member medication history displays without purging the underlying audit trail.

Free-text or structured narrative describing the medication order, including drug name, strength, dosage form, or clinical indication. Used in EHR and pharmacy systems for display, reporting, and mapping to standard drug codes like NDC or RxNorm in PBM pipelines.

Granular data elements associated with a medication order, including drug name, strength, quantity, days supply, refills authorized, and prescriber information. Used in PBM adjudication, pharmacy dispensing systems, and EHR platforms for complete clinical and billing context.

Date a patient was released from an inpatient or outpatient facility, associated with a medication order initiated during that stay. Used in EHR and pharmacy systems to validate transition-of-care prescriptions and coordinate post-discharge PBM claims adjudication.

A state-administered electronic database tracking controlled substance prescriptions dispensed to patients, used by prescribers and pharmacists to identify patients receiving controlled substances from multiple prescribers or pharmacies, detect patterns of drug diversion or misuse, and support clinical decision-making in pain management. Most states mandate PDMP query before prescribing or dispensing Schedule II controlled substances.

The date by which a prescription is expected to be filled, refilled, or picked up based on the days supply of the previous dispensing. Used in pharmacy management systems to drive refill reminder workflows, identify non-adherent members, and support medication synchronization programs within retail and specialty pharmacy operations.

The total number of days a prescribed medication regimen is intended to cover, as specified by the prescribing clinician. Used in pharmacy benefit management and clinical systems to calculate days supply, assess medication adherence, determine refill eligibility, and evaluate appropriateness of therapy length for specific conditions.

The date on which a prescription record or coverage authorization becomes active in a pharmacy or PBM data system. Used in prescription benefit management and prior authorization tracking to determine when drug coverage begins and whether a prescription is eligible for reimbursement.

Date on which a medication order becomes valid for dispensing or claims adjudication. Used in PBM and pharmacy systems to enforce fill windows, prevent early dispense, and align prescription validity with member enrollment effective dates in claims processing.