SSN_IN Function

Description: This function is used during inbound normalization to format Social Security Numbers (SSN) and Employer Identification Numbers (EIN) to a standard format. It recognizes the various formats in which SSNs and EINs are stored and will always return a nine-digit number. All special editing characters such as dashes and spaces will be removed. The formatted ID should then be disguised using the preferred disguise technique. It is paired with the SSN_OUT function for outbound normalization.

Parameters: String

• Source text: String containing the source value (SSN or EIN).

Return: String containing only the 9 digits of the SSN or EIN. If the value in the source string is not a known format of SSN or EIN or the value is not between 7 and 9 digits, the invalid source value actions defined in the data element will be applied. Valid formats for SSN are 123456789, 123-45-6789, and 123 45 6789. Valid formats for EIN are 123456789, 12-3456789, and 12 3456789.

Syntax: SSN_IN (<source text>)

Example: Provide a normalization expression on the SSN data element to remove any formatting from the SSN before processing.