ReportPlus: rapid access to medicines information

ReportPlus:Advanced ReportingThere is an inevitability that the requirements for cost management in NHS Hospital Trusts and providing information to Primary Care Organisations (and other external organisations e.g. Healthcare at home) will increase for pharmacy over the coming years.

Medicine stock is the 2nd largest expenditure budget in a hospital after staff costs. Add to this the cost of the many man-hours spent managing and auditing medicines across an NHS Trust and the value of high quality reporting quickly escalates.

One of the key issues that hospitals face in this area is the complex nature of collecting and analysing medicines information. For most Trusts, the detailed analysis and interpretation – required before the information can be used to inform practice – takes both considerable time and clinical expertise.

So, while there are clear incentives to monitor and analyse medicines data, few hospitals would choose to divert clinical experts from front-line patient care to perform this time consuming yet critical work. These issues are easily overcome through the use of ReportPlus; an advanced reporting module which provides a rapid, easy to use view of medicines costs, usage and budgets for hospitals using JAC’s Pharmacy Management system.

Developed by JAC and Rx-Info, ReportPlus delivers detailed and graphical reports on medicine usage and costs for hospital pharmacies using the JAC system – providing pharmacy and finance departments with access to core clinical and financial reports via a simple interface. ReportPlus is a system that not only reduces the time to complete reporting tasks but also allows Finance departments to review fiscal data without Pharmacy’s intervention.

The module’s clinical and financial reports can be run to take into account the entire organisation or specified for a Hospital, Directorate or Cost Centre as required by the user. The time taken to generate the reports is dramatically reduced and the system allows staff with a basic computer knowledge and skills to produce the reports they require.

The information can be shared with other stake-holders who require drug usage information in both graphical or data table format via a number of export options including Microsoft Excel, pre-formatted printed reports and PDF. The electronic formats can also be emailed from within the module giving Trusts a quick and simple way to share the information.

Key Benefits

  • Improves access to financial and clinical data.
  • Improves ability to manage drug costs.
  • Speeds up the provision of Government required information.
  • Improves ability to recharge drug costs from other organisations.
  • Saves finance departments’ time spent budget monitoring.
  • Identifies spend hotspots (by month, drug or cost centre).
  • Improves ability to identify other issues and risks to the organisation.
  • Aids practice change through accessible and accurate clinical data.
  • Simple distribution of reports to clinical and financial stakeholders.

ReportPlus reports on:

  • Top n drug spend
  • BNF costs to Chapter, Section, Paragraph, Sub Paragraph
  • Drug cost and use tracking
  • Budget position by Directorate and Cost Centre
  • Rolling 12 month growth rate
  • Formulary adherence
  • Payment by Results exempt drugs
  • NICE & SCEP
  • Unlicensed drugs
  • Clinical Trials
  • HIV budget
  • Controlled Drugs
  • Antibiotic usage (including DDD by month data)
  • Injectable to non-injectable antibiotic usage and costs
  • Specialist Treatments (e.g. Consultant use only)
  • Drug cost growth monitoring (month on month analysis to identify price hikes)
  • Cost modelling
  • Review of raw data file
  • ReportPlus includes WHO DDD data for detailed drug analyses.

Key Features

Budget management

Allocation and reporting on budget activity at ward and directorate level

Clinical data generation

View of cost and volume distributions of drugs at ward level. Standard review of high volume and spend items as well as usage of formulary and usage and volume of antibiotics. The report charts offer click-through drill down to more detailed, underlying data.

Bespoke reporting of therapeutic areas

The system is fully flexible allowing the user to generate reports giving detailed analysis of issues by directorate or ward. The data also generates Defined Daily Dose (DDD) information to review therapeutic groups.

Identification of high cost / financial risk / clinical risk areas

Examples of the risk areas included are: Unlicensed drug monitoring, NICE drugs usage, non-PbR drugs for recharge, specialist drugs and shared care drugs to assist in budget management.

Individual drug cost or usage tracking

Monitoring of drug usage over time to show changes in usage or cost at directorate or ward level. This is useful in reviewing trends over time including purchase costs of drugs or identifying diversion of medication.

Cost modelling

The user can model the cost impact or anticipated saving of using an alternative drug from the same BNF class. The system also runs a check of high cost increases in the last month to identify any cost hikes at an early stage.

Information distribution

Data sharing is provided for by the use of printed reports and also email (in PDF format) from the application. The user can also export the data tables to a spreadsheet format as required.

Data maintenance and update interface

The monthly data maintenance load is easy to run and with the system requesting clarification of items it is unsure of so that the data is rapidly kept up to date for all users.

Read More

Leave a Comment