Big thing I’m prying at is whether there would be a legitimate purpose to have duplicated SSNs in the database

formally, changing the identity of someone would have a very explicit reason to keep a “duplicate” ssn entry, if purely for historical reasons for example. I’m sure there are a myriad of technical reasons to be doing this.