Skip to main content

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 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

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!