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:
- Prevent internal privacy breaches by de-identifying
or masking the data available to developers, quality assurance testers,
and other personnel.
- Improve privacy compliance initiatives by substituting
customer data with contextually accurate, but fictionalized data.
- Protect confidential customer information and employee
data in your application development and testing environments.
- Ensure valid test results by propagating masked
elements across related tables to ensure the referential integrity
of the database.
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.