The Generate US SSN masking activity allows you to generate social security numbers specific to the United States.
|Table of contents|
To use the Generate US SSN masking activity, it must be placed inside a table masking activity or a similar activity that iterates over data. Once placed, select the property you want to mask. Next, you must select the algorithm used to generate new social security numbers. The following algorithms are available:
You must also choose the social security number format, i.e. whether you want to use delimiters in the social security numbers or not. The following formats are available:
Additionally, you can set the EnforceUnique property to make sure every generated credit card number is unique.
In this example we want to mask US social security numbers in the Customer table, so first we place the Account masking activity and put the Generate US SSN masking activity within it. Once placed, we select the SocialSecurityNumber property. We choose Mixed as the algorithm and as the format we select the one that uses delimiters. Other properties are left as they are.
Figure 1: Generating US social security numbers
|Property group||Property name||Description||Example|
|Input properties||Algorithm||The algorithm used for generating social security numbers.||Write
|DataItemProperty||The property to mask.||Write
|EnforceUnique||If true, random selection should select unique values.||
|UseDelimiter||Whether delimiter should be used when generating social security numbers.||
|Input: Filter||Filter||Expression used for filtering records - only filtered items will be masked.||
|SkipDefaultValues||If true, default values will be omitted in masking (i.e. null values are not masked).||
|Input: Repeating||RepeaterId||The ID of the repeater that will be used to detect repeating and save results when masking item key repeats.||
|RepeatingKey||Key to use for repeating detection.||Write
|Misc||DisplayName||Display name of the activity in the workflow.||
|Result||Contains the masking definition object. It's a part of the masking infrastructure and should be ignored.||-|