Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Validating Social Security Numbers

Validating Social Security Numbers

From: Jeff Bangle <JBangle_at_erols.com>
Date: 1997/04/15
Message-ID: <33542A40.7815@erols.com>#1/1

I have two questions related to using SSNs in computer databases:

  1. According to several sources, including the Social Security Administration (see below), the first three digits of each SSN represent the geographic location where the number was issued.

    http://www.ssa.gov/history/geonumb.html

Using the list at the above web page as a guide, I checked our internal database and found that about one percent of our records had "impossible" SSNs. Are all SSNs that don't match the list above definitely incorrect?

2. I've heard several times over the years that the Social Security Administration has started "reusing" SSNs from people who died many years ago. Is this true? It would be a major pain to modify our database to accept duplicate SSNs and still uniquely identify people. Received on Tue Apr 15 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US