Loading Finance Ledger Data in to the Data Warehouse

Lincolnshire Community Health Services NHS Trust, Midlands, Community

The problem

Clinical Leads need be able to look at financial information, otherwise inefficiencies cannot be addressed.

The challenge

How might we join up financial data to workforce and activity data so that clinical leads can maximise productivity?

The outputs

The outputs of the innovation are live nominal rolls, joined-up finances and activity as well as dynamic reporting functionality.

The outcomes

The main outcomes have been the creation of additional capacity for management accountants to work closely with services, reduced the need for email traffic with budget reports being available at all times, reduced the number of manual staffing journals with managers able to identify miscoded individuals prior to payroll feeds being shared.

The Innovation

Read the full innovation on Loading Finance Ledger Data in to the Data Warehouse

Any documents and resources relating to this innovation can be found in the downloads section at the bottom of the page.

Read now

What the peer-reviewers said

“Great example of introducing a new way of working that will help scale and improve their business processes and management of data.”

“The creation of live dashboards enables clinical leads to monitor key metrics and trends instantaneously.”

“This innovation minimises manual tasks by introducing automated reporting, thus optimising resource allocation and reducing the need for time-consuming administrative work.”

Get Involved Today