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