Semantic types - Data360_Govern - Preview

Data360 Govern Help

Product type
Software
Portfolio
Verify
Product family
Data360
Product
Precisely Data Integrity Suite > Govern
Data360 Govern
Version
Preview
Language
English
Product name
Data360 Govern
Title
Data360 Govern Help
Copyright
2024
First publish date
2014

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.