How To Mask a US Social Security Number (SSN)

DataVeil has a built-in mask specifically designed to mask United States Social Security Numbers (SSN) that is very simple to configure.

Step 1: Right-click on your database SSN column and choose “Add Mask…”

how-ssn-1

Step 2: Choose “National Identifier” and then “United States – Social Security Number (SSN)”

how-ssn-2
how-ssn-3

Step 3: Configure the Social Security Number mask

 

The Social Security Number mask is shown with a default configuration.

A DataVeil project is deterministic by default and so the ‘Deterministic parameters’ are enabled and the Non-Deterministic parameters are disabled.

You can override the determinism for this mask in the mask’s Determinism tab or change the project default determinism in the main window’s Setting tab.

Typically, deterministic is a preferred setting because it will ensure that all instances of a specific SSN will be masked consistently throughout the database, even on repeated masking executions.

As you can see, the default deterministic setting is such that the first 3 digits fo an SSN are preserved.

how-ssn-4

If you want to see a preview of what the actual before and after masking values will look like then you can click on the Preview Run icon

preview_icon

This will perform all the normal masking functions on a small sample of the actual data without actually writing the masked values to the database. Below, you can see the before and after masking values, side by side, in the DataVeil Data Browser window. As you can see, the first 3 didgits are preserved and the remainder are masked.

DataVeil will always mask valid SSNs with valid SSN number ranges.

Also note that the preview column shows “(Preview)” to indicate that the masked value is just a preview and therefore the original value in the database has not yet been masked.

how-ssn-5