SAS Information Catalog (Quality Knowledge Base)
ID sasinformationcatalog
catalogs
SAS Information Catalog, part of SAS Viya, assigns semantic types to columns of the tables and files it discovers, using the SAS Quality Knowledge Base (QKB). The QKB Field Content identification analysis looks at the values of a column and returns an identity: global identities such as email, URL, IBAN, payment card number, network address and geographical point, language identities for person names and organizations, and locale identities such as phone, postal code, address, city and the government identifiers of each locale. Column name analysis is a lighter alternative. The supported types list the identities that the QKB documentation describes for all locales, plus the government identifiers, bank account, organization and vehicle registration identities that the Field Content pages of QKB 33 list for the Danish, German, Canadian English, British, US, Belgian Dutch, Norwegian and Swedish locales.
- Website
- https://support.sas.com/documentation/onlinedoc/qkb/32/QKBCI32/Help/Content/qkb-generaldoc/qkb-iddef.html
- Supported types
- 48
Supported semantic types
| ID | Name | Categories | Countries | Description |
|---|---|---|---|---|
| address | Address (physical location) PII | common, pii, geo | global | Geographic address, commonly consist of postindex, country, area, town, street and building |
| bankcard | Bank card (credit/debit card) PII | pii, finances | global | A bank card is typically a plastic card issued by a bank to its clients that performs one or more of a number of services that relate to... |
| be_eid | Belgian eID card number PII draft | pii, persons | BE | Number of a Belgian electronic identity card (eID), issued to Belgian citizens aged 12 and over. It identifies the card, not the person,... |
| be_vehicle_plate | Belgian vehicle registration plate (nummerplaat) draft | transport | BE | Registration number of a vehicle in Belgium as shown on the European-format plate issued since 15 November 2010: an index character,... |
| benatcardid | Belgian national register number (Rijksregisternummer) PII | pii, persons | BE | Rijksregisternummer (numéro de registre national, Nationalregisternummer), the 11-digit number of a person in the Belgian National... |
| cadriverlic | Canada driver license number PII | pii, persons | CA | Alphanumeric value of the Canada driver license |
| capassport | Canadian passport number PII pattern | pii, persons | CA | Number of Canadian passport |
| casin | Canada social insurance number (SIN) PII | pii, persons | CA | Social insurance number (SIN) is a number issued in Canada to administer various government programs. |
| city | City PII | geo, pii, common | global | A city is a large human settlement. It can be defined as a permanent and densely settled place with administratively defined boundaries... |
| country | Country code or name | geo | global | A country is a distinct territorial body or political entity. It may be an independent sovereign state or part of a larger state,[2] as... |
| countrycode_alpha3 | ISO 3166-1 Alpha3 country code pattern | geo | global | ISO 3166-1 alpha-3 codes are three-letter country codes defined in ISO 3166-1, part of the ISO 3166 standard published by the... |
| currency | Currency | finances | global | A currency in the most specific sense is money in any form when in use or circulation as a medium of exchange, especially circulating... |
| date | Date | datetime | global | Calendar date. The regexp covers the ISO 8601 extended form YYYY-MM-DD; other notations, such as DD.MM.YYYY, are patterns of this datatype. |
| datetime | Date and time | datetime | global | Date and time of day. The regexp covers the ISO 8601 extended form YYYY-MM-DDThh:mm[:ss[.fff]] with an optional time zone (Z or an... |
| depersonalausweis | German identity card number (Personalausweis) PII | pii, persons | DE | Serial number (Ausweisnummer) of a German identity card (Personalausweis). Cards issued since 1 November 2010 have nine characters: a... |
| dk_vehicle_plate | Danish vehicle registration plate draft | transport | DK | Registration number on standard Danish vehicle plates: two letters and five digits, written AB 12 345. Since 2012 letters and digits are... |
| dkcprnum | CPR-Number, Personal identification number (Denmark) PII | pii, persons | DK | The Danish Personal Identification number is a national identification number, which is part of the personal information stored in the... |
| Email address PII | common, internet, pii | global | Address of an electronic mailbox in the form local-part@domain, defined in section 3.4.1 of RFC 5322. The local part names the mailbox,... | |
| gb_county | United Kingdom county draft | geo, government | GB | Name of a county or a similar area of the United Kingdom, such as Kent, Greater Manchester, Aberdeenshire or Antrim. Lists mix... |
| gb_vehicle_plate | UK vehicle registration plate by field name draft | transport | GB | UK vehicle registration plate by field name |
| geopoint | Geopoint draft | geo | global | Basic geopoint as coordinates |
| iban | International Bank Account Number | finances | global | The International Bank Account Number (IBAN) is an internationally agreed system of identifying bank accounts across national borders to... |
| ipaddr | IP address (IPv4 or IPv6) PII | internet, pii | global | Address of a network interface in the Internet Protocol: a 32-bit IPv4 address in dotted-decimal form (192.0.2.1) or a 128-bit IPv6... |
| ipv4 | IPv4 address PII | internet, pii | global | 32-bit address of Internet Protocol version 4 (RFC 791), written in dotted-decimal notation as four numbers from 0 to 255, such as... |
| ipv6 | IPv6 address PII | internet, pii | global | 128-bit address of Internet Protocol version 6, written as eight groups of up to four hexadecimal digits separated by colons (RFC 4291,... |
| latitude | latitude | geo, common | global | In geography, latitude is a geographic coordinate that specifies the north–south position of a point on the Earths surface. Latitude is... |
| longitude | Longitude | geo, common | global | Longitude is a geographic coordinate that specifies the east–west position of a point on the Earths surface, or the surface of a... |
| mac_address | MAC address (Media Access Control) PII | internet, identifiers, pii | global | 48-bit hardware address (EUI-48) of a network interface in Ethernet, Wi-Fi, Bluetooth and other IEEE 802 networks, used to deliver... |
| month | Month draft | datetime | global | Month as number since start of the year. Could be from 1 to 12 |
| no_fodselsnummer | Norwegian national identity number (fødselsnummer) PII draft | pii, persons | NO | Fødselsnummer, the 11-digit national identity number in Norway, kept in the National Population Register by the Norwegian Tax... |
| no_kontonr | Norwegian bank account number (kontonummer) draft | finances | NO | Kontonummer, the 11-digit bank account number in Norway: a 4-digit bank code, six digits for the account and a modulo 11 check digit. It... |
| no_orgnr | Norwegian organisation number (organisasjonsnummer) draft | companies | NO | Organisasjonsnummer, the 9-digit number of a legal entity in the Norwegian Central Coordinating Register for Legal Entities... |
| no_vehicle_plate | Norwegian vehicle registration plate draft | transport | NO | Registration number on Norwegian vehicle plates since 1971: two letters followed by five digits for most cars, or four digits for... |
| orgname | Company or organization name | companies | global | Name of the organization/business/company in any language |
| person_firstname | Person firstname PII | persons, pii | global | First name of the person. For example, Donald or Vladimir or Jack |
| person_fullname | Person fullname PII draft | persons, pii | global | Full name of the person as combination of last, first, and sometimes middle name |
| person_surname | Person surname/lastname PII | persons, pii | global | Last name of the person. For example, Smith or Ivanova |
| phone | Phone number PII | pii, common, telecom | global | Telephone number in standard format (RFC3966), without 'tel:' prefix |
| postindex | Postal code/index PII | geo, pii, common | global | Postal index/code, unique post identifier used in address |
| province | Province (name) draft | geo | global | Name of a province or a similar first-level administrative division of a country. |
| se_vehicle_plate | Swedish vehicle registration plate draft | transport | SE | Registration number on Swedish vehicle plates: three letters, a space, two digits and a digit or, since 2019, a letter. The letters I,... |
| sepersonnummer | Sweden personal identity number (personnummer) PII | pii, persons | SE | The personal identity number (Swedish: personnummer) is the Swedish national identification number. It has ten digits, the date of birth... |
| state | State (name or code) draft | geo | global | Name or code of a state or a similar first-level administrative division of a country. |
| street_address | Street address line PII draft | geo, pii | global | First line of a postal address: the house or building number and the street name, such as 10 Downing Street or Unter den Linden 77. The... |
| ukdriverlic | UK driver license number PII | pii, persons | GB | In the United Kingdom, a driving licence is the official document which authorises its holder to operate motor vehicles on highways and... |
| uknino | UK National Insurance number PII | pii, persons | GB | The National Insurance number is a number used in the United Kingdom in the administration of the National Insurance or social security... |
| url | Uniform Resource Locator (URL) | common, internet | global | Address of a resource on a network that also says how to retrieve it: a scheme such as https, a host, an optional port, a path, a query... |
| usssn | US Social Security Number PII | pii, persons | US | In the United States, a Social Security number (SSN) is a nine-digit number issued to U.S. citizens, permanent residents, and temporary... |
Use this record
- JSON: API v1 · legacy shape
- Improve it: edit
data/tools/catalogs/sasinformationcatalog.yamlon GitHub