Powered by Lexis+®
Jurisdiction(s):
United Kingdom
CASE STUDY

“It's hard to quantify, right now. But at a guess, I'd say it's probably more than 50% faster, at times. It's literally that quick. We've found to be an essential practical tool. We're very satisfied.”

Walsall Council

Access all documents on Data cleansing

Data cleansing meaning

What does Data cleansing mean?
In pensions practice, data cleansing means the systematic review and correction of pension scheme member and benefit records to ensure they are complete, accurate, consistent and up to date. It is a descriptive industry term, not defined in legislation or case law, but it supports trustees’ duties to pay the right benefits to the right people at the right time and to maintain proper records. Typical activities include validating “common” and “conditional” data, reconciling records with payroll, HMRC and insurer files, removing duplicates, standardising formats, tracing members and beneficiaries, documenting assumptions, rectifying errors and maintaining an audit trail and data improvement plan. It is routinely undertaken for ongoing administration and for projects such as GMP equalisation, buy-ins and buy-outs, bulk transfers, scheme wind-up and pensions dashboards matching. Legally, data cleansing must comply with UK GDPR and the Data Protection Acts (UK and Ireland), particularly the accuracy, data minimisation and storage limitation principles, data subject rights (rectification/erasure), lawful bases, and controller–processor contracts. UK regulatory expectations include The Pensions Regulator’s General Code and data quality (common/conditional) scoring; in Ireland, the Pensions Authority’s governance code sets comparable standards. Usage and purpose are broadly consistent across England & Wales, Scotland, Northern Ireland and Ireland.
Speed up all aspects of your legal work with tools that help you to work faster and smarter. Win cases, close deals and grow your business–all whilst saving time and reducing risk.

View the related Checklists about Data cleansing

CHECKLISTS
Occupational pension scheme wind-up checklist (DB and DC): TPR-guided steps on data cleansing, s75 employer debt, GMP equalisation, securing benefits, trustee discharge, statutory disclosures and final regulatory notifications

THIS CHECKLIST APPLIES TO OCCUPATIONAL PENSION SCHEMES This checklist highlights the key actions involved in bringing an occupational pension scheme to a close—whether a defined benefit (DB) or defined contribution (DC) arrangement—and aligns with winding-up guidance from the Pensions Regulator (TPR). For fuller detail on these steps, see Practice Notes: Winding up a defined benefit (DB) occupational pension scheme; Winding up a defined contribution (DC) occupational pension scheme; and Winding-up an occupational pension scheme—statutory disclosure from 6 April 2014, reporting and record-keeping requirements. Data cleansing and reconciling records Once trustees decide to wind up the scheme, they should carry out a thorough data cleansing exercise. As this can be lengthy, it should, where practicable, be completed before formal winding-up starts. Where trustees cannot control the timing of the wind-up, cleansing and planning should begin as early as possible within the winding-up process. As part of the data cleansing exercise, trustees should: Check and reconcile member records. Where the scheme is a former contracted-out...

Read More Right Arrow

View the related News about Data cleansing

NEWS
IDDQD and Royal Mail v Codeberry: England and Wales High Court clarifies database right and copyright in PAF, ‘consultation’ vs extraction, open‑data copying, data cleansing, and director liability

IDDQD Ltd v Codeberry & Smith, Royal Mail Group Ltd v Codeberry & Smith [2025] EWHC 2561 (Ch) What are the practical implications of this case? Rulings on database right infringement are infrequent, so this judgment offers valuable direction for practitioners in this field. It matters especially to digital enterprises working with extensive datasets sourced from third parties. The court confirmed that the sui generis database right in the Copyright and Rights in Databases Regulations 1997 (CRD 1997) safeguards significant investment in collecting, checking and arranging information. Early-stage companies cannot depend on indirect or ‘open data’ sources where those datasets embed protected content. The judgment also clarifies that employing licensed material to ‘cleanse’, ‘validate’ or ‘update’ one’s own dataset still amounts to extraction or re-utilisation when substantial elements of another database are carried across. The court further touched on artificial intelligence (AI): the judge examined the boundary of merely ‘consulting’ a database that will not infringe, concluding that simple viewing is not an infringement, but the line is crossed...

Read More Right Arrow

View the related Practice Notes about Data cleansing

PRACTICE NOTES
Winding up UK trust-based DC occupational pension schemes: classification, triggers, expenses, data cleansing, securing benefits, disclosures, trustee protections and completion

This Practice Note sets out the principal steps for properly bringing to an end a defined contribution (DC) occupational pension scheme—also described as a money purchase occupational pension arrangement or a trust-based defined contribution plan. Throughout this Practice Note, this type of arrangement is termed a ‘DC scheme’. The guidance applies across a range of DC schemes, including trusts that sit outside the authorised master trust framework and small self-administered pension schemes (SSASs), although the latter may, in certain cases, be excluded from particular statutory obligations or requirements. This Practice Note does not cover the winding-up of any: an ‘authorised master trust’ under the Pension Schemes Act 2017 (PSA 2017)—for further detailed information, please see Practice Note: The authorisation and supervisory regime for master trusts, contract-based DC arrangements (eg group personal pension arrangements)—for further details and guidance, see Practice Note: Winding up of personal pension schemes Statute makes distinct and specific provision for hybrid schemes (combining defined benefit (DB) and DC...

Read More Right Arrow
PRACTICE NOTES
Practical guide to reviewing and negotiating pension scheme buy-in/buy-out policies: quotations, benefit specification, pricing adjustments, GMP equalisation, data cleansing, warranties, trustee liability and data protection

Although every insurer produces its own policy documentation, they generally follow broadly comparable procedures and contain parallel provisions. In most cases, the documentation pack will consist of the following elements: a quotation a policy document setting out the terms and conditions an acceptance document Guidance from the Financial Conduct Authority, as set out in PERG 10.3 Q13, indicates that one-off annuity purchases chosen by the pension scheme trustees are highly unlikely to be regarded as constituting ‘day-to-day’ management decisions under the Financial Services and Markets Act 2000 (FSMA 2000). Trustees can therefore, in those circumstances, select the annuity provider without first being authorised under FSMA 2000, but should only proceed after taking advice from a suitably qualified and experienced financial adviser. This Practice Note outlines a typical buy-in/buy-out process and then examines what the quotation and the policy terms and conditions should contain. For further details on issues arising when considering buy-outs and buy-ins in respect of defined benefit occupational pension...

Read More Right Arrow
PRACTICE NOTES
Defined benefit (DB) occupational pension scheme winding-up: statutory triggers, section 75 debt, priority order, data cleansing, contracted-out reconciliation, disclosures and trustee protections

THIS PRACTICE NOTE APPLIES TO DEFINED BENEFIT (DB) OCCUPATIONAL PENSION SCHEMES Many employers opt to wind up their company’s DB pension arrangement as part of a wider de‑risking strategy. In other circumstances, an employer’s insolvency may result in the scheme entering wind‑up, activating the relevant provisions set out in the scheme rules. Where the wind‑up is anticipated, trustees and sponsoring employers can streamline the process by preparing early and ensuring they are clear on the essential stages and principal considerations before the wind‑up begins. The principal statutory framework governing the winding‑up of pension schemes is primarily found in: sections 73–76 of the Pensions Act 1995 (PA 1995) the Occupational Pension Schemes (Winding Up) Regulations 1996, SI 1996/3126 (the Winding Up Regs 1996) the Occupational Pension Schemes (Winding up etc) Regulations 2005, SI 2005/706 For practical guidance on the issues arising when winding up a DB pension scheme, see Practice Note: Practical issues on the winding‑up of a defined benefit (DB)...

Read More Right Arrow