Release notesAPI docs
Information portal
Structural CloudTonic.ai

SSN

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.

Characteristics

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)

SsnGenerator

How to configure

To configure the generator:

  1. 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.

  2. Toggle the Consistency setting to indicate whether to make the generator consistent. By default, consistency is disabled.

  3. 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.

  4. If Structural data encryption is enabled, then to use it for this column, toggle Use data encryption process to the on position.

Last updated