Predefined Masking Formats
To help you mask common sensitive and personal data, such as credit card numbers, phone numbers, and national identifiers, Oracle Data Safe provides predefined masking formats. You can use predefined masking formats as is without providing any input. You cannot edit or delete predefined masking formats.
The following table describes the predefined masking formats.
Masking Format | Description |
---|---|
Age |
Replaces values with random numbers from 0 through 110 Examples:
|
Australian Business Number |
Replaces values with random Australian business numbers. Ensures that the values pass the check test. Examples:
|
Australian Company Number |
Replaces values with random Australian company numbers. Ensures that the values pass the check test. Examples:
|
Australian Medicare Number |
Replaces values with random Australian medicare numbers. Ensures that the values pass the check test. Examples:
|
Australian Medicare Provider Number |
Replaces values with random Australian medicare provider numbers. Ensures that the values pass the check character test. Examples:
|
Australian Tax File Numbers |
Replaces values with random Australian tax file numbers. Ensures that the values pass the check test. Examples:
|
Bank Account Number |
Replaces values with random 9 to 16-digit numbers Examples:
|
Bank Routing Number |
Replaces values with random bank routing numbers. Ensures that the routing numbers pass the checksum test. Examples:
|
Blood Type |
Replaces column data with values picked randomly from the following list:
|
Canada Postal Code (Space-Separated) | Replaces values with random Canada postal codes, which are in A9A A9A format, where A signifies a letter and 9 signifies a digit
Examples:
Details: First character:
Second character:
Third character:
Fourth character:
Fifth character:
Sixth character:
Seventh character:
|
Canada Social Insurance Number |
Replaces values with random Canada Social Insurance Numbers. Ensures that the numbers pass the Luhn's validation. Examples:
|
Canada Social Insurance Number (Hyphenated) |
Replaces values with random Canada Social Insurance Numbers, which are in 999-999-999 format, where 9 signifies a digit. Ensures that the numbers pass the Luhn validation. Examples:
|
Credit Card Number |
Replaces values with random credit card numbers. Generates card numbers of types: American Express, Diners Club, Discover, enRoute, JCB, Mastercard, and Visa. Ensures that the numbers pass the Luhn validation. Examples:
|
Credit Card Number (Hyphenated) |
Replaces values with random hyphenated credit card numbers. It generates card numbers of type: American Express, Diners Club, Discover, enRoute, JCB, Mastercard, and Visa. Ensures that the numbers pass the Luhn validation. Examples:
|
Credit Card Number-American Express |
Replaces values with random 15-digit American Express credit card numbers. Ensures that the numbers pass the Luhn validation. Examples:
|
Credit Card Number-Discover |
Replaces values with random 16-digit Discover credit card numbers. Ensures that the numbers pass the Luhn validation. Examples:
|
Credit Card Number-Mastercard |
Replaces values with random 16-digit Mastercard credit card numbers. Ensures that the numbers pass the Luhn validation. Examples:
|
Credit Card Number-Visa |
Replaces values with random 16-digit Visa credit card numbers. Ensures that the numbers pass the Luhn validation. Examples:
|
Date-Card Expiration |
Replaces values with random dates between 2000 and present. Day is always the last day of the month. Examples:
|
Date-Past |
Replaces values with random dates from 1950 through to the present date Examples:
|
Email Address |
Replaces values with random email addresses while preserving the number of periods, hyphens, and underscores before the address sign ( Examples:
|
Finland Personal Identity Code |
Replaces values with random Finland Personal Identity Codes Examples:
Details: Day of Birth:
Month of Birth:
Year of Birth:
Century Identification Sign:
Individual Number:
Checksum Character:
Sanity Check:
|
Format Preserving Randomization |
Randomizes values while preserving their length, the position of letters and digits, the case of letters, and the special characters Examples:
|
Gender |
Replaces column data with values picked randomly from the following list:
|
Height (Centimeter) |
Replaces values with random numbers from 45 cm through 200 cm. Examples:
|
Identification Number |
Replaces values with random numbers from 1 through 999,999 Examples:
|
IMEI Number |
Replaces values with random 15-digit IMEI numbers. Ensures that the numbers pass the Luhn validation. Examples:
|
Income |
Replaces values with random numbers from 30,000 through 999,999 Examples:
|
Marital Status |
Replaces column data with values picked randomly from the list: Single, Married, Separated, Divorced, Remarried, and Widowed |
Race |
Replaces column data with values picked randomly from the list: White, African American, Asian, American Indian, Alaska Native, Native Hawaiian, and Other Pacific Islander |
Random Name |
Replaces values with random letters of random length. Compatible with character type columns only. Examples:
|
Religion |
Replaces column data with values picked randomly from the list: Christianity, Islam, Nonreligious, Hinduism, Buddhism, Sikhism, Jainism, Judaism, and Other |
Sexual Orientation |
Replaces column data with values picked randomly from the list: Heterosexual, Homosexual, Bisexual, and Asexual |
Stock |
Replaces values with random numbers from 100 through 9,999 Examples:
|
UK National Insurance Number (Space-Separated) |
Replaces values with random UK National Insurance numbers, which are in AA 99 99 99 A format, where A signifies a letter and 9 a digit Examples:
Details: First Prefix Letter
Second Prefix Letter
6 Digits
Suffix Letter
Sanity Check and Formatting
|
UK Postal Code (Space-Separated) |
Replaces values with random UK postal codes, which are in AA9A 9AA format, where A signifies a letter and 9 a digit Examples:
Details: First Character:
Second Character:
Third Character:
Fourth Character:
Fifth Character:
Sixth Character:
Seventh Character:
Eighth Character:
|
URL |
Replaces values with random URLs starting with Examples:
|
US Phone Number |
Replaces values with random 10-digit US phone numbers Examples:
Details: Area Code:
Remaining 7 Digits:
Sanity Check:
|
US Phone Number (With Country Code) |
Replaces values with random US phone numbers, which are in +1 (999) 999-9999 format, where 9 signifies a digit Examples:
Details: Country Code:
Area Code:
Remaining 7 Digits:
Sanity Check and Formatting:
|
US Social Security Number |
Replaces values with random US Social Security numbers Examples:
|
US Social Security Number (Hyphenated) |
Replaces values with random US Social Security numbers, which are in Examples:
|
Weight (Pound) |
Replaces values with random numbers from 5 through 250. The range covers weight in pounds. Examples:
|