98

SSN numbers are good for 999,999,999 people alive or dead. At some point the US will hit that, right? Do we start reusing numbers? Sounds like a disaster waiting to happen.

all 48 comments
sorted by: hot top controversial new old
[-] cmnybo@discuss.tchncs.de 183 points 1 month ago* (last edited 1 month ago)

Just add another digit and watch the entire country break down because they can't find someone to update their 40+ year old software written in COBOL.

[-] purplemonkeymad@programming.dev 49 points 1 month ago

Sorry we can't employ you as your ssn is too long. Also we can't have any new employees called Mike Smith as the HR system already has someone with that name.

[-] Tywele@lemmy.dbzer0.com 25 points 1 month ago
[-] Norin@lemmy.world 1 points 1 month ago

MikeSmith2.22.1989

See, Mike can’t forget his username if it’s his name and birthday.

[-] BigDanishGuy@sh.itjust.works 25 points 1 month ago

The LMS we use at my school can't handle multiple students with the same name. So we have John Smith and John Smith-2. We have like 2000 new students each year, and we have recently transitioned to this LMS. Smh

[-] PM_Your_Nudes_Please@lemmy.world 1 points 1 month ago

In this two thousand and twenty fourth year of our lord, there are still people using databases that don’t automatically append a unique number to entries to avoid this exact scenario…

[-] RegalPotoo@lemmy.world 41 points 1 month ago

I want to see the high-octane action thriller where the grizzled old hand and the renegade upstart trek to the remote compound in the woods of Montana to find Bob, the last man alive who understands how some obscure part of the IRSs core systems works and bring him back in from the cold for one last job... to save America(s neglected computer systems from decades of under investment)

[-] werefreeatlast@lemmy.world 8 points 1 month ago

AI, Sure! Here's the full code:

.....

[-] AbouBenAdhem@lemmy.world 39 points 1 month ago

We could switch to hexadecimal digits and we’d be good for 68 billion.

[-] rbn@sopuli.xyz 19 points 1 month ago

Why stop at hex? You could use the entire alphabet. Even if you take only uppercase letters and numbers, we are at 36^9 possible numbers. If we include lowercase and special characters from ASCII, we can go much further.

[-] Piafraus@lemmy.world 9 points 1 month ago* (last edited 1 month ago)

E. G. For storage and performs reasons. 5 bytes vs 9 bytes. Multiplying by amount of users and various indexes - can produce very noticeably difference. More records per page.

[-] rbn@sopuli.xyz 8 points 1 month ago* (last edited 1 month ago)

If we say that the SSN database internally only stores numbers today, but could also store hexadecimal values without significant redesigns, I would assume that SSNs are stored as text already. So no matter if you put numbers, hex or text, 9 places will always use 9 bytes (assuming it's ASCII only and doesn't support UTF-8 etc.).

Furthermore, the post implied that the current technical limit is 999,999,999. That very much sounds like a character data type to me. Otherwise, the limit is usually something like 2^x.

If SSNs are stored as numbers today, then hex and text would lead to quite some change. If you go for a re-design, you can as well just increase the length of the field.

[-] kSPvhmTOlwvMd7Y7E@lemmy.world 1 points 1 month ago

This man backs ends^

[-] palordrolap@fedia.io 9 points 1 month ago

It's all fun and games until you're assigned an SSN that contains a profanity. Because you know there's a strong chance they'll forget to implement a check for that until someone complains, and an even stronger chance that something that looks like a profanity will escape the first implementation of checks.

e.g. There will be someone assigned IMABUM123 and a) that will get through the understaffed / automated profanity check (no four letter words) and b) the person who gets it will have so many problems getting people to believe that it's really their SSN, including the people who could assign them a new one.

[-] BigDanishGuy@sh.itjust.works 8 points 1 month ago

You can actually get a new SSN already, if you have strong cultural or religious issues with your SSN https://faq.ssa.gov/en-us/Topic/article/KA-02220

So no need to implement a check in software, let the people do it for you.

[-] PM_Your_Nudes_Please@lemmy.world 1 points 1 month ago* (last edited 1 month ago)

The most common reason to get a new number is because you were the victim of identity theft. The gross part is that getting a new SSN doesn’t actually remove your old SSN. It just ties your new SSN to your old one; You can use either one interchangeably, because the new one just automatically routes back to the old one. This means there are now two numbers that can be used to steal your identity, instead of just one. And it doesn’t prevent the people who already have your old number from continuing to use it.

[-] Evil_incarnate@lemm.ee 3 points 1 month ago

Or language changes when the kids make new profanities.

[-] bokherif@lemmy.world 21 points 1 month ago

Considering there are around 330M citizens right now, I think they ran out already and they’re probably recycling them.

[-] BigDanishGuy@sh.itjust.works 27 points 1 month ago* (last edited 1 month ago)

The first SSNs were issued in 1936 https://en.wikipedia.org/wiki/Social_Security_number

According to the death master file entry in wiki 111x10^6 SSNs died between 1962 and 2018. https://en.wikipedia.org/wiki/Death_Master_File

That's 1.982 x 10^6 x deaths x year^-1. Assume that number to be a constant during the period 1936-2024

1.982 x 10^6 x deaths x year^-1 x (2024-1936) x year = 174.4 x 10^6 deaths

According to https://en.wikipedia.org/wiki/Demographics_of_the_United_States there's 335.9 x 10^6 residents, but I can't tell if they are citizens with SSNs, but I'm going to assume that for now.

So (335.9 + 174.4) x 10^6 is 510.3 x 10^6 spent SSNs.

According to the same demographics wiki article the birth rate is 11 births per 1000 population. Death rate is 10.4 deaths per 1000 population. Because I'm just doing back of the envelope estimation for fun, while trying to manage my hangover in the early afternoon, I'm not going to create an exponential function to describe population growth. Instead I'm going to only consider future the US population a constant and not consider the 200 x 10^3 annual net growth (it only affects the next year's growth by 120 anyway)

With all of that BS out of the way, at the present birthrate the US requires 3.695 x 10^6 new SSNs annually. The total amount SSNs in the current scheme is (10^9) - 1. I'm going to be leaving out the -1. 10^9 total SSNs - 510.3x^6 spent SSNs leaves 489.7 x 10^6 SSNs available. 489.7/3.695 is 132.5.

So in conclusion, assuming a constant population, the US can go for another 132.5 years with the present scheme without having to reuse any SSN.

[-] bokherif@lemmy.world 2 points 1 month ago

How about dead SSNs between ‘36 and ‘62? Great work on the calculation but all I’m saying is, if the government ran out of numbers and recycled them already, nobody would know about it. The whole situation is ridiculous if you ask me and there’s no database of SSNs you can compare it to. Weirdly enough, official government departments straight up lie about things and easily get away with it heh.

[-] BigDanishGuy@sh.itjust.works 3 points 1 month ago

How about dead SSNs between ‘36 and ‘62?

That's why I extrapolated from the 1962-2018 numbers and came to a total number of 174.4 x 10^6 deaths.

The whole situation is ridiculous if you ask me.

Oh I agree. But it's a classic issue with old databases. We had a similar issue awhile back with license plates in Denmark. The plates had been assigned inefficiently by incrementing parts annually. So we had unused ranges as well as disused plates. But somehow nobody had made a list of these plates.

[-] Th4tGuyII@fedia.io 5 points 1 month ago

You could be right about them recycling numbers already, but 330 million < 999 million, so that wouldn't be why

[-] BigDanishGuy@sh.itjust.works 5 points 1 month ago

Oh, I didn't realize that we were in the presence of a connoisseur in the ways of mathematics. /s

[-] bokherif@lemmy.world 3 points 1 month ago

Well, if only one generation passed away, that already puts us at 660M lol. Then there’s immigration, temporary issued SSNs based on work visas (huge numbers here btw) and so on.

[-] RightHandOfIkaros@lemmy.world 14 points 1 month ago

Probably recycle the oldest ones because those people will be long dead by then.

But let's not kid ourselves, everyone paying into SS right now is never going to get the benefit of it because it will have collapsed.

[-] stinerman@midwest.social 23 points 1 month ago

It can never collapse unless Congress votes to make it collapse. Even in the future once the trust fund is spent down, benefits will be reduced to what comes in from current workers. That's not the full amount but it will be something. I think something like 70%.

So it's not going to collapse unless you think that anything but full benefits is a collapse.

[-] kambusha@sh.itjust.works 8 points 1 month ago
[-] OldManBOMBIN@lemmy.world 2 points 1 month ago

"When the Overflow was noticed, everyone started updating their systems. And this causes people to fall through the cracks. Usually those people are just written off, but what we do is we take those people for ourselves."

"So you're stealing people?"

"No we're not stealing people. They don't have SSNs so they aren't technically people?"

[-] dQw4w9WgXcQ@lemm.ee 8 points 1 month ago

Norawy is facing a similar issue. Even though the national identification number is 11 digits, the first 6 are reserved for birth date. The 7th digit has some set of rules derived from which century the birth was (something like 5-9 is reserved for year 2000 and beyond). The 9th digit is even for women and odd for men. The 10th and 11th digit are fixed and derived from the rest of the numbers.

In conclusion, the system only leaves room for around 240 people per date of birth per gender (yes this system assumes 2 genders). So if the birth rate would have a spike, even just for a day, the system could be in trouble.

[-] PyroNeurosis 4 points 1 month ago

Could embiggen it by a factor of 10 by removing the gender marker.

[-] match@pawb.social 4 points 1 month ago

It'd be easier for the government to start assigning new genders

[-] dQw4w9WgXcQ@lemm.ee 2 points 1 month ago

Since the distribution of male/female is roughly 1:1, that wouldn't really do anything (except for positively being more accepting). The real solution would be to unlock one of the two last digits, but you can bet that a ton of systems will break as they validate those digits.

[-] problematicPanther@lemmy.world 7 points 1 month ago

Maybe they can just add one digit, or start using A-F

[-] ZealousSealion@discuss.tchncs.de 2 points 1 month ago

I don't know how you could possibly fit 999,999,999 people into an SSN, or even the entire current fleet of US SSNs. And I don't know how reusing numbers will help, given the time to build a new SSN. But it will undoubtedly be a disaster for the USN and the US. Hopefully, some of us outside the US, will be alive to make memes about it.

[-] Kolanaki@yiffit.net 1 points 1 month ago

Does it even have that many permutations when the first 3 and middle 2 are coded to actually mean something?

this post was submitted on 12 Oct 2024
98 points (100.0% liked)

No Stupid Questions

35830 readers
896 users here now

No such thing. Ask away!

!nostupidquestions is a community dedicated to being helpful and answering each others' questions on various topics.

The rules for posting and commenting, besides the rules defined here for lemmy.world, are as follows:

Rules (interactive)


Rule 1- All posts must be legitimate questions. All post titles must include a question.

All posts must be legitimate questions, and all post titles must include a question. Questions that are joke or trolling questions, memes, song lyrics as title, etc. are not allowed here. See Rule 6 for all exceptions.



Rule 2- Your question subject cannot be illegal or NSFW material.

Your question subject cannot be illegal or NSFW material. You will be warned first, banned second.



Rule 3- Do not seek mental, medical and professional help here.

Do not seek mental, medical and professional help here. Breaking this rule will not get you or your post removed, but it will put you at risk, and possibly in danger.



Rule 4- No self promotion or upvote-farming of any kind.

That's it.



Rule 5- No baiting or sealioning or promoting an agenda.

Questions which, instead of being of an innocuous nature, are specifically intended (based on reports and in the opinion of our crack moderation team) to bait users into ideological wars on charged political topics will be removed and the authors warned - or banned - depending on severity.



Rule 6- Regarding META posts and joke questions.

Provided it is about the community itself, you may post non-question posts using the [META] tag on your post title.

On fridays, you are allowed to post meme and troll questions, on the condition that it's in text format only, and conforms with our other rules. These posts MUST include the [NSQ Friday] tag in their title.

If you post a serious question on friday and are looking only for legitimate answers, then please include the [Serious] tag on your post. Irrelevant replies will then be removed by moderators.



Rule 7- You can't intentionally annoy, mock, or harass other members.

If you intentionally annoy, mock, harass, or discriminate against any individual member, you will be removed.

Likewise, if you are a member, sympathiser or a resemblant of a movement that is known to largely hate, mock, discriminate against, and/or want to take lives of a group of people, and you were provably vocal about your hate, then you will be banned on sight.



Rule 8- All comments should try to stay relevant to their parent content.



Rule 9- Reposts from other platforms are not allowed.

Let everyone have their own content.



Rule 10- Majority of bots aren't allowed to participate here.



Credits

Our breathtaking icon was bestowed upon us by @Cevilia!

The greatest banner of all time: by @TheOneWithTheHair!

founded 1 year ago
MODERATORS