May 1, 2016 at 7:11 pm
create table employee_id_mapping
(
employee_id bigint identity(1000000,1),
By using bigint here you're gonna just waste the system resources.
You may have 4 records in your database per every possible SSN number and still stay within the capacity of int data type.
That's if your company is gonna employ every USA citizen.
And for some reason, I do not think that's what is gonna happen.
_____________
Code for TallyGenerator
May 2, 2016 at 6:33 am
Sergiy (5/1/2016)
create table employee_id_mapping
(
employee_id bigint identity(1000000,1),
By using bigint here you're gonna just waste the system resources.
You may have 4 records in your database per every possible SSN number and still stay within the capacity of int data type.
That's if your company is gonna employ every USA citizen.
And for some reason, I do not think that's what is gonna happen.
Good point, sir. Thanks.
May 4, 2016 at 9:55 am
For "older" social security numbers, the range is LESS than the theoretical 1 billion numbers.
According to Wikipedia, the US Social Security Number does NOT include a check digit dependent upon the preceding digits. (Canada does, so its 9-digit format yields a number range of 8 digits plus a modulo 10 calculated digit).
However, some US numbers are not allowed:
-Numbers with all zeros in any digit group (000-##-####, ###-00-####, ###-##-0000)
-Numbers with 666 or 900-999 (Individual Taxpayer Identification Number) in the first digit group
Before full randomization starting June 25, 2011, the number assignation process was based on a pattern involving the area (AAA) and "group" (GG) followed by a4-digit serial number (AAA-GG-SSSS).
May 4, 2016 at 10:10 am
j-1064772 (5/4/2016)
For "older" social security numbers, the range is LESS than the theoretical 1 billion numbers.According to Wikipedia, the US Social Security Number does NOT include a check digit dependent upon the preceding digits. (Canada does, so its 9-digit format yields a number range of 8 digits plus a modulo 10 calculated digit).
However, some US numbers are not allowed:
-Numbers with all zeros in any digit group (000-##-####, ###-00-####, ###-##-0000)
-Numbers with 666 or 900-999 (Individual Taxpayer Identification Number) in the first digit group
Before full randomization starting June 25, 2011, the number assignation process was based on a pattern involving the area (AAA) and "group" (GG) followed by a4-digit serial number (AAA-GG-SSSS).
Interesting, I didn't know it's a randomized assignment now.
Viewing 4 posts - 46 through 48 (of 48 total)
You must be logged in to reply to this topic. Login to reply