Predefined standard and semantic types
The data models in Talend Data Stewardship define the structure of the data you load to the campaigns and decide the type of the data based on some supported standard and semantic types.
The tables below list all the standard and semantic types supported and integrated by default in the application.
|
Standard type |
Description |
|---|---|
|
Text |
String text |
|
Integer |
Numeric value |
|
Decimal |
Decimal numeric value |
|
Date |
Date including day, month and year |
|
Time |
Time of the day |
|
Timestamps |
Date and time |
|
Boolean |
Answers with the value True or False |
|
Semantic type |
Description |
Origin of data |
|---|---|---|
| Academic and professional suffix | Academic and professional suffix | Talend |
| Academic and professional title | Academic and professional title | Talend |
| Airport Code | Airport code | Talend |
| Amex Card | American Express card | Talend |
| AT VAT Number | Austrian VAT number | Talend |
| Bank Routing Transit Number | Bank routing transit number | Talend |
| BE Postal Code | Belgian postal code | Talend |
| BG VAT Number | Bulgarian VAT number | Talend |
| CA Province Territory | Canadian province | http://www.statoids.com/ |
| CA Province Territory Code | Canadian province code | http://www.statoids.com/ |
| Christian religious title | Christian religious title | Talend |
| Civility | Civility | Talend |
| Color Hex Code | Color hexadecimal code | Talend |
| Continent | Continent name | Talend |
| Continent Code | Continent code | Talend |
| Country | Country name | https://www.iso.org/obp/ui/#search |
| Country Code ISO2 | 2-letter country code | https://www.iso.org/obp/ui/#search |
| Country Code ISO3 | 3-letter country code | https://www.iso.org/obp/ui/#search |
| Currency Code | Currency code | https://www.iso.org/iso-4217-currency-codes.html |
| Currency Name | Currency name | https://www.iso.org/iso-4217-currency-codes.html |
| Data URL | URL starting with the word data | Talend |
| DE Postal Code | German postal code | Talend |
| DE Phone | German phone number | Talend |
| Email address | Talend | |
| EN Month | Month in English | Talend |
| EN Month Abbrev | English month abbreviation | Talend |
| EN Weekday | Week day or their abbreviation | Talend |
| File URL | File URL | Talend |
| Formal title | Formal title | Talend |
| FR Commune | French municipality | Insee |
| FR Departement | French department | Insee |
| FR Insee Code | French Insee code of cities with Corsica and colonies | Insee |
| FR Phone | French phone number | Talend |
| FR Postal Code | French postal code | Talend |
| FR VAT Number | French VAT number | Talend |
| FR Region | French region | Insee |
| FR Region Legacy | Former French regions, prior to the 2016 territorial reform. | Insee |
| FR Social Security Number | French social security number | Talend |
| Generic URL | Generic URL (Web, HDFS, MailTo, data, file) | Talend |
| Gender | Gender | Talend |
| Geographic Coordinate | Geographic coordinate, longitude or latitude coordinates with at least meter precision | Talend |
| Geographic Coordinates | Geographic coordinates, Google Maps style GPS Decimal format | Talend |
| Geographic Coordinates (degree) | Geographic coordinates (degrees), Latitude and longitude coordinates separated by a comma in the form: N 0:59:59.99,E 0:59:59.99 | Talend |
| HDFS URL | HDFS URL | Talend |
| IBAN | International Bank Account Number | Talend |
| Inherited suffix | Inherited suffix | Talend |
| Islamic religious title | Islamic religious title | Talend |
| IPv4 Address | IPv4 address | Talend |
| IPv6 Address | IPv6 address | Talend |
| ISBN-10 | International standard book number 10 digits | Talend |
| ISBN-13 | International standard book number 13 digits | Talend |
| Job Title | Job title | Talend |
| Judaic religious title | Judaic religious title | Talend |
| Language | Language | Wikipedia |
| Language Code ISO2 | 2-letter language code | Wikipedia |
| Language Code ISO3 | 3-letter language code | Wikipedia |
| MailTo URL | MailTo URL | Talend |
| MAC Address | MAC address | Talend |
| MasterCard | Mastercard credit card | Talend |
| Military suffix | Military suffix | Talend |
| Money Amount (EN) | Amount of money in English format | Talend |
| Money Amount (FR) | Amount of money in French format | Talend |
| Month | Month | Talend |
| MX Estado | Mexican state | http://www.statoids.com/ |
| MX Estado Code | Mexican state code | http://www.statoids.com/ |
| Name Suffix | Name suffix (Inherited, academic, professional or military) | Talend |
| North American state | US state and Canadian province | Talend |
| North American state code | US state code and Canadian province code | Talend |
| Passport | Passport number | Talend |
| Phone number | Phone number (DE, FR, UK, US) | Talend |
| Religious title | Religious title (Christian, Islamic, Judaic) | Talend |
| SE Social Security Number | Swedish person number | Talend |
| SEDOL | Stock exchange daily official list | Talend |
| Street Type | Street type | Talend |
| UK Phone | UK phone number | Talend |
| UK Postal Code | UK postal code | Talend |
| UK Social Security Number | National identification number, national identity number, or national insurance number generally called NI number | Talend |
| URL | Web site URL | Talend |
| US County | US county name | Wikipedia |
| US Phone | US phone number | Talend |
| US Postal Code | US postal code | Talend |
| US Social Security Number | US social security number | Talend |
| US State | US states | Talend |
| US State Code | US state code | Talend |
| Title | Title (Civility, academic, professional, formal, religious) | Talend |
| Visa Card | Visa credit card | Talend |
| Web Domain | Web site domain | Talend |
| Weekday | Day of the week | Talend |