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.