Built-In Identifiers
Last updated
Last updated
In previous documentation, identifier is referred to as classifier. The language is being updated to identifier to be more accurate and not conflate meaning with the Immuta data classification and frameworks feature.
| Identifier | Description |
|---|
AGE | Matches numeric strings between 10 and 199, provided the column header contains text such as |
ARGENTINA_DNI_NUMBER | Matches strings consistent with Argentina National Identity (DNI) Number. Requires an eight-digit number with optional periods between the second and third and fifth and sixth digit. Tags include |
AUSTRALIA_MEDICARE_NUMBER | Matches numeric strings consistent with Australian Medicare number. Requires a ten- or eleven-digit number. The starting digit must be between 2 and 6, inclusive. Optional spaces can be placed between the fourth and fifth and ninth and tenth digit. The optional 11th digit separated by a |
AUSTRALIA_PASSPORT | Matches strings consistent with Australian Passport number. An 8- or 9-character string is required, with a starting upper case character (N, E, D, F, A, C, U, X) or a two-character starting character (P followed by A, B, C, D, E, F, U, W, X, or Z) followed by seven digits. Tags include |
AUSTRALIA_TAX_FILE_NUMBER | Matches strings consistent with Australian Tax File number. Requires a nine-digit number with optional spaces between the third and fourth and sixth and seventh digits. A checksum is required. Tags include |
BELGIUM_NATIONAL_ID_CARD_NUMBER | Matches numeric strings consistent with Belgium's National ID card. Requires a twelve-digit number with hyphen ( |
BITCOIN_INVOICE_ADDRESS | Matches strings consistent with the following Bitcoin Invoice Address formats: P2PKH, P2SH, and Bech32. P2PKH and P2SH must start with a 1 or a 3, respectively, followed by 25 - 34 alphanumeric characters, excluding l, I, O, and 0. Bech32 formats must begin with |
BRAZIL_CPF_NUMBER | Matches a numeric string consistent with Brazil's CPF (Cadastro Pessoal de Pessoa Física) number. An eleven-digit numeric string with non-numeric separators after the third, sixth, and ninth digits. A two digit checksum is required. Tags include |
CANADA_BC_PHN | Matches numeric strings consistent with British Columbia's Personal Health Number (PHN). Requires a ten-digit numeric string with optional hyphen ( |
CANADA_DRIVERS_LICENSE_NUMBER | Matches strings consistent with Canadian driver's license numbers from each province. Looks for strings to be consistent with at least one of seven patterns. Tags include |
CANADA_OHIP | Matches alphanumeric strings consistent with Ontario's Health Insurance Plan (OHIP). Requires a twelve-digit alphanumeric code. Optional hyphens ( |
CANADA_PASSPORT |
CANADA_QUEBEC_HIN | Matches alphanumeric strings consistent with Quebec's Health Insurance Number (HIN). Requires four alphabetic characters followed by an optional space or hyphen ( |
CANADA_SOCIAL_INSURANCE_NUMBER | Matches numeric strings consistent with the Canadian Social Insurance number format. Requires a nine-digit numeric string with optional hyphens or spaces after the third and sixth digit. The last digit is a checksum. Tags include |
CREDIT_CARD_NUMBER | Matches strings consistent with a credit card number. Must include a valid checksum. Tags include |
DATE | Matches strings consistent with dates. These can include days of the week, dates, and date times. Tags include |
DATE_OF_BIRTH | Matches date strings as Date of Birth if the column heading is |
DENMARK_CPR_NUMBER | Matches numeric strings consistent with Personal Identification Number (CPR-number or Person-number). Requires a ten-digit number with either a |
DOMAIN_NAME | Matches domain names using a very broad pattern. Tags include |
EMAIL_ADDRESS | Matches strings consistent with an email address. Usernames are required to be fewer than 255 characters, follow by |
ETHNIC_GROUP | Matches strings consistent with the US Census race designations. Tags include |
FDA_CODE | Matches a string consistent with a drug or ingredient registered with Food and Drug Administration (FDA). Must start with between 4 to 6 digits, followed by a hyphen, followed by 3 to 4 digits, followed by a hyphen, and finishing with one to two digits. Tags include |
FINLAND_NATIONAL_ID_NUMBER | Matches a string consistent with Finland's National ID number. Requires an eleven-character string in a |
FRANCE_CNI | Matches numeric strings consistent with the French National ID card number (carte nationale d'identité). Requires a twelve-digit numeric string. Tags include |
FRANCE_NIR | Matches numeric strings consistent with France's National ID number (Numéro d'Inscription au Répertoire). Requires a fifteen-digit numeric string. An optional hyphen ( |
FRANCE_PASSPORT | Matches alphanumeric strings consistent with the French Passport number. Requires two numbers followed by two upper case letters and ends with 5 digits. Tags include |
GENDER | Matches strings consistent with gender. Tags include |
GERMANY_DRIVERS_LICENSE_NUMBER | Matches alphanumeric strings consistent with Germany's Driver's License number. Requires an eleven-element string, with a digit or a letter followed by two digits, 6 digits or letters, one digit, and one digit or letter. Tags include |
GERMANY_IDENTITY_CARD_NUMBER | Matches alphanumeric strings consistent with Germany's Identity Card number. Requires a single letter followed by eight digits. Tags include |
IBAN_CODE | Matches strings consistent with an International Bank Account Number (IBAN). Must contain a valid country code. Tags include |
ICD10_CODE | Matches strings consistent with codes from the International Statistical Classification of Diseases and Related Health Problems (ICD), as drawn from the Clinical Modification lexicon from the year 2020. Tags include |
IMEI_HARDWARE_ID | Matches strings consistent with an International Mobile Equipment Identity (IMEI) number. Must contain 15 digits with optional hyphens or spaces after the second, 8th, and 14th digits. Tags include |
IP_ADDRESS | Matches IP Addresses in the V4 and V6 formats. Tags include |
LOCATION | Matches strings consistent with Countries, States, Addresses, or Municipalities. By default focuses on locations in the United States. Tags include |
MAC_ADDRESS | Matches strings consistent with a Media Access Control (MAC) address. Must contain twelve hexadecimal digits, with every two digits separated by a colon. Tags include |
MAC_ADDRESS_LOCAL | Matches strings consistent with a local Media Access Control (MAC) address. Tags include |
PERSON_NAME | Matches strings consistent with a dictionary of people's names. US person names are drawn from the US Social Security database. Tags include |
PHONE_NUMBER | Matches strings consistent with telephone numbers. Primarily looks for strings consistent with the United States telephone numbers naming convention. Tags include |
POSTAL_CODE | Matches strings consistent with a valid US zip code with an optional +4. Only valid 5 digit zip codes are matched. Tags include |
SPAIN_DRIVERS_LICENSE_NUMBER | Matches alphanumeric strings consistent with Spain's Driver's License number. Requires eight digits followed by a single letter or digit. The final digit acts as a checksum. Tags include |
SPAIN_NIE_NUMBER | Matches strings consistent with Spain's Foreigner Identification number. Requires an eight-character string. The initial character must be X, Y, or Z, followed by seven digits, then by an optional hyphen or space and a single checksum character. Tags include |
SPAIN_NIF_NUMBER | Matches strings consistent with Spain's Tax Identification number. Requires an eight-character string. Requires eight digits followed by an optional hyphen or space and a single checksum character. Tags include |
SPAIN_PASSPORT | Matches strings consistent with Spain's Passport number. Requires an eight- or nine-character string, starting with either two or three letters followed by six digits. Tags include |
STREET_ADDRESS | Matches strings consistent with street addresses. Primarily looks for strings consistent with the United States street naming convention. Tags include |
SWEDEN_NATIONAL_ID_NUMBER | Matches numeric strings consistent with Sweden's Nation ID number. Requires a ten- or twelve-digit string that must start with a date in either the |
SWEDEN_PASSPORT | Matches numeric strings consistent with Sweden's Passport number. Requires an 8-digit number. Tags include |
SWIFT_CODE | Matches alphanumeric strings consistent with a SWIFT code (or Bank Identifier Code (BIC)) format. Tags include |
THAILAND_NATIONAL_ID_NUMBER | Matches strings consistent with Thailand's National ID number. Requires a 13-digit number with optional spaces or hyphens ( |
TIME | Matches strings consistent with times. Can contain both date and time pieces. Tags include |
UK_DRIVERS_LICENSE_NUMBER | Matches alphanumeric strings consistent with the United Kingdom's Driver's License number. Requires either a 16- or 18-character string. The first five characters represent the driver's surname, padded with |
UK_NATIONAL_INSURANCE_NUMBER | Matches alphanumeric strings consistent with the United Kingdom's National Insurance number. Requires a nine-character string. The first two digits must be letters, followed by an optional space, then six digits with optional spaces or hyphens ( |
UK_PASSPORT | Matches numeric strings consistent with the United Kingdom's passport number. Requires a nine-digit numeric string. Tags include |
UK_TAXPAYER_REFERENCE | Matches ten-digit numeric strings consistent with UK Taxpayer Reference (UTR) numbers. The final digit is a checksum. Tags include |
URL | Matches string consistent with a Uniform Resource Locator (URL). String must begin with |
US_ADOPTION_TAXPAYER_IDENTIFICATION_NUMBER | Matches a numeric string consistent United States Adoption Taxpayer Identification Number (ATIN). Requires a string similar in format to a US Social Security Number, but starting with a 9 in the Area Number and having 93 as an allowed Group Number. Tags include |
US_BANK_ROUTING_MICR | Matches numeric string consistent with an American Bankers Association (ABA) Routing Number. Must be a nine-digit number starting with 0, 1, 2, 3, 6, or 7, followed by eight digits. The final digit is a checksum. Tags include |
US_DEA_NUMBER | Matches alphanumeric strings consistent with a Drug Enforcement Administration (DEA) number that is assigned to a health care provider. Must be a length of nine characters. The first two digits must be alphanumeric, and the last seven digits must be digits. The final digit is a checksum. Tags include |
US_DRIVERS_LICENSE_NUMBER | Matches strings consistent with some US Driver's license numbers. Tags include |
US_EMPLOYER_IDENTIFICATION_NUMBER | Matches numeric string consistent United States Employer Identification Number (EIN). Strings must contain nine digits with a hyphen after the second digit. Tags include |
US_HEALTHCARE_NPI | Matches numeric strings consistent with US National Provider Identifier (NPI). Strings must be either 10 or 15 digits with the final digit being a valid checksum. Tags include |
US_INDIVIDUAL_TAXPAYER_IDENTIFICATION_NUMBER | Matches a numeric string consistent United States Individual Taxpayer Identification Number (ITIN). Requires a string similar in format to a US Social Security Number, but starting with a 9 in the Area Number and having a limited set of allowed Group Numbers. Tags include |
US_PASSPORT | Matches numeric strings consistent with United States Passport number. Strings must contain nine digits. Columns should have a name or label consistent with a passport. Tags include |
US_PREPARER_TAXPAYER_IDENTIFICATION_NUMBER | Matches strings consistent with a Preparer Taxpayer ID number. Strings must have nine characters, starting with a |
US_SOCIAL_SECURITY_NUMBER | Matches strings consistent with a US Social Security Number. Strings must contain nine digits and comprise three parts: the three left-most digits designating the area number, the middle two digits designating the group number, and the four right-most digits designating the serial number. For a column to be tagged, none of these parts can contain all zeroes, and area numbers must not be 666 or in the range of 900-999. Tags include |
US_STATE | Matches strings consistent with either a full name or two-letter abbreviation of a US state or territory. Tags include |
US_TOLLFREE_PHONE_NUMBER | Matches strings consistent with a US toll-free telephone number. Allowed area codes are 800, 88+any digit, or 899. Tags include |
VEHICLE_IDENTIFICATION_NUMBER | Matches strings consistent with Vehicle Identification Numbers. A checksum is required as well as a valid World Manufacturer Identifier. Tags include |
Matches strings consistent with the Canadian Passport Number format as . Tags include Discovered.PII, Discovered.Identifier Direct, Discovered.Country.Canada, Discovered.PHI, Discovered.Entity.Passport.