Talend (Qlik Talend Data Preparation, Data Catalog and Data Inventory)
ID talend
etl
Talend, now part of Qlik, suggests a semantic type for each column of a dataset. The types live in Talend Dictionary Service and are shared by Data Preparation, Data Inventory, Data Stewardship and Pipeline Designer. A type is either a list of values (for example ISO country and currency lists or INSEE lists of French communes), a regular expression, or a compound of other types. The predefined list covers names and titles, addresses and postal codes, phone numbers, card and bank numbers, national identifiers for France, Sweden, the UK and the US, and several kinds of URLs.
- Website
- https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/predefined-semantic-types
- Supported types
- 80
Supported semantic types
| ID | Name | Categories | Countries | Description |
|---|---|---|---|---|
| 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... |
| academictitle | Academic and professional title draft | persons, education | global | Title written before a person's name that shows an academic degree, an academic rank or a professional status, such as Dr, Prof. or Eur... |
| animal | Animal draft | common | global | Common name of an animal or a kind of animal, such as dog, cat or horse. Typical columns hold pet types, livestock or animals in... |
| at_vat | Austrian VAT identification number (UID) PII draft | finances, companies | AT | Austrian VAT identification number (Umsatzsteuer-Identifikationsnummer, UID). In the EU form it is ATU followed by eight digits. 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... |
| be_postcode | Belgian postal code PII pattern | geo, pii, common | BE | Four-digit postal code used in Belgium since 1969; it never starts with 0. The first digit mostly shows the province, though some ranges... |
| beverage | Beverage draft | common | global | Name of a drink or a kind of drink, such as coffee, tea, beer or orange juice, for example in menus, product catalogs or food surveys. |
| bg_vat | Bulgarian VAT identification number PII draft | finances, companies | BG | Bulgarian VAT identification number (ДДС номер). It is BG followed by 9 digits for legal entities or 10 digits for individuals,... |
| 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... |
| 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 |
| 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... |
| civility | Civility (common title) PII draft | persons, pii | global | Everyday courtesy title written before a person's name, such as Mr, Mrs, Ms, Miss or Mx in English, M. or Mme in French and Herr or Frau... |
| colorhextriplet | Color hex triplet (web color) pattern | common | global | Web colors are colors used in displaying web pages on the World Wide Web, and the methods for describing and specifying those colors.... |
| continent | Continent name or identifier | geo | global | A continent is any of several large landmasses. Related to UN unm49 dataclass |
| 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... |
| 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 |
| de_postcode | German postal code (Postleitzahl) PII pattern | geo, pii, common | DE | Five-digit postal code (Postleitzahl, PLZ) used in Germany since 1 July 1993, in the range 01001 to 99998. The first digit is the postal... |
| 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,... | |
| endayofweek | Day of week (in English) pattern draft | datetime | global | Day of week writtern in English |
| enmonth | Month name (English) pattern draft | datetime | global | English name of the month |
| enmonthshort | Short name of month (English) pattern draft | datetime | global | Abbreviated short English name/abbreviation of month |
| formaltitle | Formal title draft | persons | global | Title of rank, honour or office written before a person's name, such as Sir, Dame, Lord, Lady, The Honourable or His Excellency. It is... |
| 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... |
| fr_commune | French municipality (commune) draft | geo, government | FR | Name of a commune, the smallest administrative unit of France, for example Paris or Mende. Many names occur in more than one department,... |
| fr_department | French department (département) draft | geo, government | FR | Name of a department of France, the administrative level between the region and the commune, for example Ain or Corse-du-Sud. France has... |
| fr_region | French region (région) draft | geo, government | FR | Name of an administrative region of France, the level above the department, for example Île-de-France or Bretagne. France has 18... |
| 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... |
| frpostcode | French postal code PII pattern draft | geo | FR | French postal code |
| frvat | French VAT number (numéro de TVA intracommunautaire) PII | finances | FR | Numéro de TVA intracommunautaire, the VAT identification number of businesses in France: FR, a 2-character key and the 9-digit SIREN... |
| gender | Gender PII draft | pii, persons | global | Gender flag and/or any other identification value |
| geopoint | Geopoint draft | geo | global | Basic geopoint as coordinates |
| hexcolor | sRGB color hex triplet (hex color) pattern | common | global | Color written as a hexadecimal sRGB triplet, for example #1F5FBF. |
| 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... |
| industry | Industry (line of business) draft | companies, industry | global | Name of the industry or line of business of an organization, such as Banking, Retail or Telecommunications. Codes of industry... |
| inseecode | INSEE code | geo | FR | The INSEE code is a numerical indexing code used by the French National Institute for Statistics and Economic Studies (INSEE) to... |
| 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. |
| iso3166_mx3a | ISO 3166-2:MX (3-letters code) | geo | MX | ISO 3166-2:MX 3-letters alphanumeric codes used to identify Mexican states. |
| iso4217curcode | ISO 4217 Currency code pattern draft | finances | global | ISO 4217 Currency code |
| iso4217curname | ISO 4217 Currency name pattern draft | finances | global | ISO 4217 Currency name |
| iso639_1 | ISO 639-1 language code (two letters) pattern draft | common | global | Two-letter code of a language from ISO 639-1, such as en (English), de (German) or ja (Japanese). About 180 languages have such a code.... |
| iso639_2 | ISO 639-2 language code (three letters) pattern draft | common | global | Three-letter code of a language from ISO 639-2, such as eng (English) or rus (Russian). About twenty languages have two codes: a... |
| 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:... |
| 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... |
| militarysuffix | Military name suffix draft | persons | global | Abbreviation of a military service written after a person's name, for example USN or USMC. In the United States military it helps to... |
| 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 |
| mxstate | Mexican state (province) | geo | MX | Mexican state/province by name or code |
| 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... |
| orgname | Company or organization name | companies | global | Name of the organization/business/company in any language |
| orgunit | Organizational unit (department) draft | companies | global | Name of a structural unit inside an organization, such as a department, division or office. It names a part of an organization, not the... |
| 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_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 |
| 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. |
| sepersonnummer | Sweden personal identity number (personnummer) PII | pii, persons | SE | The personal identity number (Swedish: personnummer) is the Swedish national identification number. It is a ten digit number that is... |
| 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... |
| street_suffix | Street suffix (street type) draft | geo | global | Word or abbreviation after a street name that tells the type of the street, such as Street (St), Avenue (Ave), Road (Rd) or Boulevard... |
| time | Time draft | datetime | global | Time of the day, like 12:00 or 10PM or 11:05 or 18:01:27 |
| 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). |
| 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... |
| uscounty | US County draft | geo | US | Name or code of US County |
| 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... |
Use this record
- JSON: API v1 · legacy shape
- Improve it: edit
data/tools/etl/talend.yamlon GitHub