monarch desktop pro
Financial data must be compiled to meet the reporting obligations of the Trust to its regional Strategic Health Authority
which has to be able to assess its current quarterly position and forecast how this will change.
services cost effectively. “Having operated Closer examination of the way in which dif-
below budget in areas such as servicing pre- ferent data streams have to be collated to pro-
scriptions, some of the external pressure is duce management reports explains why the
reduced and we can concentrate on manag- financial team is pursuing that goal.
ing the Trust’s finances to give even greater For example, every PCT has a responsibil-
value for money.” ity for the salaries and related costs of its staff.
PCTs are a more recent development along To ensure consistency in this area, the NHS
the 60-year NHS time line; the tier of health has introduced a single HR system - ESR
administration inheriting IT systems that had (Electronic Staff Records) - which has been
been installed to meet a variety of objectives rolled out across all NHS organisations in
in earlier incarnations of the NHS structure. phases over five years.
Given that history, which directly impacts
upon NHS Bury, increasing financial effec-
tiveness further through the use of improved
Merging staff costs from ESR
information systems might seem a tall order. As staff costs appear as a key element of the
There are probably fifteen different appli- reports assembled at Bury, the relevant data
cations providing the financial data on which has to be extracted from ESR and merged with
the Trust’s reports are based. Legacy systems other cost data from the mutually incompat-
are prominent, including the main account- ible ledger system.
ing system currently in place there, the “To have built an application specifically to
Accpac general ledger. read the data output from those systems, and
merge it consistently into our financial reports
Increasing financial efficiency
would have proved expensive using a conven-
tional IT development approach. It would also
Ensuring that all of the data at the disposal of have involved modification if any data fields
NHS Bury could be applied to increasing the in either system were to change over time.”
Trust’s financial efficiency gave Lee McMahon A more cost-effective approach was to find
and his team an objective: “It has been to cre- a way of capturing the data streams from the
ate a data extraction system that we can ap- different systems at the point where they gen-
ply across all of the databases we employ to erated a ‘clean’ report and merge that infor-
isolate the layers of data which are relevant mation into the required format.
to decision making, and extract them in the The IT sector is not lacking in solutions for
most appropriate format.” ‘mining’ data from the databases held on
The Informed Executive
55
Page 1 |
Page 2 |
Page 3 |
Page 4 |
Page 5 |
Page 6 |
Page 7 |
Page 8 |
Page 9 |
Page 10 |
Page 11 |
Page 12 |
Page 13 |
Page 14 |
Page 15 |
Page 16 |
Page 17 |
Page 18 |
Page 19 |
Page 20 |
Page 21 |
Page 22 |
Page 23 |
Page 24 |
Page 25 |
Page 26 |
Page 27 |
Page 28 |
Page 29 |
Page 30 |
Page 31 |
Page 32 |
Page 33 |
Page 34 |
Page 35 |
Page 36 |
Page 37 |
Page 38 |
Page 39 |
Page 40 |
Page 41 |
Page 42 |
Page 43 |
Page 44 |
Page 45 |
Page 46 |
Page 47 |
Page 48 |
Page 49 |
Page 50 |
Page 51 |
Page 52 |
Page 53 |
Page 54 |
Page 55 |
Page 56 |
Page 57 |
Page 58 |
Page 59 |
Page 60 |
Page 61 |
Page 62 |
Page 63 |
Page 64 |
Page 65 |
Page 66 |
Page 67 |
Page 68 |
Page 69 |
Page 70 |
Page 71 |
Page 72 |
Page 73 |
Page 74 |
Page 75 |
Page 76 |
Page 77 |
Page 78 |
Page 79 |
Page 80 |
Page 81 |
Page 82 |
Page 83 |
Page 84 |
Page 85 |
Page 86 |
Page 87 |
Page 88 |
Page 89 |
Page 90 |
Page 91 |
Page 92 |
Page 93 |
Page 94 |
Page 95 |
Page 96 |
Page 97 |
Page 98