This page contains a Flash digital edition of a book.

Avoiding acute interventions

Implementation won’t be completed until June 2014, due to the complexity of the shift to the new service. Over 500 people at practitioner level were involved from the start in determining the specification for the project.

Callow said: “At the moment, one thing we can’t see very easily is the collective occurrences within a family’s life; we know from research that a particular family won’t just need support in one particular area. By bringing this information together, we’re allowing multi-agency teams to have an opportunity to intervene early in a situation, before it becomes acute.

“It’s extremely expensive if a family situation becomes more acute, and the outcomes are so much poorer. That’s massive for us: preventing those things from becoming acute. That’s a big saving to the public purse, for the county council and the wider public services involved.

“There are also operational efficiencies; we know there’s things we won’t need to do any more, such as taking information on a spreadsheet out of one system, adding some information to it and re-keying it into a different system.

“On a minor level, this also cuts down the sheer effort of contract management of all of the different software systems we’ve got now, both in the number of contracts, the number of different SLAs, the different times when we can access service desks, and so on. By bringing all that together in one, it’ll help us save time and money.”

Data protection

Clearly information governance and data protection is a huge issue in sensitive family cases. This is built into the new system at every level. Callow said: “We’re absolutely clear that although we’re bringing all this information into a single database, it doesn’t mean everyone will be able to see everything on it. The data model within the ChildView product allows us to be extremely flexible about who sees what. Our underlying remit, reinforced by the Laming report and subsequent reports, is that only the people who need to see the information should see it. If there’s a reason someone needs to see information that ensures the safety of a child, that will be made available.

“ChildView is a single database, but it’s still the actual operational areas are still modular, you

start off with a single very high level view of a child, then according to your permissions and job role, you can then drill down into the detail.

“We’ll continue to fulfil data protection responsibilities, while also being able to share that information on a needs-basis. It certainly isn’t a carte blanche for everyone to have access to the database, that would be a very unsafe situation.”

Richards added: “I don’t see our system being any riskier than 30 or 35 separate databases of varying degrees of sophistication and complexity and security – some of which are simply spreadsheets on

our services on a longer-term basis and support us on this journey. We’re really excited about the possibilities.”

The clean sweep

Both of them acknowledge the large challenges and risks in such a big piece of work, because of its sheer scale, and because there aren’t many other equivalent ‘clean sweep’ approaches at other councils to learn lesssons from.


laptop. There is the potential for significantly improved security as a result of putting all that information in one place: you know exactly where it is and what you need to secure.

“The system is sitting within the county council’s own domain, so all its existing standards and protocols apply: they have a sophisticated range of security policies and procedures and audits that they manage quite closely. Then within the application itself, we use Oracle Database Security, applied to the role – the individual. So one person signing in will have permission, as a result of the nature of the work they’re doing to see, to view, to edit, to enter information, in very specific parts of the system. That’s controlled right down to database fields. Security is applied at the database level, not the application level, stopping people from getting around it in any way.”

Fitting the jigsaw together

Richards said the current system, with its many distinct programmes and databases, is “like a great big jigsaw puzzle that hasn’t been put together”. He said: “They’ve made an effort to do some integration between the larger key systems – a mechanism for exchanging core information between social care and the intervention / prevention teams, for example, but that’s pretty much on an ad hoc basis, and sometimes via an emailed spreadsheet, for example, with only core demographic information. It’s been a glorified signposting service, rather than providing any real depth of knowledge about what’s going on over the fence.”

The project is part of the department’s wider ‘Journey to Excellence’ initative, reviewing all of its working practices, to move its results from inspections and citizen feedback from ‘good’ to ‘excellent’. Callow said: “This system will, we hope, allow us to evaluate the effectiveness of

Richards said: “The scope of change we’re going to be working with Derbyshire to achieve, in any circumstance, is not to be taken lightly. They’re changing education systems, social care systems, youth offending systems, children’s centres, early years: the whole lot. That’s a big piece of work for any authority and we can’t underestimate the amount of work that’s going to have go into it.

“It would be foolish to assume we won’t have some hitches along the way. There are 35 existing data sources, with one or two terabytes of data that’s got to be vetted, quality-checked, audited, then matched and transformed into the new system.

“Derbyshire is the first authority that we know of to make a ‘clean sweep’ of this scale, into a single database.”

Clearly, the ultimate aim of the project is not just day-to-day efficiency savings, but long- term better outcomes for children and families. The team implementing the single database hope it will mean practitioners spending less time on paperwork, and will give them more accurate and complete information to make decisions.

Richards said: “Improved outcomes are

excellent for the child or family, but also drive cost savings: a child going through specialist services of whatever nature will cost five or ten times more than one using universal services.”

Andy Callow


public sector executive Jul/Aug 12 | 29

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