RiO Experience
Our experience of the RiO system has been gained from a variety of projects involving PCTs and Mental Health Trusts. Whether the project has been a ‘typical’ implementation or post implementation to deal with reporting issues, our experience, combined with our healthcare knowledge has helped RiO clients achieve their objectives.

 

Mike on RiO Reporting

 

RiO Clients we have worked with include:

• Barking and Dagenham PCT
• Barnet PCT
• Brent Teaching PCT
• Enfield and Haringey Mental Health Trust
• Enfield PCT
• Hammersmith and Fulham PCT
• Harrow PCT
• Lambeth PCT
• Lewisham PCT
• Newham PCT
• Oldham PCT
• West London Mental Health Trust

 

Typically our involvement in the these projects has been in the following workstreams; migration support, data mapping, migration strategy, EMIS immunisation transformation, transformation rules (Child Health and IMS), reporting system design, report generation and data modelling.

Our experienced data consultant Anthony provides some useful tips and experiences for Trust's looking to progress with a RiO data migration.

RiO Reporting
A common challenge for Trusts has been ensuring continuity of their business reporting. Trusts often link their RiO system to a separate warehouse to fulfil their reporting goals. Avoca’s certified RiO data modellers can create a robust and efficient reporting mechanism for community data in your RiO system. As well as working with the separate teams within the PCT, they will liaise with appropriate service providers and third parties (such as London Program for IT) in the development of the RiO application, and to resolve any data issues. Avoca will work with you to achieve your goals, by working on reporting tasks including:

 

Duplicate Data	Data from separate systems holding duplicate information as RiO data (e.g. birth details).
Islands of data	Data that is stored in a separate system and needs to be integrated with the RiO data.
Missing Data	Data that was in RiO but isn’t in the reports. (e.g. causing broken patient pathways)
CDS Validation and Reconciliation	Reconciling and investigating errors between legacy (such as CHIA) and RiO CDS Extracts
18 Weeks Module Reporting	Creating complex reports through querying legacy data against specified criteria to produce reports for manual data entry, to ensure that 18 week clock stop and starts produce correct 18 week wait times.
Creation of Extract Mechanism for Contact Point.	Create extracts from RiO to populate the Social Service database.
Mapping the legacy system reference data (clinical, demographic etc.) to that of the new system.	This involves communication to the clinical staff in order to ensure accuracy of the clinical mappings.

 

RiO Application Specialists
Avoca’s RiO Applications Specialists work alongside PCT staff, to configure the new Patient Administration System. Advising in meetings on the current processes which the clinical staff used, and how they might use the new system operationally. This involves:

RiO Demonstration	Presenting and demonstrating the application to information, administration and clinical staff, in a way which was relevant to their particular service/department.
Stakeholder engagement	Communicating with various different levels of staff within the supplier, the Trust and also in external organisations.
Project deadline contingency	Liaise with trust counterpart to ensure that project deliverable deadlines are met.

 

Mental Health Data
Avoca have vast experience of analysis and understanding of Mental Health Data. We have migrated complex MH datasets on many projects. These datasets include discharges, other statuses, mental categories, guardians and which referrals the Sections link to. Current projects include Pennine Care NHS Foundation Trust, Cambridgeshire & Peterborough Foundation Trust and Humber MH.
Mental Health data has its own unique challenges which we investigate and highlight early in the project using our Data Healthchecks service. This assessment of data quality includes analysis of the history of sections a patient has been subject to, their duration and outcome.