Yes, SSNs are NOT reassignable.
At 08:41 AM 6/12/01 -0800, you wrote:
>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: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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: Hal Wigoda
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
