Predefined standard and semantic types - 7.0

Talend Data Stewardship User Guide

Version
7.0
Language
English (United States)
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Data Stewardship
Content
Administration and Monitoring > Managing users
Data Governance > Assigning tasks
Data Governance > Managing campaigns
Data Governance > Managing data models
Data Quality and Preparation > Handling tasks
Installation and Upgrade

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 Talend Data Stewardship.

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

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/

Civility

Civility

Talend

Color Hex Code

Color hexadecimal code

Talend

Continent

Continent name

Talend

Continent Code

Continent code

Talend

Country

Country name

http://data.okfn.org (Public Domain Dedication and License)

Country Code ISO2

2-letter country code

http://data.okfn.org (Public Domain Dedication and License)

Country Code ISO3

3-letter country code

http://data.okfn.org (Public Domain Dedication and License)

Currency Code

Currency code

http://data.okfn.org (Public Domain Dedication and License)

Currency Name

Currency name

http://data.okfn.org (Public Domain Dedication and License)

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

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

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

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

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

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/

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

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

Visa Card

Visa credit card

Talend

Web Domain

Web site domain

Talend

Weekday

Day of the week

Talend