Content of Data Privacy Tables

The data privacy tables include lookup information on companies and individuals that can be used for data masking or data privacy processing. Minor differences in data types exist, depending upon the DBMS you use to install the data privacy tables.

The tables also include country-specific data for the following countries: Australia, Canada, France, Germany, Italy, Japan, Spain, and the United States.

PERSON Table

The PERSON table contains the following columns and data:

EMPNO
Employee number. CHAR; 6 characters.
NATIONAL_ID
National ID, such as a social security number (SSN). CHAR; 20 characters.
NATIONAL_ID_TYPE
National ID type, such as USSSN for US Social Security Number. CHAR; 6 characters.
ADDR_STREET1
First line of street address. VARCHAR; 30 characters.
ADDR_STREET2
Second line of street address. VARCHAR; 30 characters.
ADDR_CITY
City. CHAR; 20 characters.
ADDR_STATE
State abbreviation. CHAR; 6 characters.
ADDR_ZIP
ZIP code. CHAR; 6 characters.
ADDR_COUNTRY
Country abbreviation. CHAR; 3 characters.
PHONE_NUMBER
Phone number, including area code. CHAR; 20 characters.
PHONE_COUNTRY
Country code for international calls. CHAR; 20 characters.
SALARY
Person's salary. DECIMAL; 11 places with 2 decimal places.
NAME_FIRST
First name. CHAR; 15 characters.
NAME_INITIAL
Middle initial. CHAR; 1 character.
NAME_LAST
Last name. CHAR; 15 characters.
NAME_FULL
Full name: first name, middle initial, and last name. VARCHAR; 40 characters.
BIRTHDATE
Birth date. DATE.
GENDER
M = Male, F = Female. CHAR; 1 character.
EMAIL
Email address. CHAR; 70 characters.
CREDITCARD
Credit card number. CHAR; 19 characters.

ADDRESS Table

The ADDRESS table contains the following columns and data:

SEQ
Unique, sequential number. INTEGER.
ADDRESS
Street address. CHAR; 50 characters.
CITY
City. CHAR; 28 characters.
STATE
State abbreviation. CHAR; 2 characters.
ZIPCODE
ZIP code. CHAR; 5 characters.
ZIPPLUS4
Extended portion of US ZIP code. CHAR; 4 characters.
Note: Data in the ADDRESS table is copyrighted by the United States Postal Service and is provided with permission.

COMPANY Table

The COMPANY table has the following columns and data:

SEQ
Unique, sequential number. INTEGER.
DATAVALUE
Company name. CHAR; 40 characters.
Note: Data in the COMPANY table is copyrighted by the United States Postal Service and is provided with permission.

FIRSTNAME Table

The FIRSTNAME table has the following columns and data:

SEQ
Unique, sequential number. INTEGER.
DATAVALUE
First name. CHAR; 15 characters.

FIRSTNAME_F Table

The FIRSTNAME_F table has the following columns and data for females:

SEQ
Unique, sequential number. INTEGER.
DATAVALUE
First name. CHAR; 15 characters.

FIRSTNAME_M Table

The FIRSTNAME_M table has the following columns and data for males:

SEQ
Unique, sequential number. INTEGER.
DATAVALUE
First name. CHAR; 15 characters.

LASTNAME Table

The LASTNAME table has the following columns and data:

SEQ
Unique, sequential number. INTEGER.
DATAVALUE
Last name. CHAR; 15 characters.


Feedback