Re: identity columns
Date: Thu, 03 Jan 2002 18:29:33 GMT
Russ News wrote:
> They use first initial + middle initial + last initial +
> the last four digits of SSN to uniquely identify it's employees. Once its
> assigned, it doesn't change even with a name change.
There are user-interface problems with:
People get upset that their unique ID still has their old name in it, especially non-technical folk.
Although, I have seen systems (a US gov't system) where the unique ID appeared to be a combination of SSN and name - and *changed* when the students name was changed. This is even worse!
-- Ben Clifford benc_at_hawaga.org.uk http://www.hawaga.org.uk/ben/ GPG: 30F06950 webcam: http://barbarella.hawaga.org.uk/benc-cgi/watchers.cgi Work required: http://www.hawaga.org.uk/~benc/resumeReceived on Thu Jan 03 2002 - 19:29:33 CET