Figure 4: Extract, Transform, Load process for indicators.
DB stands for database.
5 CONCLUSIONS
The Traceability and Indicators System described in
this paper facilitates the retrieval of significant
information in an ODH, with the purpose of
improving daily operation and patient satisfaction.
Traditionally, part of the information retrieved by the
TIS has been manually recorded and processed to
obtain indicators, and only significant deviations,
detected. The TIS has been designed upon request of
the Oncology Service Management to have a better
view of the ODH workflow, so specific
organizational and technical actions can be designed
on a solid informational input.
The TIS has been designed in tight collaboration
with practitioners and administrative staff, with the
objective that it can fulfil the real requirements of
day-to-day operation in the Oncology Service of a
hospital, providing added value and avoiding
problems in the organizational change that the
availability of this tool may suppose.
The TIS relies on information that can be
automatically retrieved from the existing systems in
the hospital. This entails that the deployment does not
require complex technology or significant
investments, while providing relevant information of
the workings of the oncology day hospital. The design
process has been useful to identify information gaps
(e.g. part of the processes that are not automatized,
still done in manual ways), so their improvement can
be added to the strategic agenda of investments.
The system has been technically evaluated against
the design requirements in Section 2.2. Although it
fulfils them reasonably well, there are several aspects
that need to be improved. For example, the
management of both alerts and notifications still need
to be better implemented, and the set of indicators,
polished. Additionally, although the available
presentation interfaces have been incrementally
improved with the help of the users, different
presentation formats should be benchmarked. This
can also be applied to indicators; it is also necessary
to systematically analyse the causes of the detected
deviations to feed the TIS.
Up to now, practitioners and nurses have partly
tried the system in oncology consultations, ODH and
Service Head offices, but their experience with the
TIS is still brief to extract conclusive comments. In
any case, from their feedback it is possible to say that:
The system gathers real-time information in a
reliable way, although it is still necessary to
make some procedural changes to better
contextualize some data. For example, due to
specific instructions given to ODH patients, the
time when these patients take the turn ticket for
consultation is stored, but the entry time at the
hospital is not (ODH patients are told to go
directly for blood draw service).
It is necessary to provide better traceability at
resource level (seat or bed), with the purpose of
optimizing its occupation. This traceability is
manually done and may not be accurate enough
due to human errors. A technical solution
involving RFID or barcodes is currently being
designed to address this issue, and it will be
integrated at the TIS when ready.
Alerts in the real-time visualization interface
need to include specific management options,
to track if the alert has been handled. Up to
now, they are merely informative and no action
is triggered from them.
One of the possibilities to manage alerts is to
make them trigger SMS both to patients or care
professionals, as there is a corporate existing
platform for this purpose. Other options, such
as instant messaging, involve technology and
organizational changes and may delay the
integration with the service. In any case, it is
necessary to study to which extent these SMS
may be effective and useful for their recipients
(misleading or spam effects). In particular, it is
necessary that involved users express their