Validating a social security number
I’ll provide a few different methods to handle the actual validation through Regular Expressions and let you determine which one might best suit your needs.A Social Security number (SSN) is a nine-digit number issued to U. citizens, permanent residents and temporary residents under section 205(c)(2) of the Social Security Act.However, when I copy the function into Data Validation it does not work. My ultimate goal is to have a user type the 9 digit SSN in a cell (no dashes), have data validation test to make sure it is numbers, length=9 and have it displayed ###-##-####. Thanks, James Dave, Thanks for the reply but it doesn't accomplish what I wanted.Using the settings you suggested it doesn't recognize "0" as a leading number (when the SSN starts with 0), and it doesn't display an error message if you enter letters instead of numbers.People® allows you to set up validation for the NI/SSN field using a regex. Regex is a technical mechanism for specifying validation rules in a very flexible way.This blog post focuses on validating the last of those : Social Security Numbers and why they may be a bit deceivingly more difficult to validate than you might expect.The data is then automatically resubmitted to SSA for validation.In addition to the SSN Validation Discrepancy Report, a SSN Validation Reminder Report is also produced each month.
REQUESTS FOR MANUAL VALIDATIONS The social security number (SSN) validation system was implemented as part of the federally mandated Income and Eligibility Verification System (IEVS).
Twice each month (first of the month and middle of the month), the State sends information to the Social Security Administration (SSA) via the Network Data Mover (NDM).
RESOLVING DISCREPANCIES WHEN INCORRECT DATA VALIDATES IV. This updates MCI with the most current information in EIS.
SSA compares the vital data to its NUMIDENT file, which is the file used by SSA to issue numbers to wage earners.
The validation process with SSA does not require an exact match, and some SSN’s validate even though you have verified vital data that is slightly different.
These are marked with a “D” (for Duplicate) on the MCI validation screen.