Data privacy tables

Data privacy tables are available to clients who have an Optim™ Data Privacy License. Use the tables to mask company and personal data such as employee names, customer names, social security numbers, credit card numbers, and email addresses. Use the tables to generate transformed data that is both unique and valid within the context of the application.

You can use the data privacy tables to:

Each category of personal data is provided in a separate table for the following countries (abbreviations are in parentheses): Australia (AU), Canada (CA), France (FR), Germany (DE), Italy (IT), Japan (JP), Spain (ES), United Kingdom (UK), and United States (US). Each table includes a column of sequential numbers that is used with lookup policies that use hash values to select a row in the lookup table.

Each table name is composed of a country abbreviation prefix and the category (countryabbreviation_category). For example, the address table for Canada is named CA_ADDRESSES and the address table for Germany is named DE_ADDRESSES.

The schema includes the following categories:

ADDRESSES
Tables that include columns for street address, city, locality (e.g., state or province), and postal code.
FIRSTNAME
Tables that include a column with male and female given names.
FIRSTNAME_F
Tables that include a column with female given names.
FIRSTNAME_M
Tables that include a column with male given names.
LASTNAME
Tables that include a column with family names.
PERSON
Tables that include columns for birth date, given name, family name, gender, phone number, national ID number, company name, and email address.
CCN
Tables that include a credit card numbers for the associated issuer (MasterCard, VISA, etc.).
DOMAIN_NAMES
Table that includes domain names for masking email addresses.


Feedback