[dba-SQLServer] SSN Question

Hi Arthur:

It is legal to use it in a database situation but a client by law is not
required to give it unless the information is directly related to his/her
employment... so appropriate deductions can be made to revenue Canada. 

Convoluted? It seems an employer can request your SIN number or a bank when
you are requesting an account or credit but a store where you purchase from
can not. A lot of sites on the web, when purchasing from them leave a place
for your SIN but do not make it mandatory. A subtle difference.

SIN numbers are great for research tools. The number can suggest when the
person legally started working in Canada, whether they are a landed
immigrant or have a working visa or whether the number is fake or whether a
SIN is being copied.... (Designed a database for H&R Block a few years
back.)

I do not know about the states but I have worked under the same assumptions
and have never heard anything to the contrary.

HTH
Jim 

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of
artful at rogers.com
Sent: Saturday, August 05, 2006 9:51 AM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] SSN Question

In Canada, it is illegal to use SINs (our equivalent of SSNs) for any
purpose save Revenue Canada reporting. IOW, it is illegal to use a SIN as
the PK of some table. Does the same hold true in the USA?

TIA,
Arthur


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com