Tools

IBM Knowledge Catalog (IBM watsonx.data intelligence)

ID ibmknowledgecatalog

catalogs

IBM Knowledge Catalog, now part of IBM watsonx.data intelligence, assigns data classes to table columns when it profiles data assets. More than 150 predefined data classes ship with the product; each one matches values or column names with a regular expression, a value list or a built-in Java classifier. They cover personal and financial identifiers, US state and Canadian province driver's licenses, codes such as ISO country and language codes, and generic classes such as Code, Identifier and Text. The table of classes and their matching criteria is published in the IBM documentation.

Website
https://dataplatform.cloud.ibm.com/docs/content/governance/dmg_attr_classifier.html
Supported types
79

Supported semantic types

IDNameCategoriesCountriesDescription
aba US ABA routing number draft finances global Datatype for 'US ABA routing number' (aba) from rules in context 'finances'.
abaroutingnum American Banking Association (ABA) routing number finances US In the United States, an ABA routing transit number (ABA RTN) is a nine-digit code printed on the bottom of checks to identify the...
address_line2 Address line 2 (secondary address line) PII draft geo, pii global Additional line of a postal address after the street line. It holds the part of a building or the delivery point: apartment, suite,...
admin_area_1 First-level administrative division draft geo global Name or code of the largest administrative subdivision of a country, such as a US state, a Canadian province, a German Land or a Russian...
bankcard Bank card (credit/debit card) PII pii, finances global A bank card is typically a plastic card issued by a bank to its clients that performs one or more of a number of services that relate to...
bankcard_cvv Payment card security code (CVV, CVC, CID) PII draft pii, finances global Short code printed on a payment card that card-not-present transactions use to show that the payer holds the card. Visa calls it CVV2,...
bankcard_expiry Payment card expiration date draft finances, datetime global Month and year after which a payment card is no longer valid, printed on the card next to the card number. Payment card rules treat it...
bic SWIFT/BIC code draft finances global Datatype for 'SWIFT/BIC code' (bic) from rules in context 'finances'.
birthday Birthday PII pii, datetime global A birthday is the anniversary of the birth of a person, or figuratively of an institution. Birthdays of people are celebrated in...
boolean Boolean common global In computer science, the Boolean data type is a data type that has one of two possible values (usually denoted true and false) which is...
ca_postcode Canadian postal code PII pattern draft geo, pii, common CA Canadian postal code: six characters in the form A1A 1A1, a letter, a digit and a letter, a space, then a digit, a letter and a digit....
cadriverlic Canada driver license number PII pii, persons CA Alphanumeric value of the Canada driver license
caprovince Province of Canada geo CA Provinces and territories of Canada
caprovincecode Province of Canada alpha2 code pattern geo CA Provinces and territories of Canada alpha2 code
casin Canada social insurance number (SIN) PII pii, persons CA Social insurance number (SIN) is a number issued in Canada to administer various government programs.
city City PII geo, pii, common global A city is a large human settlement. It can be defined as a permanent and densely settled place with administratively defined boundaries...
color Color draft common global Color of a subject, written as a color name or a color code.
country Country code or name geo global A country is a distinct territorial body or political entity. It may be an independent sovereign state or part of a larger state,[2] as...
countrycode_alpha2 ISO 3166-1 Alpha2 country code pattern geo global ISO 3166-1 alpha-2 codes are two-letter country codes defined in ISO 3166-1, part of the ISO 3166 standard published by the...
countrycode_alpha3 ISO 3166-1 Alpha3 country code pattern geo global ISO 3166-1 alpha-3 codes are three-letter country codes defined in ISO 3166-1, part of the ISO 3166 standard published by the...
cptcode CPT/HCPCS procedure code draft medical global Datatype for 'CPT/HCPCS procedure code' (cptcode) from rules in context 'medical'.
date Date datetime global Calendar date. The regexp covers the ISO 8601 extended form YYYY-MM-DD; other notations, such as DD.MM.YYYY, are patterns of this datatype.
de_vehicle_plate German vehicle registration plate (Kfz-Kennzeichen) draft transport DE Registration number of a vehicle in Germany as shown on the plate. It has a distinguishing sign of one to three capital letters for the...
duns Data Universal Numbering System (DUNS) companies global The Data Universal Numbering System, abbreviated as DUNS or D-U-N-S, is a proprietary system developed and managed by Dun & Bradstreet...
email Email address PII common, internet, pii global Address of an electronic mailbox in the form local-part@domain, defined in section 3.4.1 of RFC 5322. The local part names the mailbox,...
esnif Spanish Tax identification number PII pii, persons ES Spanish tax identification number used to identify tax paying individuals
frnir French social security number (NIR) PII pii, persons FR French national identification number (numéro d'inscription au répertoire, NIR), known as the social security number. INSEE assigns it...
gender Gender PII draft pii, persons global Gender flag and/or any other identification value
geopoint Geopoint draft geo global Basic geopoint as coordinates
honorificprefix Honorific prefix (title before a name) draft persons global Title written before a person's name to address or refer to the person with courtesy or respect. It groups common titles (civility),...
iataairportcode IATA Airport code pattern transport global An IATA airport code, also known as an IATA location identifier, IATA station code, or simply a location identifier, is a three-letter...
iban International Bank Account Number finances global The International Bank Account Number (IBAN) is an internationally agreed system of identifying bank accounts across national borders to...
icd10 Identifier in the ICD catalogue codes for diseases - Version 10 (ICD-10) medical global ICD-10 is the 10th revision of the International Statistical Classification of Diseases and Related Health Problems (ICD), a medical...
imei International Mobile Equipment Identity (IMEI) PII telecom, pii global Number that identifies a mobile device of 3GPP networks (GSM, UMTS, LTE, 5G) and of some satellite networks. It has 15 digits; the...
ipv4 IPv4 address PII internet, pii global 32-bit address of Internet Protocol version 4 (RFC 791), written in dotted-decimal notation as four numbers from 0 to 255, such as...
ipv6 IPv6 address PII internet, pii global 128-bit address of Internet Protocol version 6, written as eight groups of up to four hexadecimal digits separated by colons (RFC 4291,...
isbn International Standard Book Number (ISBN) publishing, objectids global ISO 2108 identifier of a book edition, in either of its two forms: the 10-character ISBN used until 2007, whose last character is a...
isbn10 International Standard Book Number 10-digits (ISBN10) objectids, publishing global 10-digit International Standard Book Number, used for books published before 2007. The last character is a check digit (0-9 or X).
isbn13 International Standard Book Number 13-digits (ISBN13) objectids, publishing global 13-digit International Standard Book Number, used since 2007. It starts with the prefix 978 or 979.
isicrev4 ISIC rev 4 class code industry global Code of industry by ISIC (International Standard Industrial Classification of All Economic Activities)
isin International Securities Identification Number finances global An International Securities Identification Number (ISIN) uniquely identifies a security. Its structure is defined in ISO 6166. The ISIN...
iso3166code identifier for a country subdivision per ISO 3166-2 geo global identifier for a country subdivision per ISO 3166-2 (include country code)
it_codicefiscale Italian tax code (codice fiscale) PII draft pii, persons IT Codice fiscale, the tax code of people in Italy, issued by the Agenzia delle Entrate: 16 characters derived from the surname, the first...
language Language draft common global Human language written as a name, such as English, Deutsch or allemand (German in French), or as a code. Codes have their own patterns:...
latitude latitude geo, common global In geography, latitude is a geographic coordinate that specifies the north–south position of a point on the Earths surface. Latitude is...
longitude Longitude geo, common global Longitude is a geographic coordinate that specifies the east–west position of a point on the Earths surface, or the surface of a...
mac_address MAC address (Media Access Control) PII internet, identifiers, pii global 48-bit hardware address (EUI-48) of a network interface in Ethernet, Wi-Fi, Bluetooth and other IEEE 802 networks, used to deliver...
marital_status Marital status PII draft persons, pii global Civil status of a person with respect to marriage: single, married, divorced, widowed, separated or in a civil partnership. Data sets...
money Money amount draft values, common global Amount of money as numeric value
month Month draft datetime global Month as number since start of the year. Could be from 1 to 12
namesuffix Name suffix draft persons global Word, abbreviation or numeral written after a person's surname. It can be generational (Jr., Sr., III), academic (PhD), an honour (OBE),...
nanpphone North American phone number (NANP) PII pattern draft pii, common, telecom US, CA Ten-digit telephone number of the North American Numbering Plan (NANP), the shared numbering plan of country code 1 used by the United...
nif NIF por nombre de campo PII finances ES ES datatype for 'NIF por nombre de campo' (nif) from rules in context 'finances'. The Spanish tax identification number (Número de...
orgname Company or organization name companies global Name of the organization/business/company in any language
percentage Percentage value draft values, common global Parcentage float number
person_firstname Person firstname PII persons, pii global First name of the person. For example, Donald or Vladimir or Jack
person_fullname Person fullname PII draft persons, pii global Full name of the person as combination of last, first, and sometimes middle name
person_midname Person middle name PII draft persons, pii global Middle name of the person
person_surname Person surname/lastname PII persons, pii global Last name of the person. For example, Smith or Ivanova
race_ethnicity Race or ethnicity PII draft persons, pii global Race or ethnic group of a person as recorded in surveys, health records and administrative data, for example Asian, Black or African...
religion Religion PII draft persons, pii global Religion, religious denomination or worldview of a person or a group, such as Catholic, Sunni Islam or Buddhism. Censuses and surveys...
street Street PII draft geo, pii, common global Name of the street, commonly used in address
street_address Street address line PII draft geo, pii global First line of a postal address: the house or building number and the street name, such as 10 Downing Street or Unter den Linden 77. The...
swiftcode Bank SWIFT code (ISO 9362) finances global ISO 9362 defines a standard format of Business Identifier Codes (also known as SWIFT-BIC, BIC, SWIFT ID or SWIFT code) approved by the...
temperature Temperature draft values, science, environment global A measured or set temperature, such as an air, water or body temperature reading. Datasets store it as a number in degrees Celsius,...
uknino UK National Insurance number PII pii, persons GB The National Insurance number is a number used in the United Kingdom in the administration of the National Insurance or social security...
ukpostalcode UK Postal code PII pattern geo GB Postal codes used in the United Kingdom, British Overseas Territories and Crown dependencies are known as postcodes (originally, postal codes).
upc Universal Product Code (UPC) by field name draft gs1 global Universal Product Code (UPC) by field name code
url Uniform Resource Locator (URL) common, internet global Address of a resource on a network that also says how to retrieve it: a scheme such as https, a host, an optional port, a path, a query...
us_hicn US Medicare Health Insurance Claim Number (HICN) PII draft pii, persons, medical US Former Medicare number of a beneficiary in the United States: the nine-digit Social Security number of the wage earner on whose record...
us_ndc US National Drug Code (NDC) draft medical US Ten-digit identifier of a drug package listed with the US Food and Drug Administration. It has three segments: the labeler code assigned...
uscounty US County draft geo US Name or code of US County
usdriverlic US driver license number PII pii, persons US Alphanumeric value of the United States driver license
usein US EIN (Employer Identification Number) PII pii, persons US An Employer Identification Number (EIN) is also known as a Federal Tax Identification Number, and is used to identify a business entity....
usitin US ITIN (Individual Taxpayer Identification Number) PII pii, persons US A Taxpayer Identification Number (TIN) is an identifying number used for tax purposes in the United States and in other countries under...
usssn US Social Security Number PII pii, persons US In the United States, a Social Security number (SSN) is a nine-digit number issued to U.S. citizens, permanent residents, and temporary...
usstate US State draft geo US Name or code of US State
uszipcode US Postal code PII pattern geo US A ZIP Code is a postal code used by the United States Postal Service (USPS). Introduced in 1963, the basic format consisted of five...
vin Vehicle Identification Number by field name draft transport global Vehicle Identification Number by field name number

Use this record