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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: OT - SSN( Enforced Constraints (sic) ??

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

From: Regina Harter <rharter_at_emc-inc.com>
Date: Tue, 12 Jun 2001 14:35:10 -0700
Message-ID: <F001.003268BB.20010612143257@fatcity.com>

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).
Received on Tue Jun 12 2001 - 16:35:10 CDT

Original text of this message

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