Lap Time Results??? Who's in charge?

[kl3640]

I would stay away from the SSN only because it is not guaranteed to be unique.  A GUID that is generated either by the database or an application would be a better option I think.  Once you have that number assigned.... it's yours.... if you leave CCS and come back years later, if they still have you in their system, you still have the same GUID.

Only drawback from a programmer perspective is it's a PITA to find any related information for a particular person cause you have to type in a long GUID instead of an integer (assuming you used an identity field for a key).

That would be fine so long as the datatype for the GUID is sufficiently manageable to allow easy integration with their existing paper-based systems during the transition, and to allow it to be easily placed on race licenses, to have a field on registration and other forms, etc.  Something like a 6-digit INT would be fine, although a change from the existing #'s would have to occur during the license renewal period as a switch during mid-season to different identifiers would be unmanageable since CCS's existing paper-based systems likely rely heavily on the existing key.