Federal Tax ID:

[FoxLearner]

Hi
Did any of you do validations for a Federal Tax Id? If so can I use/see the code for the validation?

Thnaks and Regards
FoxLearner

 

[dbMark]

From your question on how to validate, I'd guess you also store the hyphens as well in your fields. Here is the format difference between SSN and TIN, note that both are composed of 9 numbers:

123-456-789 - Social Security number
12-3456789 - Federal Tax ID number

Try this, and use whichever case tests you decide you need, or adjust as needed:

tin="12-3456789"
do case
case len(tin)<>10  && use this if you require all 10 chars
   ? &quot;Incorrect length for valid TIN (nn-nnnnnnn)&quot;
case len(tin)=10 and substr(tin,3,1)<>&quot;-&quot;
   ? &quot;Format incorrect for valid TIN (nn-nnnnnnn)&quot; 
case len(chrtran(tin,&quot;-&quot;,&quot;&quot;))<>9
   ? &quot;Incorrect length for valid TIN (9 numbers)&quot; 
case chrtran(tin,&quot;-&quot;,&quot;&quot;)<>padl(ltrim(str(val(chrtran(tin,&quot;-&quot;,&quot;&quot;)),9,0)),9,&quot;0&quot;)
   ? &quot;Nine numbers required for valid TIN&quot; 
endcase

 

[jesylv]

In general, SSN and credit card numbers uses a scheme to ensure valid numbers are given. Credit card uses Modulo10 approach to determine what the last digit will be. (The first 15 digits determine the value of the last one). I suspect the same applies to FTN.


Jean

 

[mkrausnick]

Try looking at

http://www.irs.gov.

Maybe they have some information about valdiating tax ids. I do some rudimentary validation of SSNs using info from

http://www.ssa.gov.

Mike Krausnick
Dublin, California

 

[dbMark]

This SSA page has a few links to help employers determine whether a Social Security Number may be valid or invalid is found here. The short answer is that numbers beginning with 000 will always be invalid and as of this month (August 2003) they have not issued any 3-digit beginning numbers higher than 772.

http://www.ssa.gov/employer/ssnv.htm

To be absolutely sure of a SSN's validity, the employer would have to submit names and numbers to the SSA, but there are rules and guidelines on how the employer prepares and submits his list. You know, to avoid possible discrimination, etc.

I don't know about confirming employer IDs, either state or federal. I do know that the federal numbers have 2 digits, a dash and then the rest of the number.