Can Oracle Validate a Social Security Number Against Invalid Combinations?
Last updated on DECEMBER 20, 2016
Applies to:
Oracle HRMS (US) - Version 11.5.10.2 and laterInformation in this document applies to any platform.
***Checked for relevance on 14-Jun-2013***
Goal
Does Oracle validate the actual number sequences for Social Security Numbers?
Example:
There are certain Social Security numbers which are invalid (impossible) as per the Social Security office.
According to the SSN website
http://ssa-custhelp.ssa.gov/cgi-bin/ssa.cfg/php/enduser/std_adp.php?p_faqid=425 the following combinations are not valid:
"An invalid (or impossible) Social Security number (SSN) is one which has not yet been assigned.
The SSN is divided as follows: the area number (first three digits), group number (fourth and fifth digits), and serial number (last four digits).
To determine if an SSN is invalid consider the following: No SSNs with an area number in the 800 or 900 series, or "000" area number, have been assigned. No SSNs with an area number above 772 have been assigned in the 700 series.
No SSN's with a "00" group number or "0000" serial number have been assigned. No SSNs with an area number of "666" have been or will be assigned."
Does Oracle provide any validation against these invalid combinations as specified by the government? Client needs validation against these invalid combinations.
Solution
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms