Social Insurance Numbers

Here in Canada, our equivalent of the Social Security Number is called Social Insurance Number. It serves the same purpose and has the same demands for privacy surrounding it.

Once again, I won't be posting the full source code on the blog, only on Snipplr, but I will discuss briefly how it works. It consists of three groups of three digits, and is validated using the Luhn algorithm. I also do a quick regular expression validation to check for numbers which invalidly begin with an eight: ^([1-79]{3})[\-\s]?(\d{3})[\-\s]?(\d{3})$.

• View ASP implementation on Snipplr
• View PHP implementation on Snipplr

Social Security Numbers

Assuming that you have a legitimate need to capture social security numbers (human resources app?), you may want to validate and format them consistently. The actual code for both languages combined is a little bit too long to post, so I'll just talk about the algorithm.

A social security number is a nine-digit number and can be matched with the following regular expression: ^\d{3}\-?\d{2}\-?\d{4}$. If it can't pass this test, it's not a valid social security number. However, passing this simple test doesn't guarantee validity, so we need to keep checking.

• No digit group can consist of only zeros, and the first group cannot be 666. We check for these errors with the following regular expression: ((000|666)\-?\d{2}\-?\d{4}|\d{3}\-?00\-?\d{4}|\d{3}\-?\d{2}\-?0000.


• Numbers from 987-65-4320 to 987-65-4329 are reserved for use in advertisements, and other previously legitimate numbers have been invalidated because of use in advertisments. We check for these errors with the following regular expression: 987\-?65\-?432\d{1}|042\-?10\-?3580|062\-?36\-?0749|078\-?05\-?1120|095\-?07\-?3645|128\-?03\-?6045|135\-?01\-?6629|141\-?18\-?6941|165\-?(16|18|20|22|24)\-?7999|189\-?09\-?2294|212\-?09\-?(7694|9999|219\-?09\-?9999|306\-?30\-?2348|308\-?12\-?5070|468\-?28\-?8779|549\-?24\-?1889)


• Last but not least, the first three numbers are never higher than 772 (well, not yet; this could change in the future). For this I used a simple string conversion and numeric comparison.

The complete, commented source code is available on Snipplr:

• View ASP implementation on Snipplr
• View PHP implementation on Snipplr

Next week we'll head north of the border to my country and see what the Canadian equivalent of the Social Security Number is, and how we can validate them.

Homeland Security Advisory System

Back in 2002, a bunch of bureaucrats decided that the United States needed an advisory system so that all federal departments and agencies could communicate what the current threat condition was using the same definitions. Sounds like a good idea to me.

The average citizen can see what the current threat condition is by visiting certain government web sites. The web site for the Department of Homeland Security is a good example.

The Department of Homeland Security also provides a little-known web service which returns the threat condition in XML format so that you can do what you want with it. Let's write a function to retrieve and parse this information down to just the threat condition itself.

ASP

1. function getThreatLevel()


2.     dim regEx


3.     set regEx = new RegExp




5.     with regEx


6.         .Pattern = ".*\n.*CONDITION=""(.*)"" />"


7.         .IgnoreCase = true


8.         .Global = true


9.     end with




11.     dim xmlhttp


12.     set xmlhttp = Server.CreateObject("Msxml2.ServerXMLHTTP")


13.     xmlhttp.open "GET", "http://www.dhs.gov/dhspublic/getAdvisoryCondition", "False"


14.     xmlhttp.send




16.     getThreatLevel = regEx.replace(xmlhttp.responseText, "$1")




18.     set xmlhttp = nothing


19.     set regEx = nothing


20. end function

As is often the case, the PHP version requires a significantly less amount of code.

PHP

1. function getThreatLevel()


2. {


3.     return eregi_replace('.*CONDITION="(.*)" />', '\1', file_get_contents("http://www.dhs.gov/dhspublic/getAdvisoryCondition"));


4. }

So now we have a string that contains just the word "ELEVATED" (or whatever the current threat level is at the moment; it's been at elevated for several years at the time of this writing). What can you do with it? Feed it into a switch statement and display an image is one possibility.

• View ASP implementation on Snipplr
• View PHP implementation on Snipplr

Min/Max

SQL contains a number of aggregate functions that can do things like select the largest or smallest number from a set of values. This could be handy in the programming language itself.

ASP

1. function max(arrNumbers)
2.     dim result
4.     result = arrNumbers(0)
6.     for each i in arrNumbers
7.         if i > result then
8.             result = i
9.         end if
10.     next
12.     max = result
13. end function
15. function min(arrNumbers)
16.     dim result
18.     result = arrNumbers(0)
20.     for each i in arrNumbers
21.         if i < result then
22.             result = i
23.         end if
24.     next
26.     min = result
27. end function

View ASP implementation on Snipplr