Free companion page

Companion page: The Pension Risk Transfer Professional

Free to print: Tool 4: Participant data clean-up check-list, from The Pension Risk Transfer Professional.

This page is free and needs no sign-up. It reproduces material from The Pension Risk Transfer Professional by Julian R. Sterling so you can print it or keep it open while you work.

To print it, use your browser's print button. Figures are as stated in the book; check the official source before relying on any of them.

Tool 4: Participant data clean-up check-list

Who uses it: the plan actuary and the sponsor's benefits director, with the PRT desk reviewing the output. Dirty data raises the price, because insurers add a load for data uncertainty (Chapter 4). In the case, Brannock Actuarial ran the clean-up for the 8,500 records from March to August 2026, starting on 2 March 2026.

Check What to look for Case result
Spouse date of birth Married participants with no date of birth for the spouse 412 records
Benefit form A form that is missing or conflicts with plan records 236 records
Address Deferred members with no current address 97 deferred members
Deaths Deaths not recorded, found by a death audit 58 deaths

Work through the list in order:

In the case, all issues were resolved or flagged before the final quotes. That is why the data load was removed from the final price. A flagged record is not a clean record: it stays on the list for the transfer.