Skip to content

Optimising medication procurement through integrated database

Pdf

PDF Icon

European Statement

Selection, Procurement and Distribution

Author(s)

Irene Ruiz-Jarabo Gómez, Marcos Gómez Bermejo, Rocío Vázquez Sánchez, Antonio Illescas Bermudez, Elena Martín Suarez, Teresa Molina García

Why was it done?

Digitization was considered essential in reducing costs related to inventory management and improving responsiveness in critical situations, such as supply shortages. Traditional manual inventory checks and order verifications were time-consuming and error-prone, prompting the need for a digital transformation.

What was done?

In our quest for enhanced medication procurement efficiency within our Hospital Pharmacy Service, we have developed an integrated database.

How was it done?

We have developed a database by consolidating data from two primary sources: our automated medication storage system, Smart Ulises®, and the Economic Management software, Farmatools®. This database encompassed information related to medications falling below predefined minimum stock levels, historical acquisition records, pending medication orders, and warehouse capacities for each medication. Additionally, it seamlessly integrated data obtained from the Spanish Agency of Medicines and Medical Devices (AEMPS) regarding medication shortages.
This database enabled several essential functionalities:
It generates reports suggesting orders for medications below the minimum stock levels, recommending quantities based on historical acquisitions and available storage space.
By considering the suppliers for medications at minimum stock levels, it also identifies medications in alert status (1/3 above the minimum stock) for these suppliers.
Cross-referencing with AEMPS’ medication supply problem database swiftly detects critical medications during shortages
It permits agile identification of pending medication orders.
It identifies locations with incomplete medication inventories and propose medication grouping within our automated medication storage system.

What has been achieved?

The outcomes of our project were transformative:
  We streamlined medication procurement significantly and maximized each medication supply request while promoting sustainability by reducing laboratory-specific medication orders.
  We optimized storage space within our automated medication storage system, aligning medication orders precisely with storage capacities for each medication, leading to more efficient space utilization and reduced storage costs.
  Early detection of medication shortages enabled proactive preparation of alternative solutions to effectively mitigate shortages.
  Simplification of tracking pending medication orders enhanced operational efficiency in claim processing or supplier changes.

What next?

Our next phase focuses on continuous system improvement. This involves incorporating additional data sources to refine medication supply predictions and exploring the potential for complete automation of the medication ordering process. We will also enhance performance measurement to evaluate the effectiveness of our improvements.

Too good to go – sharing medication near expiry with a digital solution

Pdf

PDF Icon

European Statement

Clinical Pharmacy Services

Author(s)

Charlotte Sørensen, Karin Aagot Møller Jørgensen, Anne Grethe Nørgaard Kyndi, Charlotte Lund Madsen, Line Scriver Poulsen, Charlotte Hjorth, Gitte Slyngborg Morbjerg, Janni Østergaard Jensen, Mette Juul-Gregersen, Rune Dalsenni Rask

Why was it done?

A sustainability project in 2020 highlighted manual and time-consuming workflows when checking expiry dates in hospital medicine rooms. For example, manual reading, interpretation and notation of expiry dates in paper forms every half year. Therefore, a smartphone application was developed and implemented in a large university hospital in 2022. The application was a huge success and colleagues from other Clinical Pharmacy departments in other hospitals within the same region wanted to be part of the success of the initiative.

What was done?

A smartphone application for managing expiry dates in medicine rooms was applied in one hospital in 2022 and in four other hospitals in 2023. The data-matrix of medicine packages is scanned with a smartphone camera and the application gives a sorted overview of medication near expiry. In the application you can register a medicine package as either used, discarded or released. By releasing medicine packages, the medicine is made available to colleagues in other medicine rooms.

How was it done?

The smartphone application was implemented in Clinical Pharmacy departments in four other hospitals, one by one from February 2023. After implementation the application is used in 373 medicine rooms.

What has been achieved?

Clinical Pharmacy staff are happy with the application. It takes significantly less time to check and scan expiry dates with the digital solution.
From February to September 2023 (five hospitals)
• 47491 packages were scanned
• 5251 packages were released (11%)
• 2664 packages were moved between medicine rooms to avoid medicine wastage (51%; 147000 €). Most activity (78%) was seen at the hospital that had been using the application since 2022. Most packages were moved between medicine rooms at the same hospital; however, in 215 cases (8%), medicines were exchanged between hospitals as well (20.000 €)
• 10918 packages were discarded due to expiry (743168 €; 0.5% of bought medicine).

What next?

The full potential of the digital solution remains to be achieved.
Pharmaconomists have to release medicine in the application a few months earlier than they do now. To go shopping in the application before ordering from the pharmacy, will probably also result in discarding less medicine. Sharing medication across hospitals to a greater extent will also be relevant to consider.

Implementation in a pharmacy service of a big data analysis programme for successful treatment

Pdf

PDF Icon

European Statement

Patient Safety and Quality Assurance

Author(s)

LUCIA SOPENA, ALBERTO FRUTOS, VICENTE GIMENO, OLGA PEREIRA, RAQUEL FRESQUET, ARITZ MERCHAN, REYES GARCIA, PAULA GOMEZ, ALBERTO APESTEGUIA, MARIA ANGELES ALLENDE, TRANSITO SALVADOR

Why was it done?

The growing technological development of pharmacy services involves the coexistence of traditional warehouses with automated medicine dispensing systems controlled by different computer programs. The information is split into different systems and databases giving rise to possible errors due to the greater complexity. This is a threat but also an opportunity for the hospital pharmacist to lead the development, review, and improvement of medicine use processes and the use of health technologies to improve quality of care, patients’ safety and reduce costs. KNIME data analysis covered the need of our Pharmacy Service to blend data from any source in a single file simplifying the process.

What was done?

The Pharmacy Service of a university hospital has implemented Konstanz Information Miner (KNIME) data analysis and develop successful treatment project to optimise the stock management of several medicines.

How was it done?

An initial algorithm was designed by the union of seven files and can be executed at any time to obtain the updated data.

What has been achieved?

This file provides up-to-date information about the stocks, stock-outs, consumptions, orders and purchasing data of all medicines (average price, laboratory, date and number of orders, units to be received).
In addition, KNIME calculated the coverage time in days and months from weekly and monthly consumption, and the current stock in the warehouses, obtaining a global vision of highest turnaround pharmaceuticals drugs.
The program also allows to link and merge data of the list for shortages of medicines, supply disruptions and restocking time, and to improve the storing, delivering and administering of COVID-19 vaccines.
KNIME program has been especially important in our Pharmacy Service to get better care outcomes and more precise medication ordering, which allows significantly higher patient safety.

What next?

KNIME is a tool that could be successfully implemented and appropriately generalised as recommended to all Pharmacy Services that use different data sources and want to have a generalised view of the information. KNIME represents an advance in the stock and purchase management of medicines specialties to work more efficiently, which improve patient care and safety. Digital medication management also contributes to greener pharmacies by preventing unnecessary overstocking and thus excessive disposal arising from expired medications.

TELEMEDICINE AND HOMEDELIVERY: MANAGEMENT OF THERAPEUTIC CONTINUITY IN THE PANDEMIC ERA.

Pdf

PDF Icon

European Statement

Clinical Pharmacy Services

Author(s)

Marta Del Vecchio, Federica Chinotti , Claudia Lauria Pantano, Elirosa Minniti, Erika Cataldo, Francesco Guidoni, Vito Ladisa

Why was it done?

The Severe Acute Respiratory Syndrome – Coronavirus – 2 (SARS-CoV-2 ) pandemic made it difficult to monitor the patient’s health condition because many of them were locked down at home, unable to attend routine hospital visits.

What was done?

The hospital pharmacist, focusing on therapeutic continuity, closely collaborated with the clinicians in monitoring patient’s condition using telemedicine and homedelivery services.

How was it done?

In the multidisciplinary team, the pharmacist and the clinician defined the criteria to choose the most suitable patients for the homedelivery service. One of the options was to dispense the drug in a neighboring hospital. Because of the sanitary system regionalization, some of those hospitals could have been located even more than 100 km away, resulting in a problem for the most critical patients. In order to help them, home delivery and telemedicine services has been considered. The clinician used to visit patients on digital platforms, making clinical evaluations based on the results of blood tests, diagnostic tests and imaging techniques. According to clinician’s indications, the pharmacist took contact with patients, in first to collect informations about any residual storage of the drugs, adverse reactions, therapeutic compliance and then to proceed with the delivery. Everything has been done in conformity with the General data protection regulation (GDPR).

What has been achieved?

From March to September 2020, the homedlivery service count 501 speditions all over the Nation, 480 patients has been contacted to recive therapy and 250 of them has been intensively monitored by calling to manage their follow up. Everything has been done in order to protect critical patients from pandemic, safeguarding the therapeutic continuity,in compliance with pharmacovigilance, risk managment and cost saving for the national health system, considering that the suspension of therapies could be considered an additional and not quantifiable cost, but certainly important.

What next?

The hospital pharmacist must collaborate ever more with the clinician even in the post-pandemic phase, remotely managing not only the most weak patients, but extending the telemedicine and homedelivery services to an increasing number of patients, in order to safeguard their health .

DEVELOPMENT OF AN IT TOOL TO ESTIMATE THE THERAPEUTIC NEEDS OFHOSPITALISED PATIENTS WITH COVID19 INFECTION BASED ON SIR EPIDEMIOLOGICALMODEL

Pdf

PDF Icon

European Statement

Selection, Procurement and Distribution

Author(s)

Daniele Leonardi Vinci, Adriano Meccio , Alessio Provenzani, Piera Polidori

Why was it done?

The COVID 19 pandemic unprecedently challenged National Health Services to assure adequate patient care, despite a constantly escalating drugs demand. This complex situation requires appropriate planning to avoid misleading estimations, which would have consequences on patients and overall resources available.

What was done?

We created a tool to perform a timely estimation of the drug needs to treat the COVID-patients based on epidemiological forecasting.

How was it done?

The tool’s epidemiological forecasting was based on a compartmental model in which the population is divided into three compartments (Susceptible-Infectious-Removed, SIR), and transmission parameters are specified to define the rate at which persons move between stages. The appropriate data entry was guaranteed by the creation of a form in which users can enter information regarding: The population considered, the R0 calculation, the number of already known infected cases, the application of Non-Pharmaceutical Interventions and the number of hospital beds. The drugs need for the forecasted patients was calculated according to a list of critical care drugs compiled consulting previous published scientific works, national and international guidelines. The list includes 51 drugs belonging to different therapeutic group, such as: antiarrhythmics, antibiotics, antipyretics, antivirals, heparins, IV-fluids, local anesthetics, neuromuscular blockade agents, sedative agents and vasopressors. For each drug it was estimated the percentage average ICU uptake for therapeutic group and active principle.

What has been achieved?

A tool consisting of an excel template, that, based on the information inserted, automatically calculate the number of patients classified by the intensity of care (hospitalized not-ICU, Hospitalized ICU, ventilated, intubated or with shock) and creates a table that includes, for each drug to be used, the following information: therapeutic group, active principle, dosage considered, pharmaceutical form, total dosage for patients considered and total quantity of unit doses for patients considered. The tool is also made adaptable to different clinical situations, through the possibility of editing the assumptions adopted regarding the epidemiological and therapeutical parameters or the inclusion of new items in the drugs list.

What next?

Our tool represents an opportunity for the immediate and efficient estimation of the drugs necessary to assist the COVID19 patients during emergency scenarios. It will be periodically updated as new evidences will be available.

DEVELOPMENT OF AN INFORMATIC HAZARD VULNERABILITY ANALYSIS TOOL TO MINIMISE MEDICINES SHORTAGES (submitted in 2019)

Pdf

PDF Icon

European Statement

Selection, Procurement and Distribution

Author(s)

Daniele Leonardi Vinci, Enrica Di Martino, Rosario Giammona, Piera Polidori

Why was it done?

The 2018 Medicines Shortages Survey conducted by EAHP showed that 91% of responding pharmacists had experienced problems sourcing medicines, therefore it is important to use tools that identify early the shortage risk associated with each drug included in a hospital formulary in order to adopt appropriate countermeasures.

What was done?

We create an informatic HVA Tool (HVAT) to assess the risk associated with medicine shortage.

How was it done?

The HVAT created consists of an Excel spreadsheet subdivided into three macro areas: probability that the shortage will occur based on shortage in the last 2 years, magnitude factors which increase the risk of shortage, and mitigation factors which reduce it. A score was assigned to each item in each macro area. The score of the probability was: 1=no previous deficiency; 1.5=one deficiency; 2=two or more deficiencies. Magnitude was divided into: relevance of active substance (AS) (1= not life-saving and not High Risk Medicines (HRM); 2=not life-saving but HRM; 3=life-saving); budget impact (0=no alternative drug; 1=alternative drug costs equal to or less than the deficient one; 2=cost of the alternative drug higher than the deficient one but sustainable for all patients; 3=cost not sustainable for all patients); percentage of patients treated with the drug (1=less than 20%; 2=from 20% to 50%; 3=more than 50%). Mitigation factors were: therapeutic alternative (1=same AS and same route; 1.5=same AS and different route; 2=different AS and route not intravenous (IV); 2.5=different AS and route IV; 3=no alternative drug); stock available (1=for a month of autonomy; 2= autonomy between 1 week and one month; 3=autonomy less than 1 week); availability of the drug (1=drug available in EU; 2=drug available exclusively extra-EU; 3=drug not available).

What has been achieved?

The HVAT obtained allows us to calculate the value of the risk multiplying P by S, where P is the percentage of probability (value of probability obtained/2) and S is percentage of severity [(sum of values of magnitude obtained + sum of values of mitigation obtained)/18]. Based on the score obtained, drugs are classified as: low (60%) risk of shortage.

What next?

We will implement the HVAT in our hospital in order to reduce the impact of shortages.

SOFTWARE TOOL DEVELOPMENT FOR THE ASSISTANCE OF HOSPITAL PHARMACISTS IN MEDICINES’ SHORTAGES MANAGEMENT (submitted in 2019)

Pdf

PDF Icon

European Statement

Introductory Statements and Governance

Author(s)

Eleni Rinaki, Marinos Petrongonas, Maria Fragiadaki, Leonidas Tzimis

Why was it done?

MSs are a frequent problem in our hospital. In a study carried out in 2018, we investigated reported shortages during one year and found that 56% of cases of unsatisfied wards’ requests were due to failure of pharmacy’s procedures to restore availability. In 70% of these cases, time to re-stock was more than 4 days and strong involvement of HPs in following up and taking measures was required. The purpose of this tool is to bring together all relevant information of shortages, aiming to improve hospital pharmacy’s response as well as following-up MSs for further investigation or research.

What was done?

A new software module in Hospital Information System (HIS) for monitoring medicines’ shortages (MSs) was conceived by hospital pharmacists (HPs), and it was designed, developed and integrated to the ICT system. This module helps HPs easily track which medicines were totally or partially substituted due to insufficient quantities and gives additional information (such as residual quantity of a medicine on prescription date, on inspection date, pending orders, known shortage) needed for managing MSs. In this tool, MSs and relevant information, such as causes, measures to re-stock and shortage’s impact, can be entered, centrally managed and regularly reported.

How was it done?

Implementation of the module in ICT system was made at zero cost by the ICT service provider, following technical specifications designed by HPs. The final product was multi-checked by HPs during development and all technical problems have been resolved accordingly.

What has been achieved?

• Quick intervention of HPs to restore medicines availability is feasible. • We can now have precise and easier follow up, with less human resources required. • MSs are collected, registered and easily utilised to draw conclusions. • HPs’ interventions to deal with MSs are easier to evaluate

What next?

ICT tools’ development is very important in facilitating hospital pharmacy’s practice, especially when human recourses are restricted. These software modules can be easily incorporated in every HIS. Pharmacists are competent and should have a central role in designing such tools. We are planning to evaluate our new MSs management procedure; in the long run, incorporating in this tool a risk assessment algorithm will be an asset.

ANTIMICROBIAL STEWARDSHIP: WHAT IF EVERYTHING IS ON YOUR SCREEN? (submitted in 2019)

Pdf

PDF Icon

European Statement

Introductory Statements and Governance

Author(s)

Marinos Petrongonas, Maria Fragiadaki, Eleni Rinaki, Leonidas Tzimis

Why was it done?

Implementation of antimicrobial stewardship programmes in hospitals is part of the national strategy to promote prudent use of antimicrobials. As HPs chair stewardship teams, they are responsible for assessing prescription and monitoring antimicrobial use. Designing and developing automated informative tools facilitates HPs in their role.

What was done?

Hospital pharmacists (HPs) designed and developed software tools to support the antibiotic stewardship team’s work. Particular developments were: a) Α PC application (GrAD_calc), in Microsoft Excel, to calculate antimicrobial consumption, instead of ABC_calc tool. GrAD_calc takes advantage of the unique codes for each branded product and transforms aggregated data, provided by the Hospital Information System (HIS), into antibiotic consumption in DDDs/100 occupied bed-days. Results are presented in charts and figures, in a format that enables ease of comparative monitoring over time. b) Necessary indexes of the above calculator and documentation needed as justification for restricted antimicrobials dispensing have been integrated into the HIS; in result, data for national surveillance programme for antimicrobial consumption are automatically exported. Useful information for pre- and post-prescription review, like demographics, indication(s), co-morbidities, current and previous treatments, microbiology tests’ results, susceptibility reports, is available and easily accessible to prescribers, HPs, and infection disease specialists.

How was it done?

HPs created GrAD_calc on their own resources, while changes in HIS were made by ICT service provider, following technical specifications described by HPs. A number of technical problems have been resolved with the contribution of HPs.

What has been achieved?

• Monitoring of antimicrobial use by pharmacy is quicker and effortless. • Handwritten documentation included in restricted antimicrobials’ prescriptions has been replaced by an electronic decision support system, as tool to improve antimicrobial prescribing and stewardship. • Useful information from patient’s medical record is directly available to HPs and physicians, and facilitates hospital’s policy for assessing antimicrobial prescriptions. • Data, like indication, medicine, dosage scheme, microbiology results and susceptibility reports, are recorded electronically and update patients’ pharmaceutical records, permitting further use for pharmaco-epidemiology studies. 

What next?

Next challenge is wide use of tools developed, to optimise pharmaceutical services provided and dispense restricted antibiotics only when accordingly justified. GrAD_calc is applicable in hospital setting and HIS’s tool is incorporated and can be used by all regional hospitals.

IMPLEMENTATION OF A NEW CENTRALISED FLOOR STOCK IN A SECURED AUTOMATED STORAGE CABINET

Pdf

PDF Icon

European Statement

Selection, Procurement and Distribution

Author(s)

Chloé HERLEDAN, Laura BEAUMIER, Laurence MINISCHETTI, Marie-Christine ALBERTO-GONDOUIN

Why was it done?

Existing floor stocks are limited to usual psychiatric drugs. On-call resident pharmacists dispense additional treatments during pharmacy closing hours. Hence, extending the floor stocks would facilitate continuity of care. SASC centralisation enables simple and secured access to medication while saving space in care units.

What was done?

A new drug and medical device floor stock was implemented in our psychiatric hospital. The floor stock is contained in a secured automated storage cabinet (SASC) located in a protected area inside the pharmacy and accessible during its closing hours. Utilisation training was offered to nurses through multiple formats.

How was it done?

Floor stock composition has been established from frequent requests made during on-call time and can be consulted on the pharmacy website. Prescriptions and patient informations can be checked before removal on a computer in the SASC area. The SASC requires badge identification, unit and patient name entry and provides traceability of removals. Moreover, cold storage requiring drugs are housed in a refrigerator unlocked through the SASC. Regarding utilisation training, all night nurses had to attend a demonstration of the SASC performed by the resident pharmacists. This demonstration was also offered to day nurses and head nurses during weekly pharmacy open days for three months. In addition, an instruction manual and a video tutorial were produced and uploaded on the website.

What has been achieved?

60/67 (89.5%) night nurses, 80/256 (31.2%) day nurses and 10/20 (50.0%) head nurses have attended the SASC demonstration. A satisfaction survey conducted among trained nurses or head nurses had an 18.7% response rate. 26/28 (92.9%) of respondents attended the demonstration and all were satisfied by its quality. 2/28 (7.1%) only used the instruction manual. All respondents declared being able to use the SASC, however 7/28 (25.0%) would need assistance from the instruction manual or video tutorial.

What next?

Further utilisation training or assistance will be provided by the video tutorial. Removals and prescriptions will be checked by pharmacists to uncover picking errors. Impact on resident pharmacists’ workload will be assessed within six months. Finally, SASC centralised floor stock is an interesting approach for hospital pharmacies with limited staff to improve continuity of care.

Early-stage experiences of the implementation of a large-scale robotic storage and distribution system in a hospital pharmacy service within a large UK health authority

Pdf

PDF Icon

European Statement

Selection, Procurement and Distribution

×

EAHP Forum

All the EAHP team is working on providing a Forum that can help connect all the members in Conversations and Groups to talk about important matters for the European Hospital Pharmacist.

The Forum will be accessible for all the EAHP members, you don’t have to create a new account to browse and participate.

Conversations and groups

The Conversations will be moderated by our team to provide documents and relevant topics for the community.

The Groups will connect all members that share a category. Members who work on the same assocation, on the same hospital, that have the same role, etc.

Stay tuned for the realase of the forum. Soon on EAHP.