Re: OT - SSN( Enforced Constraints (sic) ??

except check out the ssn faq and alot of those numbers are not used.

joe

PS:
http://www.faqs.org/faqs/privacy/ssn-faq/

Regina Harter wrote:
>
> When the DMV first asked for my SSN, I gave them an incorrect one, because
> as far as I'm concerned they don't need to know it. Now that they actually
> check the number with the SSA I was forced to correct it. Most places are
> forbidden to require that you supply your SSN unless they need it to report
> taxable earnings. I regularly refuse to supply mine.
>
> At 10:58 AM 6/12/01 -0800, you wrote:
> >It's interesting that SSNs are not recycled. My mother works for the SSA
> >and says they are after the person is deceased for a certain period of time
> >(I forget the specifics). Also, a lot of people get nervous when you use
> >their SSN for an identifier. I've noticed that most State Driver's Licenses
> >do not use the SSN at the license number anymore because people were getting
> >their identities stolen. The same thing goes for having it printed
> >permanently on your checks.
> >
> >Let's calculate quickly on this one:
> >
> >250,000,000 million in the U.S. (Legal)
> >999,999,999 possible numbers (xxx-xx-xxxx)
> >-----------------------------------------
> >equals mandatory recycling.
> >
> >--Michael
> >
> >-----Original Message-----
> >[mailto:Georgette.Cornio_at_cfsc.army.mil]
> >Sent: Tuesday, June 12, 2001 2:18 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >
> >There is also a problem with SSNs, if you deal with Foreign nationals.
> >We had that problem with a US Army program in Europe and Korea.
> >We had to make up Unique numbers to fit the program.
> >
> >Georgette
> >
> >-----Original Message-----
> >Sent: Tuesday, June 12, 2001 12:41
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >SSN's are not recycled.
> >
> > >From the SSA OIG's testimony on SSN use and misuse before congress -
> >
> > "The SSN is a unique identifier"
> >
> > http://www.ssa.gov/oig/Testimony05222001.htm
> >
> > SSN is a perfectly good PK for personnel systems. If you find duplicates
> > your employer certainly needs to know about it.
> >
> > I once had a personnel database with 25 years of personnel data (about
> > 1,200,000 individuals). When we loaded it into Oracle with the SSN as PK,
> > there was one duplicate SSN. Of course, that employer was very
> > conscientious about requiring a valid SSN.
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author:
> > INET: tday6_at_csc.com
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Cornio, Georgette Ms USACFSC
> > INET: Georgette.Cornio_at_cfsc.army.mil
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Jenkins, Michael
> > INET: Michael.Jenkins_at_Nextel.com
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Regina Harter
> INET: rharter_at_emc-inc.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing)

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. Testa
  INET: teci_at_the-testas.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).