Managing Your Chromatography Data System (CDS) - Are You In Control?
Home Your Chromatography Data System – are you in control?

Your Chromatography Data System – are you in control?

Tegan Rawlinson, Chromeleon and Data Compliance Administrator, Sterling Pharma Solutions

June, 02, 2020

Keeping control of a Chromatography Data System (CDS) is a never-ending task, but it is a task that must be done in order to adhere to GxP and data integrity guidelines and to keep you audit ready. Over the nine years Sterling has had the Thermo Scientific™ Chromeleon™ 7 CDS, we have developed a comprehensive set of procedures that make it easier for us to maintain and demonstrate control of our system.

As is often the way, when Chromeleon CDS was first installed none of our current control measures were in place. However, with the evolving regulatory guidelines and the assistance of Thermo Fisher Scientific, we have been able to gain an in-depth understanding of the Chromeleon software and the controls we need to have in place to not only ensure compliance, but also carry out routine self-inspections which help us to gather evidence to demonstrate that we are in complete control of our systems and processes. These procedures also enable us to track key performance indicators (KPIs), monitor training requirements and identify any problem areas within our laboratories.

Beyond the regular reviews carried out on every batch release, our system control activities are primarily carried out on a monthly basis, meaning the CDS admin team will perform at least one of these tasks each week. This ensures the admin team isn’t overrun with ‘control’ tasks, but they are  a constant in the background.

We believe that we’re not here to catch people out or point fingers of blame; we are here to ensure everyone is doing the right thing and that we achieve the best results for the customers and the patient.

New starters

The first step in maintaining control begins with the initial training that every new analyst goes through when they join the company. I have previously spoken about how we perform our training in my blog ‘Walking the training tightrope with Chromeleon CDS’.

This initial training gives us the chance to explain and demonstrate the control measures that we have in place and the new starter can see what is going on behind the scenes in the system.  We make sure they understand that the checks aren’t there to find fault with an individual’s work, but to provide a safety net to ensure the CDS is used correctly.

Second person checks: The Four-Eyes Principle

Second person checks are the norm in GxP environments – they are one of the fundamental ways of maintaining control.

Every reviewer is trained in how to properly review data so they can check the work and audit trails every time they sign a piece of work as reviewed. This allows the analyst to get real time feedback on their work, whilst giving the opportunity to share tips and tricks for use of the CDS. For example, the simple act of saying ‘I would integrate this peak like that’ gives the other person a chance to learn and understand a different way, or even a better way, of using and controlling the CDS.

We have recently given our operational qualification (OQ) managers access to Chromeleon CDS along with providing them with training on how to inspect the sequences and audit trails. So now, if they have any questions, they can logon and review the sequences ‘live’ rather than relying on exported reports. This ensures we have multiple layers of control going beyond the CDS admin team.

IT helpdesk

We have recently incorporated Chromeleon CDS incident/issue management into our existing IT helpdesk that we have on site. This has been invaluable as we can internally track training requests, support request and any issues that users are experiencing. This allows us to keep an overarching view of how our systems are functioning whilst also being able to track any subsequent escalation to Thermo Fisher for more support. Having this reporting system is not simply a convenient approach for maintaining control, it is also a regulatory expectation that auditors will require to see in place.

Monitoring electronic signatures

Chromeleon software provides the functionality to electronically sign sequences and, while this is something that has been around a while, at Sterling we have only just started to implement it in our system for certain types of testing. Our current KPI for electronic signatures is to have 100% of final product and intermediate testing being electronically signed. This KPI was put in place in December 2019, which required the whole analytical team to move from ‘wet’ signatures to electronic. Before this we hadn’t enforced electronic signatures and there was something of a divide between those who liked the idea and those who preferred the old way, typically based on personal preference. But since the switch the attitudes have changed and the site has come together to embrace electronic signing of the data. Of course, CDS admin must monitor the usage of electronic signatures, so we created Chromeleon queries to find sequences that should be signed and check if they have been electronically signed off.

Example of a Query to find sequences that should be signed electronically

At the start, December’s sequences weren’t fully signed off until the end of January which required significant effort from the CDS admin team to run the queries multiple times each week and follow up with individuals to ensure compliance. Now, if we take April’s figures, on the 6th May 2020, 78% of all the required sequences were already signed. This has significantly reduced the amount of checking CDS admin has to do and shows that electronic signatures are now established as the norm while allowing us to show auditors that we are consistency electronically signing sequences and that we are in control.

Electronically signed sequence monitoring

Integration monitoring

Manual integration is still a hot topic for auditors so it is of paramount importance that we keep control of the level of manual integration. Brian Alliston has spoken at length about how we monitor manual integration in his blog ‘What’s wrong with manual integration’.

We have a site wide KPI target to ensure that monthly manual integrations are below 18%. Our first step is always method optimisation to use automatic integration wherever possible. Obviously, we would love to drive this figure lower but unfortunately, due to the age of some of our methods, this has not always been possible hence the 18% figure.

On a monthly basis we perform a query to discover the number of manually integrated injections which allows us to monitor our progress and identify any training issues. We can also find and investigate methods which have a consistently high level of manual integration, which could be due to the nature of the testing, the age of the method or something else. Either way we can inspect that method and decide if there is general need for manual integration on a routine basis and, if there is, we can detail that in our SOPs which in turn helps the analysts as they are given even more guidance on how to carry out the integration.

Example of a Query to identify manually integrated chromatograms

 Monthly in-depth audits

Every month we carry out an in-depth audit of a sequence performed on Chromeleon CDS. We have a defined schedule so that each department will get audited three times a year.

One sequence is scrutinised from start to finish. Every audit trail is interrogated, each chromatogram is inspected, everything is examined to ensure every SOP is up to scratch and that best practice is being followed. These in-depth audits are not about finding errors, they are a way for teams, including CDS admin, to discover what works well and where there are opportunities for improvement. We frequently have many questions about the sequence, for example, “What was the rationale behind this change?” This can lead to a far wider conversation about how we can improve things, is there something missing from the method, is there a better way of data processing, is extra training required, etc. This is something that helps us to ensure we are always audit ready and that we’re continuously improving.

Changes in culture

Although some analysts may say that between Chromeleon CDS and our checks it can seem like big brother is always watching, we have found that these controls have influenced how people respond when using the CDS software. A great example is the recent transition to and acceptance of electronic signatures – in just five months the whole analytical team almost painlessly shifted to electronic signatures.

Before these regular checks, the audit trail comments often left a lot to be desired with entries such as ‘integrated’ being common. A few years on and we are getting full descriptions of the rationale behind the decisions that that were made in that save, leading to much better clarity and audit readiness.

Also, since the analysts know we inspect everything, they are very willing to come to us and say ‘I made a mistake’ which makes everyone’s life easier. It’s much easier to deal with a problem then and there rather than have it found by an auditor two years later! It’s great that the analysts on our site seem willing to do whatever they need to, to ensure we are following the best practices.

As with all change, it takes a while but when it happens, it happens to the whole site.

 User satisfaction

Who doesn’t like it when life is made easier? That is a common theme we hear with Chromeleon CDS – there are multiple ways to make your life easier and the analysts enjoy using the software.

Ultimately, there is always some hesitancy when a new procedure is introduced but, once people get used to it and start seeing the advantages, they quickly come on board. Take automatic integration for example, there was some resistance that this would take way longer to set up than manual integration, which is true for a single sequence but, when used across multiple sequences, the benefits become increasingly apparent. Once people got more comfortable with the parameters and how they work, integration has become far more automated and we have seen our manual integration figures reduce massively.

The ultimate in ease of use must be eWorkflow™ procedures. Our formulations team now exclusively use eWorkflows, which they have found it to be easier and more efficient for routine analysis.

Finally, electronic signatures have allowed us to significantly reduce the amount of paper we use in printing reports, which has been gratefully received by staff. They also like the fact their sequences are locked and any accidental changes can be prevented.

 Reduction in admin effort

Put all these things together and it makes the CDS admin sound incredibly controlling and paranoid, which unfortunately is exactly what is expected of a GxP laboratory.

But, by utilising these regular, scheduled checks, the CDS admin team’s workload has actually reduced allowing us more time to move the CDS forward rather than constantly firefighting or chasing people to sign sequences.

Also, as time has gone on, we have found a reduction in repeat audit findings. In March last year we identified an issue with column numbers not being added to the sequence correctly. However, since we reminded the analysts of the correct procedure we have only had one reoccurrence of this issue in the last 12 months. We can now identify problems sooner and resolve them before they become an issue which could massively increase our workload.

These measures have revolutionised how we use and control our CDS and how we present it to auditors, as well as demonstrate how much of an impact following best practice can make.

For more information, or to speak to a member of the Sterling team, please get in touch.