Person Family Name Mask

This mask shall generate family names, such as "Smith", "Jones", etc.

The longest generated family name is 13 characters. If a receiving column width is shorter than a generated family name then the name shall be truncated.

Every generated family name consists of only alphabetic characters. In other words, there are no hyphenated names, and there are no apostrophes. For example, the family name O'brien would be generated as "Obrien".


Select from

Here you can specify the size of the pool of distinct family names that shall be used to generate values.

If you do not have the DataVeil Native Library installed on your DBMS then during a masking run, these names shall be uploaded during the Setup phase into a temporary table on the database being masked. It can take approximately 1 second per 10,000 names to upload. Therefore, if you choose to use 'All' Last Names then you can expect to wait an additional minute or two during the Setup phase.

The default is 10,000 of the most popular Last Names in the United States.

The maximum available is 88,800. You can also specify a custom value from 10 to 88,800.


Case of new names

Specifies the case of the masked values to be generated.

For example, "Smith" is in Title Case, "SMITH" is in Upper Case and "smith" is in Lower Case.

Note:  The case of the original name is not relevant for the selection of the masked name. For example, if the original name is "smith" and the masked value is "Jones", then the masked value for "Smith" and "SMITH" shall also be "Jones" (assuming that Deterministic mode masking is used.)


Pre/Post SQL

Please refer to the Pre/Post SQL Option.



If this mask is performed in Deterministic mode, then the results will be deterministic for a given 'Select from' value (in addition to any Deterministic Seed key, as usual).

If you want the masked results to be the same for each Run on the same input, then the 'Select from' value must also be the same on each Run.


Null and Empty Value Handling

Deterministic mode: A null or empty string is preserved.

Non-Deterministic mode: A null or empty string is overwritten with a random family name value.