Semantic types - Data360_Govern - Latest

Data360 Govern Help

Product type
Software
Portfolio
Verify
Product family
Data360
Product
Data360 Govern
Version
Latest
ft:locale
en-US
Product name
Data360 Govern
ft:title
Data360 Govern Help
Copyright
2024
First publish date
2014
ft:lastEdition
2025-02-25
ft:lastPublication
2025-02-25T14:26:12.233000

Semantic types help to describe the type of information that data represents. For example, a POSTAL_CODE.ZIP5_US semantic type represents a postal code in the USA, while CHECKDIGIT.IBAN is an international bank account number.

The following table shows examples of semantic type definitions that are built-in to Data360 Govern. Detection of some semantic types is dependent on the current locale, as indicated in the table.

Semantic Type Description
AIRPORT_CODE.IATA IATA Airport Code.
CHECKDIGIT.CUSIP North American Security Identifier.
CHECKDIGIT.EAN13 EAN-13 Check digit (also UPC and ISBN-13).
CHECKDIGIT.IBAN International Bank Account Number.
CHECKDIGIT.ISIN International Securities Identification Number.
CHECKDIGIT.LUHN Digit String that has a valid Luhn Check digit (and length between 8 and 30 inclusive).
CHECKDIGIT.SEDOL UK/Ireland Security Identifier.
CITY City/Town.
CONTINENT.CODE_EN Continent Code.
CONTINENT.TEXT_EN Continent Name.
COORDINATE.LATITUDE_DECIMAL Latitude (Decimal degrees).
COORDINATE.LONGITUDE_DECIMAL Longitude (Decimal degrees).
COORDINATE_PAIR.DECIMAL Coordinate Pair (Decimal degrees).
COUNTRY.ISO-3166-2 Country as defined by ISO 3166 - Alpha 2.
COUNTRY.ISO-3166-3 Country as defined by ISO 3166 - Alpha 3.
COUNTRY.TEXT_EN Country as a string (English language).
CREDIT_CARD_TYPE Type of Credit card, for example, AMEX, VISA and so on.
CURRENCY_CODE.ISO-4217 Currency as defined by ISO 4217.
DAY.DIGITS Day represented as a number (1-31).
EMAIL Email Address.
GENDER.TEXT_EN Gender (English Language).
GUID Globally Unique Identifier, for example, 30DD879E-FE2F-11DB-8314-9800310C9A67.
HONORIFIC_EN Title (English language).
STREET_MARKER_EN Street Suffix (English Language).
IPADDRESS.IPV4 IP V4 Address.
IPADDRESS.IPV6 IP V6 Address.
LANGUAGE.ISO-639-2 Language code - ISO 639, two character.
LANGUAGE.TEXT_EN Language name, for example, English, French and so on.
MACADDRESS MAC Address.
MONTH.ABBR_ Month Abbreviation = Locale, for example, en-US for English language in US.
MONTH.DIGITS Month represented as a number (1-12).
MONTH.FULL_ Full Month name = Locale, for example, en-US for English language in US.
NAME.FIRST First Name.
NAME.FIRST_LAST Merged Name (First Last).
NAME.LAST Last Name.
NAME.LAST_FIRST Merged Name (Last, First).
POSTAL_CODE.POSTAL_CODE_AU Postal Code (en-AU) POSTAL_CODE.POSTAL_CODE_CA Postal Code (en-CA).
POSTAL_CODE.ZIP5_US Postal Code (en-US).
POSTAL_CODE.POSTAL_CODE_UK Postal Code (en-UK).
SSN Social Security Number (en-US).
STATE_PROVINCE.STATE_AU Australian State Code (en-AU).
STATE_PROVINCE.PROVINCE_CA Canadian Province Code (en-CA/en-US).
STATE_PROVINCE.STATE_MX Mexican State Code (es-MX).
STATE_PROVINCE.STATE_PROVINCE_NA US State Code/Canadian Province Code/Mexican State Code (en-CA/en-US/es-MX).
STATE_PROVINCE.STATE_US US State Code (en-CA/en-US).
STATE_PROVINCE.STATE_NAME_AU Australian State Name (en-AU).
STATE_PROVINCE.PROVINCE_NAME_CA Canadian Province Name (en-CA/en-US).
STATE_PROVINCE.STATE_NAME_MX Mexican State Name (es-MX).
STATE_PROVINCE.STATE_PROVINCE_NAME_NA US State Name/Canadian Province Name (en-CA/en-US/es-MX).
STATE_PROVINCE.STATE_NAME_US US State Name (en-CA/en-US).
STREET_ADDRESS_EN Street Address (English Language).
TELEPHONE Telephone Number (Generic).
URI.URL URL - see RFC 3986.
VIN Vehicle Identification Number.