How InView regenerated Croydon Health Services’ data capabilities

Background:

Croydon Health Services NHS Trust is a mid-sized hospital in Croydon that provides acute and community care through services and departments ranging from A&E, adult and paediatric critical care to outpatient and inpatient treatment and community services.

Prior to partnering with CACI over a decade ago, the Trust did not have their own data warehouse. Their in-house and bespoke systems were built using tools like Microsoft Access and SQL Server, which challenged their ability to load their structured data properly and time-efficiently. As a result, the Trust conducted a tender to enlist support for this, and after gauging the simplicity and ease with which CACI could help them meet their data warehouse optimisation needs, established a partnership.

Challenge:

Croydon Health Services’ entire in-house, bespoke system had been run by one person. This presented a risk to the organisation, particularly in the event of any changes made to statutory submissions or to the Healthcare Resource Group (HRG).

Husein Kermali, Head of Information Systems at Croydon Health Services NHS Trust, explained the Trust’s thinking in opting for a more organised route that would guarantee their protection by working with an organisation as opposed to an individual to oversee the entire system.

“One of our reasons we chose to go with [an organisation-led] warehouse in the first place was so things like the HRG group, the statutory submissions and anything that comes online from us from an NHS perspective would be something that we knew that warehouse would be capable of delivering.”

Solution:

The Trust implemented InView back in 2011-2012 as a one pass system. CACI created Extract, Transform & Load (ETL) processes through InView based on pre-existing system knowledge and an understanding of what Croydon Health Services endeavoured to do with their data from the point of partnership.

A few years later, in conjunction with their existing data provider, the Trust went from PIEDW extracts to Nautilus 835 extracts, which resulted in CACI taking over a significant amount of the ETL process for the Trust. The positive working relationship between the Trust and CACI built up the Trust’s confidence in the difference CACI could make for their data processing capabilities.

“We know that CACI is always there when we’ve got issues, we know that [CACI] knows the detailed processes very well. [CACI] also work for a multitude of Trusts… so they know they’ve seen all the issues that we’re having in other Trusts, and what all the Trusts are trying to do,” Husein explained. “I think with that kind of vision, [CACI] can see a lot more than we can. I think that makes CACI a great partner to be with.”

Results:

When the CDS010 was retired and 011 E CDS came online a few years ago, Husein flagged that “if [the Trust] did that in-house, that would have been a lot of work.” According to Husein, CACI had the extracts ready for this through InView, CACI’s modular data platform, easing Croydon Health Services’ involvement in the process.

“With the simple product upgrade of InView, [CACI] had all the elements within their product already. We just had to populate the fields that we needed. The output that was delivered was then ECDS 011 compliant, which saved us a lot of time,” Husein continued. “[CACI] did all the testing… we just had to make sure that we filled in the elements that we needed for the easy desk submission, so that was amazing because it saved a lot of time.”

Croydon Health Services has also benefitted from being involved in the ETL process throughout its development by CACI. The supplementary documentation provided at the end of any piece of work with CACI has given the Trust unrestricted access to changes made through InView or ensuring that everything they wished to capture had indeed been included.

The Trust has applied their learnings from CACI’s processes to successfully implement their own data quality (DQ) reports and dashboards that highlight potential problems and look up issues through a warehouse load process. The processes followed by their Data Quality team have also ensured that when data now goes through to the data warehouse, those issues disappear.