Free companion page
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.
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.