Lookup tables
Introduction
XDM includes a set of masking functions that can be used to implement data masking for numerous different types of data. Most of these functions are deterministic and therefore can be used for repeated masking with the same results.
| The masking functions that use XDM’s default lookup tables require an additional setup. For detailed information, please refer to Installation of lookup tables |
Some masking methods use internal tables / dictionaries to generate data. These tables include first and last names, valid addresses including streets, cities and states, and banking information. These tables are stored in an internal database that is provided by XDM.
The following tables are available in your XDM installation:
FIRST_NAMES
This table includes male and female first names. The table is used by each masking method that generates valid first names.
Column |
Content |
Data type |
Description |
KEY_00 |
ID2 |
INTEGER |
An internal ID in sequence order that identifies the first name. This column is not unique. |
KEY_01 |
COUNTRY |
VARCHAR(256) |
The country in which the first name is usually used. The table provides names for the following countries: EN, DE, FR, IT, NL |
KEY_02 |
SEX |
VARCHAR(256) |
The gender of the first name. M for males and F for females. |
DATA_00 |
FIRST_NAME |
VARCHAR(256) |
Stores the first name. |
LAST_NAMES
This table contains valid last names. The table is used by each masking method that generates last names.
Column |
Content |
Data type |
Description |
KEY_00 |
ID |
INTEGER |
An internal ID in sequence order that identifies the last name. This column is not unique. |
KEY_01 |
COUNTRY |
VARCHAR(256) |
The country in which the last name is usually used. The table provides names for the following countries: EN, DE, FR, IT, NL |
DATA_00 |
FIRST_NAME |
VARCHAR(256) |
Stores the last name. |
ADDRESSES
This table contains valid addresses and is used by masking methods that generate components of an address, such as street names, city names, or postal codes.
Column |
Content |
Data type |
Description |
KEY_00 |
ID |
INTEGER |
An internal ID in sequence order that identifies the address. This column is not unique. |
KEY_01 |
COUNTRY |
VARCHAR(256) |
The country of the address. The table provides addresses for the following countries: US, DE, FR, IT, NL, AT, BE, CA, CH, UK |
DATA_00 |
STREET |
VARCHAR(256) |
The street of the address |
DATA_01 |
CITY |
VARCHAR(256) |
The city of the address. |
DATA_02 |
STATE |
VARCHAR(256) |
The state of the address. |
DATA_03 |
ZIP |
VARCHAR(256) |
The postal code of the address. |
DATA_04 |
LATITUDE |
DECIMAL(10, 7) |
Stores the latitude of the geographical location of the address. |
DATA_05 |
LONGITUDE |
DECIMAL(10, 7) |
Stores the longitude of the geographical location of the address. |
BANKS
This table contains data about financial institutes like bank name, BIC, BLZ. It is used by all masking methods that generate valid banking information.
Column |
Content |
Data type |
Description |
KEY_00 |
ID |
INTEGER |
An internal ID in sequence order that identifies banking entry. This column is not unique. |
KEY_01 |
COUNTRY |
VARCHAR(256) |
The country in which the bank is located. The table contains banks for the following countries: AT, CH, DE, NL |
DATA_00 |
BLZ |
VARCHAR(256) |
Stores the bank code. |
DATA_01 |
NAME |
VARCHAR(256) |
Stores the name of the financial institute. |
DATA_02 |
BIC |
VARCHAR(256) |
Stores the bank identifier code. |