Partner with us
Case study · 03
A comprehensive platform that takes a medicinal product from first authorisation request through every variation, renewal and revocation, keeping the national authority and the European Medicines Agency in lockstep, without spreadsheets.
Impact
By cross-referencing sales volumes, clinical prescriptions, and medicinal registry databases, the platform turns complex data streams into a single, cohesive operational picture. Regulators and agencies can instantly track the flow of medicines through the animal health market, verify coverage, and identify reporting discrepancies without the lag or overhead of manual spreadsheet reconciliation.
Flow
Market-wide distribution
Provides end-to-end visibility into the movement of medicines, tracking products from wholesale sales down to veterinarian prescription.
100%
Substance reconciliation
Ensures every active substance and pack size in active circulation maps precisely to the national reference registry.
Real-time
Discrepancy detection
Instantly flags volume mismatches between manufacturer sales data and veterinarian-emitted prescriptions.
ASUA Vet
Consumption reporting
Automates compliance reporting into ASUA Vet and other national surveillance systems directly from the reconciled dataset.
Challenge
Single-source antimicrobial reporting (ESVAC, MA Holder sales returns, prescription records) each tells a partial story. Sales data shows what entered the market. Prescription data shows what was clinically intended. Neither alone reveals what is missing, mis-recorded, or diverted. Regulators need to reconcile these streams to build a credible national picture.
Approach
In Portugal, OneAiQ's infrastructure enables DGAV to cross-reference three datasets, ESVAC, MA Holder-reported sales, and PEMV prescription and administration records, to validate coverage and detect gaps. The same integrated foundation supports disease-cluster analysis, production-stage stratification, regional benchmarking, and the indication framework (cascade, prophylactic, metaphylactic, condition-specific).
01 · Data integration
Cross-references three separate datasets to validate national coverage, detect reporting gaps, and identify diversions.
02 · Market flow mapping
Maps the distribution path of veterinary medicines, visualizing how wholesale sales volumes transition into clinical prescriptions and actual farm administrations.
03 · Automated matching
Automatically aligns raw market data with the national reference database, ensuring active substances, package formats, and product classes are 100% harmonized.
04 · Regulatory reporting
Aggregates cleansed, matched data into compliant national consumption reports and direct feeds into databases like ASUA Vet and ESVAC without manual consolidation.
Stewardship becomes operational, not aspirational, when sales, prescriptions, and administrations are reconciled in the same data space. Each dataset on its own is suggestive. Together they are evidentiary, and that is the threshold at which regulators can act with confidence.
More case studies
Get in touch
True stewardship operates at the intersection of veterinary sales, active prescriptions, and farm-level administrations. If your agency is seeking to integrate disparate data streams into a unified cross-system surveillance platform, contact us to explore our integration frameworks.
