Tools

Collibra Data Classification

ID collibra

catalogs

Collibra suggests data classes for catalog columns with classification rules: regular expressions on column names or values, lists of values and data type checks, applied to a sample of the column with a minimum confidence threshold. Collibra publishes a set of out-of-the-box data classes that stewards can import into their environment as a starting point and then edit. The set covers US identifiers such as SSN, EIN, ITIN and DEA numbers, card and bank numbers, securities codes, several date and time formats, Italian identifiers, and common personal attributes. The documentation lists each class with a description and an example value.

Website
https://productresources.collibra.com/docs/collibra/latest/Content/Catalog/DataClassification/UnifiedDataClassification/co_ootb-data-classes.htm
Supported types
78

Supported semantic types

IDNameCategoriesCountriesDescription
aadhaar Indian Aadhaar number by known name PII pii, persons IN Indian Aadhaar number by known name identifier
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...
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,...
bic SWIFT/BIC code draft finances global Datatype for 'SWIFT/BIC code' (bic) from rules in context 'finances'.
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....
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...
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...
cusip CUSIP (Committee on Uniform Securities Identification Procedures) finances, identifiers US, CA A CUSIP is a nine-digit numeric (e.g. 037833100 for Apple) or nine-character alphanumeric (e.g. 38259P508 for Google) code that...
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.
datetime Date and time datetime global Date and time of day. The regexp covers the ISO 8601 extended form YYYY-MM-DDThh:mm[:ss[.fff]] with an optional time zone (Z or an...
dayofweek Day of week draft datetime global Week day name
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,...
fqdn Fully qualified domain name (FQDN) internet global Complete domain name of a host or zone, written as labels separated by dots from the host up to the top-level domain, such as...
gender Gender PII draft pii, persons global Gender flag and/or any other identification value
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),...
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...
icd9 ICD-9 code draft medical global Code of the Ninth Revision of the International Classification of Diseases (ICD-9) of the World Health Organization, which ICD-10 later...
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...
ipaddr IP address (IPv4 or IPv6) PII internet, pii global Address of a network interface in the Internet Protocol: a 32-bit IPv4 address in dotted-decimal form (192.0.2.1) or a 128-bit IPv6...
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.
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...
iso4217curcode ISO 4217 Currency code pattern draft finances global ISO 4217 Currency 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...
it_id_card Italian identity card number PII draft pii, persons IT Number of an Italian identity card (carta d'identità). The electronic card (CIE) issued since 2016 has nine characters: two letters,...
it_iva Italian VAT number (partita IVA) draft finances IT Partita IVA, the 11-digit VAT number in Italy: seven digits that identify the taxpayer, a 3-digit tax office code (mostly the province...
it_postcode Italian postal code (CAP) PII pattern draft geo, pii, common IT Italian postal code (CAP, codice di avviamento postale): five digits. San Marino and Vatican City also use codes from this system.
jobtitle Work position / Job title persons, companies global Work positions / job title
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...
miccode Market Identifier Code (ISO 10383) finances global This International Standard specifies a universal method of identifying exchanges, trading platforms, regulated or non-regulated markets...
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),...
nhsnumber NHS number PII draft pii global Datatype for 'NHS number' (nhsnumber) from rules in context 'pii'.
npi US NPI identifier PII draft medical global Datatype for 'US NPI identifier' (npi) from rules in context 'medical'.
pan Indian PAN (Permanent Account Number) by known name PII pii, persons IN Indian PAN (Permanent Account Number) by known name identifier
passport Person passport number (universal) PII draft pii, persons global Person passport, usually unique personal information that should be shared online. Identifies personal document issued to person by...
password Password PII draft common, pii global Passwords, usually associated with login/username/email.
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_surname Person surname/lastname PII persons, pii global Last name of the person. For example, Smith or Ivanova
phone Phone number PII pii, common, telecom global Telephone number in standard format (RFC3966), without 'tel:' prefix
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...
ric Reuters Instrument Code (RIC) finances global A Reuters instrument code, or RIC, is a ticker-like code used by Refinitiv to identify financial instruments and indices. The codes are...
sedol SEDOL identifier finances GB, IE SEDOL stands for Stock Exchange Daily Official List, a list of security identifiers used in the United Kingdom and Ireland for clearing purposes.
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,...
tickersymbol Stock ticker symbol finances global Ticker symbol or stock symbol is an abbreviation used to uniquely identify publicly traded shares of a particular stock on a particular...
time Time draft datetime global Time of the day, like 12:00 or 10PM or 11:05 or 18:01:27
ukdriverlic UK driver license number PII pii, persons GB In the United Kingdom, a driving licence is the official document which authorises its holder to operate motor vehicles on highways and...
uknhsnum UK NHS Number PII pii, persons, medical GB NHS numbers are the unique numbers allocated to registered users of the three public health services in England, Wales and the Isle of...
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).
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_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...
usatin US ATIN (Adoption Taxpayer Identification Number) PII pii, persons US An ATIN is an Adoption Taxpayer Identification Number issued by the Internal Revenue Service as a temporary taxpayer identification...
usdeanumber USA DEA Registration (cerficicate) Number PII pii, persons, medical US A DEA number (DEA Registration Number) is an identifier assigned to a health care provider (such as a physician, physician assistant,...
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...
usnpi US National Provider Identifier (NPI) PII pii, persons US A National Provider Identifier (NPI) is a unique 10-digit identification number issued to health care providers in the United States by...
usptin US PTIN (Preparer Tax Identification Number) PII pii, persons US The Preparer Tax Identification Number (PTIN) is an identification number that all paid tax return preparers must use on U.S. federal...
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...
utctimezoneoffset UTC Timezone offset pattern datetime global Difference between Coordinated Universal Time (UTC) and this timezone.
uuid Universally unique identifier (UUID) identifiers global 128-bit identifier that systems generate without a central registry, defined by RFC 9562 (2024), which replaced RFC 4122. Microsoft...
vehiclenumber Vehicle number draft transport global Number of the vehicle (vehicle plate number)
vin Vehicle Identification Number by field name draft transport global Vehicle Identification Number by field name number

Use this record