RE: OT - SSN( Enforced Constraints (sic) ??
Hell, when I joined the gym they asked for it. I asked them what they needed for and they said they didn't and I did not have to supply it. Duh... I find it amazing how much they ask for the SSN here in the US. I don't recall being asked for my Social Insurance number this much back home in Canada. Hum, and there is less stealing of identities there. Hey, I may be onto something there -Original Message- Sent: Tuesday, June 12, 2001 3:33 PM To: Multiple recipients of list ORACLE-L When the DMV first asked for my SSN, I gave them an incorrect one, because as far as I'm concerned they don't need to know it. Now that they actually check the number with the SSA I was forced to correct it. Most places are forbidden to require that you supply your SSN unless they need it to report taxable earnings. I regularly refuse to supply mine. At 10:58 AM 6/12/01 -0800, you wrote: It's interesting that SSNs are not recycled. My mother works for the SSA and says they are after the person is deceased for a certain period of time (I forget the specifics). Also, a lot of people get nervous when you use their SSN for an identifier. I've noticed that most State Driver's Licenses do not use the SSN at the license number anymore because people were getting their identities stolen. The same thing goes for having it printed permanently on your checks. Let's calculate quickly on this one: 250,000,000 million in the U.S. (Legal) 999,999,999 possible numbers (xxx-xx-) - equals mandatory recycling. --Michael -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 2:18 PM To: Multiple recipients of list ORACLE-L There is also a problem with SSNs, if you deal with Foreign nationals. We had that problem with a US Army program in Europe and Korea. We had to make up Unique numbers to fit the program. Georgette -Original Message- Sent: Tuesday, June 12, 2001 12:41 To: Multiple recipients of list ORACLE-L 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: Cornio, Georgette Ms USACFSC 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: Jenkins, Michael 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: Regina Harter 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
RE: OT - SSN( Enforced Constraints (sic) ??
When the DMV first asked for my SSN, I gave them an incorrect one, because as far as I'm concerned they don't need to know it. Now that they actually check the number with the SSA I was forced to correct it. Most places are forbidden to require that you supply your SSN unless they need it to report taxable earnings. I regularly refuse to supply mine. At 10:58 AM 6/12/01 -0800, you wrote: It's interesting that SSNs are not recycled. My mother works for the SSA and says they are after the person is deceased for a certain period of time (I forget the specifics). Also, a lot of people get nervous when you use their SSN for an identifier. I've noticed that most State Driver's Licenses do not use the SSN at the license number anymore because people were getting their identities stolen. The same thing goes for having it printed permanently on your checks. Let's calculate quickly on this one: 250,000,000 million in the U.S. (Legal) 999,999,999 possible numbers (xxx-xx-) - equals mandatory recycling. --Michael -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 2:18 PM To: Multiple recipients of list ORACLE-L There is also a problem with SSNs, if you deal with Foreign nationals. We had that problem with a US Army program in Europe and Korea. We had to make up Unique numbers to fit the program. Georgette -Original Message- Sent: Tuesday, June 12, 2001 12:41 To: Multiple recipients of list ORACLE-L 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: Cornio, Georgette Ms USACFSC 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: Jenkins, Michael 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: Regina Harter 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).
Re: OT - SSN( Enforced Constraints (sic) ??
except check out the ssn faq and alot of those numbers are not used. joe PS: http://www.faqs.org/faqs/privacy/ssn-faq/ Regina Harter wrote: When the DMV first asked for my SSN, I gave them an incorrect one, because as far as I'm concerned they don't need to know it. Now that they actually check the number with the SSA I was forced to correct it. Most places are forbidden to require that you supply your SSN unless they need it to report taxable earnings. I regularly refuse to supply mine. At 10:58 AM 6/12/01 -0800, you wrote: It's interesting that SSNs are not recycled. My mother works for the SSA and says they are after the person is deceased for a certain period of time (I forget the specifics). Also, a lot of people get nervous when you use their SSN for an identifier. I've noticed that most State Driver's Licenses do not use the SSN at the license number anymore because people were getting their identities stolen. The same thing goes for having it printed permanently on your checks. Let's calculate quickly on this one: 250,000,000 million in the U.S. (Legal) 999,999,999 possible numbers (xxx-xx-) - equals mandatory recycling. --Michael -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 2:18 PM To: Multiple recipients of list ORACLE-L There is also a problem with SSNs, if you deal with Foreign nationals. We had that problem with a US Army program in Europe and Korea. We had to make up Unique numbers to fit the program. Georgette -Original Message- Sent: Tuesday, June 12, 2001 12:41 To: Multiple recipients of list ORACLE-L 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: Cornio, Georgette Ms USACFSC 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: Jenkins, Michael 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: Regina Harter 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) -- Joe Testa