Generates a new valid United States Social Security Number.
You specify the percentage of values for which to include the dashes. For columns that have a numeric data type, Structural automatically excludes the dashes.
Consistency
Yes, can be made self-consistent or consistent with another column.
Linking
No, cannot be linked.
Differential privacy
Yes, if consistency is not enabled.
Data-free
Yes, if consistency is not enabled.
Allowed for primary keys
No
Allowed for unique columns
No
Uses format-preserving encryption (FPE)
No
Privacy ranking
1 if not consistent
4 if consistent
Generator ID (for the API)
To configure the generator:
In the Percent with -'s field, type the percentage of output values for which to include dashes in the format.
For example, if you set this to 60, then 60% of the output values are formatted 123-45-6789, and 40% are formatted 123456789.
If you set this to 100, then all of the output values are formatted 123-45-6789.
If you set this to 0, then all of the output values are formatted 12345679.
For columns that have a numeric data type, Structural automatically generates the output values without dashes.
Toggle the Consistency setting to indicate whether to make the generator consistent. By default, consistency is disabled.
If you enable consistency, then by default the generator is self-consistent. To make the generator consistent with another column, from the Consistent to dropdown list, select the column. When a generator is self-consistent, then a given value in the source database is always mapped to the same value in the destination database. When a generator is consistent with another column, then a given value for that other column in the source database results in the same SSN in the destination database. For example, if the SSN column is consistent with a Name column, then every instance of John Smith in the source database results in the same SSN in the destination database.
If Structural data encryption is enabled, then to use it for this column, toggle Use data encryption process to the on position.