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:

  • 18
  • 75
  • 102
Australian Business Number

Replaces values with random Australian business numbers. Ensures that the values pass the check test.

Examples:
  • 66 325 112 895
  • 72 435 134 666
  • 93 832 434 258
Australian Company Number

Replaces values with random Australian company numbers. Ensures that the values pass the check test.

Examples:
  • 004 499 987
  • 010 749 961
  • 945 382 463
Australian Medicare Number

Replaces values with random Australian medicare numbers. Ensures that the values pass the check test.

Examples:
  • 2453 16245 1
  • 4251 32340 0
  • 6632 51126 1
Australian Medicare Provider Number

Replaces values with random Australian medicare provider numbers. Ensures that the values pass the check character test.

Examples:
  • 4024742F
  • 6235441W
  • 8530682J
Australian Tax File Numbers

Replaces values with random Australian tax file numbers. Ensures that the values pass the check test.

Examples:
  • 87653210
  • 123456782
  • 538273213

Bank Account Number

Replaces values with random 9 to 16-digit numbers

Examples:

  • 7411024398
  • 392663014671
  • 24914700572445

Bank Routing Number

Replaces values with random bank routing numbers. Ensures that the routing numbers pass the checksum test.

Examples:

  • 121122676
  • 322271627
  • 061000052
Blood Type

Replaces column data with values picked randomly from the following list:

  • A+
  • A-
  • B+
  • B-
  • AB+
  • AB-
  • O+
  • O-
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:

  • T7S T3R
  • J0L G6L
  • E4B L0V

Details:

First character:

  • Randomly picks letters from A to Z except D, F, I, O, Q, U, W, and Z

Second character:

  • Randomly picks digits from 0 to 9

Third character:

  • Randomly picks letters from A to Z except D, F, I, O, Q, and U

Fourth character:

  • Space

Fifth character:

  • Randomly picks letters from A to Z except D, F, I, O, Q, and U

Sixth character:

  • Randomly picks digits from 0 to 9

Seventh character:

  • Randomly picks letters from A to Z except D, F, I, O, Q, and U

Canada Social Insurance Number

Replaces values with random Canada Social Insurance Numbers. Ensures that the numbers pass the Luhn's validation.

Examples:

  • 688637008
  • 346612823
  • 734411531

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:

  • 688-637-008
  • 346-612-823
  • 734-411-531

China Resident ID (PRC) Number

Replaces values with random China Resident ID numbers. Resident ID numbers are in 18-character structure with 17 digits and one alphanumeric character.

Examples:

  • 618805200209090074
  • 25675120140313003X
  • 169666197511150121

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:

  • 4485780314771620
  • 6011867455059259
  • 5253901798047025

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:

  • 4485-7803-1477-1620
  • 6011-8674-5505-9259
  • 5253-9017-9804-7025
Credit Card Number (Type and Format Preserving)

Replaces values with random credit card numbers while preserving their type and format. Card types covered are American Express, Diners Club, Discover, enRoute, JCB, Mastercard, and Visa. For other card types, it preserves the number of digits and Luhn's check, but may not preserve the card type.

Examples:

  • 8345885002273499
  • 3767-733557-02372
  • 9664 6118 4386

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:

  • 377428083214575
  • 342545797384840
  • 371449635398431
Credit Card Number-Discover

Replaces values with random 16-digit Discover credit card numbers. Ensures that the numbers pass the Luhn validation.

Examples:

  • 6011174868103745
  • 6011006830091113
  • 6011326843007736

Credit Card Number-Mastercard

Replaces values with random 16-digit Mastercard credit card numbers. Ensures that the numbers pass the Luhn validation.

Examples:

  • 5233316245315286
  • 5171736663215508
  • 5479143620815877

Credit Card Number-Visa

Replaces values with random 16-digit Visa credit card numbers. Ensures that the numbers pass the Luhn validation.

Examples:

  • 4929680877575125
  • 4716403468935369
  • 4532622699903274

Date-Card Expiration

Replaces values with random dates between 2000 and present. Day is always the last day of the month.

Examples:

  • 2008-02-29
  • 2014-08-31
  • 2018-04-30

Date-Past

Replaces values with random dates from 1950 through to the present date

Examples:

  • 1970-01-01
  • 2001-08-05
  • 2018-10-16

Email Address

Replaces values with random email addresses while preserving the number of periods, hyphens, and underscores before the address sign (@). Possible top-level domains are: .com, .org, .net, .edu, .gov, .int, .us, .uk, .eu, .cn, .in, .ru, .jp, and .au.

Examples:
  • samar@example.com could become svkrpw@dmsoen.org
  • mike.williams@gmail.com could become sbvtud.ramzonibt@terim.net
  • ross_amara@gatech.edu could become qcipp_pnjetya@nbreqgp.gov

Finland Personal Identity Code

Replaces values with random Finland Personal Identity Codes

Examples:

  • 160811A0142
  • 251017A561N
  • 300399-888Y

Details:

Day of Birth:

  • Generates random 2-digit numbers between 01 and 30

Month of Birth:

  • Generates random 2-digit numbers between 01 and 12

Year of Birth:

  • Generates random 2-digit numbers between 00 and 99

Century Identification Sign:

  • Randomly picks characters from +, -, or A

Individual Number:

  • Generates random 3-digit numbers between 000 and 999

Checksum Character:

  • Randomly picks characters from 0 through 9 or from A through Z, except for G, I, O, Q, and Z

Sanity Check:

  • Uses Post Processing Function to ensure validity of the generated Personal Identity Codes

Format Preserving Randomization

Randomizes values while preserving their length, the position of letters and digits, the case of letters, and the special characters

Examples:

  • AjHjK123#@ could become SbVbU574#@
  • 678-704-7862 could become 281-272-1795
  • !@#$ remains !@#$

Gender

Replaces column data with values picked randomly from the following list:

  • Male
  • Female
  • Other

Height (Centimeter)

Replaces values with random numbers from 45 cm through 200 cm.

Examples:

  • 60
  • 162
  • 176

IBAN

Replaces values with random valid International Bank Account Numbers. IBAN are in alphanumeric character structure with 15-34 characters depending on the country.

Examples:

  • DE89370400440532013000
  • GB29NWBK60161331926819
  • FR1420041010050500013M02606

IBAN (Hyphenated)

Replaces values with random valid International Bank Account Numbers that are hyphenated. IBAN are in alphanumeric character structure with 15-34 characters depending on the country.

Examples:

  • DE89-3704-0044-0532-0130-00
  • GB29-NWBK-6016-1331-9268-19
  • FR14-2004-1010-0505-0001-3M02-606

ICD-9-CM

Replaces values with random ICD-9-CM Codes. International Classification of Diseases (ICD) code is used for classifying diseases.

Examples:

  • 328.95
  • 536
  • 600.95

ICD-10-CM

Replaces values with random ICD-10-CM Codes. International Classification of Diseases (ICD) code is used for classifying diseases.

Examples:

  • N1M.3JCM
  • E4S
  • S1H.690T

Identification Number

Replaces values with random numbers from 1 through 999,999

Examples:

  • 166050
  • 9887
  • 46803

IFSC Code

Replaces values with random valid IFSC Code. IFSC Code are in XXX0(X|9)(X|9)(X|9)(X|9)(X|9)(X|9) format where X is a letter, 0 is the number and 9 is a digit

Examples:

  • HDFC0003636
  • SBIN0010508
  • ICIC0000269

IMEI Number

Replaces values with random 15-digit IMEI numbers. Ensures that the numbers pass the Luhn validation.

Examples:

  • 490154203237518
  • 357805023984942
  • 352066060926230

Income

Replaces values with random numbers from 30,000 through 999,999

Examples:

  • 75001
  • 155000
  • 700999

IPv4

Replaces values with random valid IPv4 addresses. IPv4 addresses are in X.X.X.X where X is a number between 0 and 255

Examples:

  • 17.26.91.2
  • 186.58.207.8
  • 55.58.29.23

IPv6

Replaces values with random valid IPv6 addresses. IPv6 addresses are in X:X:X:X:X:X:X:X where X is hexadecimal value between 0 and FFFF

Examples:

  • 2001:0DB8:85A3:0000:0000:8A2E:0370:7334
  • D5AE:7B35:74EE:5E9A:C2F5:667B:3567:E6E6
  • 4C92:EE9C:E5A2:7230:2FAF:33CE:9C3E:2323

IPv6 dual

Replaces values with random valid IPv6 dual addresses. IPv6 dual addresses (ipv6+ipv4) are in y:y:y:y:y:y:x.x.x.x where y is hexadecimal value between 0 and FFFF and x is between 0 and 255

Examples:

  • 9435:8316:23FD:2B6:9B40:6B6B:176.235.52.158
  • 26E9:E8D9:1D68:2309:2062:9090:75.234.0.54
  • DF0C:F237:F442:E997:D9FE:7979:241.206.191.216

Japan My Number

Replaces values with random space separated Japan Individual Numbers

Examples:

  • 7236 6487 2376
  • 1675 8399 2830
  • 8426 9458 0492

Korea Resident Registration Number (RRN)

Replaces values with random Korea Resident Registration numbers. Resident Registration numbers are in 999999-9999999 format, where 9 signifies a digit

Examples:

  • 260429-1808049
  • 810502-1247315
  • 310803-1339475

Mac Address (Colon-Separated)

Replaces values with random valid Mac addresses. Mac addresses are in XX:XX:XX:XX:XX:XX where X is hexadecimal value between 0 and F

Examples:

  • C7:29:FF:EE:33:33
  • 08:3E:C1:81:FF:FF
  • 29:78:35:4D:00:00

Mac Address (Dot-Separated)

Replaces values with random valid Mac addresses. Mac addresses are in XXXX.XXXX.XXXX where X is hexadecimal value between 0 and F

Examples:

  • 86E6.25AE.BEBE
  • EE1E.8761.4141
  • 217C.3CD7.2727

Mac Address (Hyphenated)

Replaces values with random valid Mac addresses. Mac addresses are in XX-XX-XX-XX-XX-XX where X is hexadecimal value between 0 and F

Examples:

  • CF-4C-74-42-C4-44
  • 1E-D1-ED-DB-1D-DD
  • D8-9D-C9-9C-D9-99

Marital Status

Replaces column data with values picked randomly from the list: Single, Married, Separated, Divorced, Remarried, and Widowed

Mexico Company RFC ID

Replaces values with a 12-character structure with 3 letters, 6 digits, and 3 alphanumeric characters.

Examples:

  • GAH7706035K2
  • TRQ9003057Z9
  • MNL820622PQ4

Mexico CURP Code

Replaces values with an 18-character structure with 4 letters, 6 digits, 6 letters, and 1 alphanumeric character and 1 digit.

Examples:

  • HALW950522XBSCLCN9
  • JOFX590113MTSKSK85
  • KATE530108XBCJJJN7

Mexico Individual RFC ID

Replaces values with a 13-character structure with 4 letters, 6 digits, and 3 alphanumeric characters.

Examples:

  • ZXCV990430AB7
  • LOPM850921X1A
  • TRQN9003057Z9

Netherlands Citizen Service Number (BSN)

Replaces values with 9-digit number with a variant of the elf proof checksum: the weighted sum (9×A + 8×B + ... + 2×H - 1x I) must be divisible by 11.

Examples:

  • 706424608
  • 234567893
  • 575903041

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:

  • AjHjK123#@ could become Sbvtud
  • Michael could become Ramzoni
  • Richard Williams could become Madpalvik

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:

  • 1300
  • 5499
  • 9990

SWIFT/BIC Code (11-digit)

Replaces values with random valid SWIFT Code. Swift Code are in XXXXXX(X|9)(X|9)(X|9)(X|9)(X|9) where X is a letter and 9 is a digit

Examples:

  • ISUFUF8I665
  • DKFKFKB2DRY
  • LORSRS0CKN2

SWIFT/BIC Code (8-digit)

Replaces values with random valid SWIFT Code. Swift Code are in XXXXXX(X|9)(X|9) where X is a letter and 9 is a digit and last three characters are optional

Examples:

  • TWJLJLAK
  • ODSESEC9
  • KGOTOTKA

UK National Insurance Number (Format-Preserving)

Replaces values with random UK National Insurance numbers preserving their length and format (To be used for UK NINO data only)

Examples:

  • AA 69 94 50 A
  • ZR-50-16-33-A
  • EE 253753 D

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:

  • AA 69 94 50 A
  • ZR 50 16 33 A
  • EE 25 37 53 D

Details:

First Prefix Letter

  • Randomly picks letters from A to Z except D, F, I, Q, U, and V

Second Prefix Letter

  • Randomly picks letters from A to Z except D, F, I, Q, U, and V

6 Digits

  • Generates random 6-digit numbers

Suffix Letter

  • Randomly picks letters from A to D

Sanity Check and Formatting

  • Uses Post Processing Function to format and ensure validity of the generated National Insurance numbers
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:

  • SE1P 4SA
  • EC1A 1BB
  • SW1A 0AA

Details:

First Character:

  • Randomly picks letters from A to Z except Q, V, and X

Second Character:

  • Randomly picks letters from A to Z except I, J, and Z

Third Character:

  • Randomly picks digits from 0 to 9

Fourth Character:

  • Randomly picks letters from A, B, E, H, M, N, P, R, V, W, X, and Y

Fifth Character:

  • Space

Sixth Character:

  • Randomly picks digits from 0 to 9

Seventh Character:

  • Randomly picks letters from A to Z except C, I, K, M, O, and V

Eighth Character:

  • Randomly picks letters from A to Z except C, I, K, M, O, and V

URL

Replaces values with random URLs starting with http or https. Possible top-level domains are: .com, .org, .net, .edu, .gov, .int, .us, .uk, .eu, .cn, .in, .ru, .jp, and .au.

Examples:

  • https://www.hapiden.com
  • http://www.qazwsx937.gov
  • https://www.bhatag.in

US DEA Number

Replaces values with random US DEA Numbers with a 9-character structure with 2 letters, 6 letters and 1 checksum digit.

Examples:

  • GS7763825
  • UX3042265
  • CE4323565

US Phone Number

Replaces values with random 10-digit US phone numbers

Examples:

  • 6787047862
  • 2025550149
  • 5206625256

Details:

Area Code:

  • Randomly picks 3-digit codes from 328 US area codes

Remaining 7 Digits:

  • Generates random 7-digit numbers

Sanity Check:

  • Uses Post Processing Function to ensure validity of the generated phone numbers

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:

  • +1 (678) 704-7862
  • +1 (202) 555-0149
  • +1 (520) 662-5256

Details:

Country Code:

  • +1

Area Code:

  • Randomly picks 3-digit codes from 328 US area codes

Remaining 7 Digits:

  • Generates random 7-digit numbers

Sanity Check and Formatting:

  • Uses Post Processing Function to format and ensure validity of the generated phone numbers

US Social Security Number

Replaces values with random US Social Security numbers

Examples:

  • 148923857
  • 771182740
  • 562998392

US Social Security Number (Hyphenated)

Replaces values with random US Social Security numbers, which are in 999-99-9999 format, where 9 signifies a digit

Examples:

  • 148-92-3857
  • 771-18-2740
  • 562-99-8392

Vehicle ID Number (VIN)

Replaces values with random Vehicle ID Numbers. VINs are in 17 characters format, made up of alphanumeric characters.

Examples:

  • 5DL6Z9096QDLZLDDD
  • LAXLRQV73A2O8X222
  • 2WWHFLU6567BIW777

Weight (Pound)

Replaces values with random numbers from 5 through 250. The range covers weight in pounds.

Examples:

  • 45
  • 176
  • 210