Oncology dilution traceability

The starting point

In an oncology operation, time is more than a productivity metric. It helps coordinate people, stages, and medication that must move through a strict workflow. The pharmacy could carry out dilution, but it lacked consolidated timestamps to show how long each medication remained at that stage or where delays accumulated.

The challenge was to turn a distributed process into a measurable sequence without adding unnecessary operational burden to the team.

A reliable event at every stage

Barcode scanning became the capture point. Each scan associated a medication with its date, time, and location in the workflow. The React interface had to be direct enough for repeated use and resilient to incomplete records.

Events were sent to a Node.js and Express API. In Oracle, PL/SQL procedures consolidated the data needed for analysis, keeping business rules close to the data source already used by the operation.

From recording to a monthly view

The product was organized into two complementary experiences:

• a fast operational screen for recording medication movement;
• a monthly dashboard for comparing stages, locating wait times, and investigating recurring patterns.

Rather than presenting only a general average, the dashboard preserved a stage-by-stage view. That made it possible to distinguish a naturally long process from a localized bottleneck.

Outcome

The team gained a reliable timeline of the dilution process. Data made delay points visible and created an objective foundation for improving the pharmacy workflow.

This case shows how a simple interface, connected to the right capture mechanism and a coherent data model, can improve a critical operation without trying to replace the knowledge of the people running it.