Pharmacy Data Assimilation for Accurate Medication Consumption Tracking
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Publicly-held Corporate Pharmacies face challenges in accurately tracking and analyzing medication consumption data due to partial prescription fulfillments, returns, and multiple transaction variables, leading to errors and inefficiencies in cost negotiation and decision-making processes.
Innovation Solution
A method to correlate and match transaction records for accurate computation of medication dispensing and usage data, consolidating patterns and exceptions to establish logical rules for calculating actual consumption, reducing the need for continuous transaction correlation and enhancing data analysis for medical and economic insights.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Measurement precision
If manual extraction of dispensing and usage data is performed, then data can be obtained from pharmacy transaction records, but the process is time-consuming and labor-intensive
Solution Approach 1:
The patent replaces manual mechanical data extraction with an automated computerized system that retrieves, correlates, and processes pharmacy transaction records electronically. The system automatically matches transactions to prescriptions and calculates consumption data without human intervention, eliminating the time-consuming manual process while maintaining data accuracy.
2Quantity of substance
If individual transaction records are summed to compute consumption data, then data can be aggregated from multiple transactions, but errors are magnified when large numbers of transactions are involved
Solution Approach 1:
The patent introduces an intermediary correlation process that matches transactions to prescriptions before aggregation. The system uses prescription identification numbers and other linking data to properly associate transactions with their corresponding prescriptions, serving as an intermediary step that prevents erroneous summation and ensures accurate consumption calculation even with large transaction volumes.
3Measurement precision
If continuous correlation of transactions to prescriptions is performed, then accurate consumption data can be obtained, but the process is computationally intensive and time-consuming
Solution Approach 1:
The patent performs preliminary actions by pre-establishing the correlation framework and matching logic before full data processing. The system sets up the transaction-prescription matching structure in advance, allowing subsequent consumption calculations to be performed efficiently using the pre-established relationships rather than continuously correlating all transactions, thus improving processing efficiency while maintaining accuracy.
Data Source
AI summary
A method for assimilating and using pharmacy data to determine actual consumption of medications from particular sources, such as pharmaceutical companies. Transaction records are accumulated and correlated, and medication dispensing and usage data is extracted to determine actual consumption information. In an alternate embodiment, the transaction records and dispensing data are examined for identifiable usage patterns. The patterns form the basis for a set of rules that can then be used to calculate actual consumption data from transaction records.


