Case Studies

Modality had a large reliance upon manual data transcription between their SystmOne environment and their reporting database and at the time processes were only in place to capture NAC data via system downloads and manual data entry.

A new on-premise SQL server database was designed and utilising SSIS integration tools was configured to load all activity deltas on a nightly basis for all activity and demographic data covering both APC and NAC datasets. All aspects of the data load process including troubleshooting information was documented and handed over to the on-site team.

By reviewing current NAC CDS data submissions and associated processes it was clear there was definite room for improvement in terms of the data quality. This was further aided by the heavy reliance of manual transcription of data into the on site reporting database which ultimately was responsible for a not so desirable performance in the organisation's DQMI targets.

A field by field review was performed and matched back to original data systems clearly highlighting there were multiple "sources of truth". Processes were re-written in the view of taking out human interpretation from the equation. Subsequently there have been huge improvements in the organsisation's DQMI performance and also in internal and external visibility of patient outcomes. 

The data review was fed back and configuration changes were made directly onto the PAS system which in turn has seen Modality LLP become one of the best performing organisations in terms of data quality.

With APC being a new dataset for the organisation there were no reports currently configured to see what activity was being recorded and also their associated income tariffs.

Both activity reports and data quality reports were produced and implemented using their pre-existing reporting services environment.

Due to the success of these new reports, reports were then designed and produced to replicate current manual front-end processes. These were made available to the team quickly and accurately and dramatically sped up the current manual processes whilst transition to NAC reporting directly from the new data warehouse was being planned and developed.

The overall project saw the NAC DQMI performance increase from a 35% dataset score to 100% making one of the worst performing organisations now one of the best.

The project also came with the benefit of large resource savings and in turn costs by removing manual tasks and ensured accuracy in tariff allocation under PbR.