Pharmacy Data Assimilation for Accurate Medication Consumption Tracking

Resolve Bottlenecks,
Find Innovative Solutions
Generate 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

VSEngineering 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

Engineering Contradiction:
Improvedata accuracyVSAvoidtime consumption
Core Design Contradiction:
Measurement precisionVSLoss of time

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.

Inventive Principle:
Principle #28Mechanics substitution (Replace mechanical system)

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

Engineering Contradiction:
Improvedata volumeVSAvoidconsumption data accuracy
Core Design Contradiction:
Quantity of substanceVSMeasurement precision

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.

Inventive Principle:
Principle #24Intermediary (Mediator)

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

Engineering Contradiction:
Improveconsumption data accuracyVSAvoidprocessing efficiency
Core Design Contradiction:
Measurement precisionVSProductivity

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.

Inventive Principle:
Principle #10Preliminary action

Data Source

PatentUS7606722B2Method for assimilating and using pharmacy data
Publication Date: 2009.10.20 OMNICARE INC
  • US7606722B2 patent drawing
  • US7606722B2 patent drawing
  • US7606722B2 patent drawing

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.