RE: Enforced Costraints (sic) ??

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: 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: Hal Wigoda
  INET: hwigoda_at_mcs.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).