Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Informatica Data Quality 10.4.0
  • All Products

Table of Contents

Search

  1. Preface
  2. Introduction to Accelerators
  3. Core Accelerator
  4. Data Domains Accelerator
  5. Australia/New Zealand Accelerator
  6. BCBS 239/CCAR Accelerator
  7. Brazil Accelerator
  8. Financial Services Accelerator
  9. France Accelerator
  10. Germany Accelerator
  11. India Accelerator
  12. Italy Accelerator
  13. Portugal Accelerator
  14. Spain Accelerator
  15. United Kingdom Accelerator
  16. U.S./Canada Accelerator

Accelerator Guide

Accelerator Guide

Back Next

Data Domains in the Data Domains Accelerator

Data Domains in the Data Domains Accelerator

Use the predefined data domains in profiles to perform data domain discovery and identify critical data characteristics within an enterprise.
In the table, the asterisk (*) symbol is a wildcard character.
The following table describes the data domains available in the Data Domains accelerator:
Name
Description
Dependent Rule Type
Data Domain Group
Account_Status
Discovers columns that contain data that matches the account status values in a reference table.
Data rule
Account_Bank
AccountNumber
Discovers column names that contain the "a*c*num" or "acc" string.
Metadata rule
Account_Bank, PCI, PHI
Address
Discovers columns that contain address data values, such as cities, counties, countries, country codes, address prefixes, or address suffixes. Supports addresses from Canada, France, Germany, Great Britain, New Zealand, Portugal, and the United States.
Discovers column names that can indicate or match terms for address data.
Data rule
Metadata rule
General, PHI, PII
Admission_date
Discovers date values in the column data and standardizes the date values to a single format.
Discovers column names that can indicate or match terms for admission date.
See also Discharge_date.
Data rule
Metadata rule
PHI
Age
Discovers column data with values from 1 through 120.
Discovers column names that contain the "age" string or "dob" string.
Data rule
Metadata rule
PHI, PII
AlphaNumeric_SpecialCharacter
Discovers column data that contains unformatted alphanumeric data and special-character data.
Data rule
General
Austria_NationalID
Discovers column data that matches the format of national identity numbers in Austria.
Discovers column names that can indicate or match terms for national identification data.
Data rule
Metadata rule
NationalID
Bank_Routing_Number_ABA_Number
Discovers numbers in column data that match the format of the American Banking Association routing number.
Discovers column names that match the indicators that the metadata rule defines for American Banking Association routing numbers.
Data rule
Metadata rule
General
BIC_SwiftCode
Discovers column data that matches Bank Identifier Code (BIC) or Society for Worldwide Interbank Financial Telecommunication (SWIFT) code data. The data rule uses pattern recognition and country code validation to find the data values.
Discovers column names that match the indicators that the metadata rule defines for BIC data or SWIFT code data.
Data rule
Metadata rule
Account_Bank
BinaryValue
Discovers column data that contains binary values.
Data rule
General
BirthDay
Discovers column data that matches valid birth dates. A birth date is valid for an age up to 120 years.
Discovers column names that contain the "dob" string, "date*of*bir*" string, or "birth*da*" string.
Data rule
Metadata rule
PHI, PII
BirthPlace
Discovers column data that matches country names in the reference data.
Discovers column names that contain the "birth*place" string or "location*birth" string.
Data rule
Metadata rule
PHI, PII
Brazil_IDDoc
Discovers column data that matches the format of the national identity number in Brazil.
Data rule
NationalID
Brazil_NationalID_CPF
Discovers column data that matches the format of the individual taxpayer registry identification number in Brazil.
Discovers column names that can indicate or match terms for national identification data.
Data rule
Metadata rule
NationalID
Brazil_NationalID_RG
Discovers column data that matches the format of national identity numbers (
Registro Geral
or
Carteira de Identidade
) in Brazil.
Discovers column names that can indicate or match terms for national identification data.
Data rule
Metadata rule
The rule does not belong to a data domain group.
Bulgaria_NationalID
Discovers column data that matches the format of national identity numbers in Bulgaria.
Discovers column names that can indicate or match terms for national identification data.
Data rule
Metadata rule
NationalID
Canada_Driver_License_Narrow
Discovers column data that matches the format of driver license numbers in Canada, with the following exceptions:
  • License numbers from British Columbia, Quebec, Manitoba, and Prince Edward Island.
  • License numbers with four, five, six, seven, or eight digits.
Discovers column names that can indicate or match terms for driver license data.
Data rule
Metadata rule
The rule does not belong to a data domain group.
Canada_SIN
Discovers column data that matches the Social Insurance number format in Canada.
Discovers column names that can indicate or match terms for Social Insurance number data.
Data rule
Metadata rule
NationalID
CertificateLicenseNumber
Discovers column names that contain the "cert*lic*number" string, "cert*lic*no*" string, "lic* nu*" string, or "lic*no*" string.
Metadata rule
PHI
China_NationalID
Discovers column data that matches the format of national identity numbers in China.
Discovers column names that can indicate or match terms for national identity numbers.
Data rule
Metadata rule
NationalID
City
Discovers column data that matches city names around the world.
Discovers column names that can indicate or match terms for city names.
Data rule
Metadata rule
PHI
CompanyName
Discovers column data that matches the organization name values in a reference table.
Discovers column names that contain the "company" string.
Data rule
Metadata rule
Contact, PII
ComputerAddress
Discovers column data that matches the format of IP addresses or MAC addresses.
Discovers column names that can indicate or match terms for IP addresses or MAC addresses.
Data rule
Metadata rule
General
Country
Discovers column data that matches country names in the reference data.
Discovers column names that contain the "iso*countr*code" string, "iso*country" string, or "countr*" string.
Data rule
Metadata rule
Address, PHI, PII
CountryCode_Phone
Discovers telephone numbers in column data based on international dialing codes.
Discovers column names that can indicate or match terms for telephone numbers.
Data rule
Metadata rule
Contact
CreditCard_AMEX
Discovers column data that matches the American Express credit card number format.
Data rule
Account_Bank
CreditCard_DinersCard
Discovers column data that matches the Diners Club International credit card number format.
Data rule
Account_Bank
CreditCard_DiscoverCard
Discovers column data that matches the Discover credit card number format.
Data rule
Account_Bank
CreditCard_JCB
Discovers column data that matches the JCB International credit card number format.
Data rule
Account_Bank
CreditCard_MasterCard
Discovers column data that matches the MasterCard credit card number format.
Data rule
Account_Bank
CreditCard_Visa
Discovers column data that matches the Visa credit card number format.
Data rule
Account_Bank
CreditCardNumber
Discovers column data that matches the format of credit card numbers from major credit card organizations.
Discovers column names that contain the "ccn" string, "cr*ca*nu" string, or "credit*no*" string.
Data rule
Metadata rule
Account_Bank, PCI, PII
Croatia_NationalID
Discovers column data that matches the format of national identity numbers in Croatia.
Discovers column names that can indicate or match terms for national identity numbers.
Data rule
Metadata rule
NationalID
Currency
Discovers column data that contains a currency indicator.
Discovers column names that can indicate or match terms for currency data.
Data rule
Metadata rule
Not applicable
Date_AllFormats
Discovers date values in the column data.
Data rule
General
Date_MM_DD_YYYY
Discovers date values in the column data that appear in a single format. The default format is MM/DD/YYYY.
Data rule
General
Denmark_NationalID
Discovers column data that matches the format of national identity numbers in Denmark.
Discovers column names that can indicate or match terms for national identity numbers.
Data rule
Metadata rule
NationalID
DeviceSerialNumber
Discovers column names that contain the "device*number" string, "device*no*" string, "serial*number" string, "serial*no*" string, or "device*identi*" string.
Metadata rule
PHI
Discharge_date
Discovers date values in the column data and standardizes the date values to a single format.
Discovers column names that can indicate or match terms for discharge dates.
See also Admission_date.
Data rule
Metadata rule
PHI
DriverLicense_Canada
Discovers column data that matches the format of driver license numbers in Canada, with the exception of licenses from British Columbia, Quebec, Manitoba, and Prince Edward Island.
Discovers column names that can indicate or match terms for driver license data.
Data rule
Metadata rule
NationalID
DriverLicense_US_Canada_GBR
Discovers column data that matches the format of driver license numbers from the United Kingdom and from many states and provinces in Canada and the United States.
The data domain does not discover the following licenses:
  • License numbers from British Columbia, Quebec, Manitoba, and Prince Edward Island.
  • License numbers with four, five, six, seven, or eight digits.
Discovers column names that can indicate or match terms for driver license data.
Data rule
Metadata rule
Not applicable
DriversLicense_GBR
Discovers column data that matches the format of United Kingdom driver license numbers.
Discovers column names that can indicate or match terms for driver license data.
Data rule
Metadata rule
NationalID
DriversLicense_USA
Discovers column data that matches the driver license number format in most of the states in the United States.
Discovers column names that can indicate or match terms for driver license data.
Data rule
Metadata rule
NationalID, PHI
DriversLicense_USA _Narrow
Discovers column data that matches the driver license number format in a majority of the states in the United States. In order to reduce false positives, the data domain does not cover states in which the license format overlaps with other common formats, such as eight-digit date formats.
Discovers column names that can indicate or match terms for driver license data.
Data rule
Metadata rule
PHI
DrivingLicenseNumber
Discovers column data that matches driver license numbers in the United Kingdom, in most states of the Unites States, and in Canadian provinces with the exception of British Columbia, Manitoba, Prince Edward Island, and Quebec.
Discovers column names that can indicate or match terms for driver license data.
Data rule
Metadata rule
PII
Email
Discovers column data that matches a predefined email identification format.
Discovers column names that contain the "email" string.
Data rule
Metadata rule
Contact, PHI, PII
ExpirationDate
Discovers column data that matches expired credit card dates.
Discovers column names that contain the "exp*da*" string or "cr*exp*" string.
Data rule
Metadata rule
PCI
Finland_NationalID
Discovers column data that matches the format of national identity numbers in Finland.
Discovers column names that can indicate or match terms for national identity numbers.
Data rule
Metadata rule
NationalID
FirstName
Discovers column data that matches values in a reference table of first names.
Discovers column names that contain the "f*nam*" string.
Data rule
Metadata rule
Contact, PCI, PHI, PII
France_INSEE
Discovers column data that matches the French Institut National de la Statistique et des Études Économiques (INSEE) number format.
Data rule
NationalID
FullName
Discovers strings in column data that match first, middle, and last names in the reference data.
Discovers column names that can indicate or match terms for full names.
Data rule
Metadata rule
Contact, PCI, PHI, PII
Gender
Discovers column data that matches the gender values in a reference table.
Discovers column names that contain the "gender" string or strings such as "female" and "male".
Data rule
Metadata rule
Contact, PHI, PII
Geocode_Latitude
Discovers column data that matches valid latitude coordinates.
Discovers column names that contain the "latitude" string.
Data rule
Metadata rule
Address, General
Geocode_LatitudeLongitude
Discovers column data that matches valid latitude or longitude coordinates.
Discovers column names that contain strings such as "latitude," "longitude," and "geocode".
Data rule
Metadata rule
Address, General
Geocode_Longitude
Discovers column data that matches valid longitude coordinates.
Discovers column names that contain the "longitude" string.
Data rule
Metadata rule
Address, General
Grade
Discovers column names that contain the "grade" string.
Metadata rule
PII
GreatBritain_NINO
Discovers column data that matches the Great Britain National Insurance number format.
Discovers column names that can indicate or match terms for National Insurance numbers.
Data rule
Metadata rule
NationalID
Health_Plan_Beneficiary_Number
Discovers column names that can indicate or match terms for health plan beneficiary numbers.
Metadata rule
PHI
Height
Discovers column data with values in a range from 1 through 8, where 8 represents feet in height.
Discovers column names that can indicate or match terms for height information.
Data rule
Metadata rule
PHI
Hostname
Discovers column data that matches valid host names.
Discovers column names that can indicate or match terms for host names.
Data rule
Metadata rule
General
IBAN
Discovers column data that matches the International Bank Account Number (IBAN) format of multiple European countries.
Discovers column names that can indicate or match terms for IBAN values.
Data rule
Metadata rule
Account_Bank
ICD_10_Codes
Discovers column data that matches the codes for medical conditions in the tenth revision of the International Statistical Classification of Diseases and Related Health Problems (ICD).
Discovers column names that can indicate or match terms for the ICD codes.
Data rule
Metadata rule
PHI
ICD_9_Codes
Discovers column data that matches the codes for medical conditions in the ninth revision of the International Statistical Classification of Diseases and Related Health Problems (ICD).
Discovers column names that can indicate or match terms for the ICD codes.
Data rule
Metadata rule
PHI
India_NationalID
Discovers column data that matches the format of the Indian Permanent Account Number.
Discovers column names that can indicate or match terms for national identity numbers.
Data rule
Metadata rule
NationalID
IPAddress
Discovers column data that matches a predefined IP address format.
Discovers column names that contain the "ip" string or "inter*port*add" string.
Data rule
Metadata rule
General, PII
ISBN
Discovers column data that matches the International Standard Book Number format.
Discovers column names that can indicate or match terms for International Standard Book Numbers.
Data rule
Metadata rule
General
Italy_FiscalCode
Discovers column data that matches the format of the
Codice Fiscale
 or Fiscal Code number in Italy.
Data rule
NationalID
JobPosition
Discovers column data that includes job position descriptors or job titles.
Discovers column names that contain the "title" string, "position" string, or "designation" string.
Data rule
Metadata rule
PHI, PII
Korea_NationalID
Discovers column data that matches the format of national identity numbers in South Korea.
Discovers column names that can indicate or match terms for national identity numbers.
Data rule
Metadata rule
NationalID
LastName
Discovers column data that matches values in a reference table of last names.
Discovers column names that can indicate or match terms for last name information.
Data rule
Metadata rule
Contact, PCI, PHI, PII
MaidenName
Discovers strings in column data that match last names in the reference data.
Discovers column names that can indicate or match terms for maiden name information.
Data rule
Metadata rule
Contact, PHI, PII
MiddleName
Discovers strings in column data that match first names in the reference data.
Discovers column names that can indicate or match terms for a column of middle name information.
Data rule
Metadata rule
Contact, PHI, PII
Norway_NationalID
Discovers column data that matches the format of national identity numbers in Norway.
Discovers column names that can indicate or match terms for national identity numbers.
Data rule
Metadata rule
NationalID
Passport_DEU_MR
Discovers column data that matches the machine-readable German passport number format.
Data rule
NationalID
Passport_GBR
Discovers column data that matches the United Kingdom passport number format.
Data rule
NationalID
Passport_India
Discovers column data that matches the India passport number format.
Data rule
NationalID
Passport_MachineReadable
Discovers column data that matches machine-readable passport numbers of all countries.
Data rule
NationalID
Passport_USA_MR
Discovers column data that matches machine-readable United States passport number format.
Discovers column names that can indicate or match terms for a column of passport numbers.
Data rule
Metadata rule
NationalID, PHI
PhoneNumber
Discovers column data that matches the United States phone number format.
Discovers column names that contain the "phone" string or "fax" string.
Data rule
Metadata rule
Contact, PHI
Postcode
Discovers column data that matches the postal codes of multiple countries.
Discovers column names that can describe a column of post codes.
Data rule
Metadata rule
Address, PCI
Race
Discovers column data that matches the name of a race of people in the reference data.
Discovers column names that can indicate or match terms for a race of people.
Data rule
Metadata rule
PHI
Religion
Discovers column data that matches the name of a religion in the reference data.
Discovers column names that can indicate or match terms for religion or religious affiliation.
Data rule
Metadata rule
PHI
Romania_NationalID
Discovers column data that matches the format of national identity numbers in Romania.
Discovers column names that can indicate or match terms for national identity numbers.
Data rule
Metadata rule
NationalID
Salary
Discovers column data that can represent an amount of money.
Discovers column names that can indicate or match terms for compensation, salary, or wages.
Data rule
Metadata rule
PII
SouthAfrica_NationalID
Discovers column data that matches the format of national identity numbers in South Africa.
Discovers column names that can indicate or match terms for national identity numbers.
Data rule
Metadata rule
NationalID
SSN
Discovers column data that matches the United States Social Security number format.
Discovers column names that contain the "SSN" string, "social*sec*no" string, or "social* sec*num*" string.
Data rule
Metadata rule
NationalID, PHI
SSN_General
Discovers column data that matches the Social Security number format. Based on the SSN Randomization initiative of June 2011, the data domain does not verify the group and area number combination in a column data value.
Discovers column names that contain the "SSN" string, "social*sec*no" string, or "social* sec*num*" string.
Data rule
Metadata rule
NationalID, PII
State
Discovers column data that matches a state name in the United States.
Discovers column names that contain the "add*sta" string, "state" string, or "us*sta*" string.
Data rule
Metadata rule
PII
Street
Discovers column data that includes any street descriptor in a set of over twenty descriptors that the data rule specifies.
The rule includes the following descriptors:
  • avenue
  • boulevard
  • junction
  • lane
  • road
  • street
  • valley
  • way
Discovers column names that can indicate or match terms for a column of street address information.
Data rule
Metadata rule
PII
Sweden_NationalID
Discovers column data that matches the format of national identity numbers in Sweden.
Discovers column names that can indicate or match terms for national identity numbers.
Data rule
Metadata rule
NationalID
Taiwan_NationalID
Discovers column data that matches the format of national identity numbers in Taiwan.
Discovers column names that can indicate or match terms for national identity numbers.
Data rule
Metadata rule
NationalID
Track1_Format_B
Discovers column data that matches Track 1 Format B credit card data.
Discovers column names that can indicate or match terms for Track 1 Format B information.
Data rule
Metadata rule
PCI
UniqueIdentifyingNumber
Discovers column names that contain the "unique*iden*number" string or "iden*num" string.
Metadata rule
PHI
Unit_of_Measure
Discovers column data that includes units of measurement.
Discovers column names that can indicate or match terms for quantity or units of measurement.
Data rule
Metadata rule
Not applicable
UPC
Discovers column data that matches the format of a valid Universal Product Code or European Article Number.
Discovers column names that can indicate or match terms for Universal Product Codes or European Article Numbers.
Data rule
Metadata rule
General
URL
Discovers column data that matches predefined URL formats.
Discovers column names that contain the "uni*res*loc" string, "URL" string, or "web" string.
Data rule
Metadata rule
PHI
USA_Bank_Account
Discovers column data that matches a bank account number format in the United States.
Discovers column names that can indicate or match terms for bank account information.
Data rule
Metadata rule
PHI, PII
USA_County
Discovers column data that matches a county name in the United States.
Discovers column names that can indicate or match terms for county name information.
Data rule
Metadata rule
Address, PHI, PII
USA_National_Drug_Code_NDC
Discovers column data that matches a National Drug Code (NDC) value in the National Drug Code directory in the United States.
Discovers column names that can indicate or match terms for National Drug Code or NDC information.
Data rule
Metadata rule
PHI
USA_National_Provider_Identifier_Standard_NPI
Discovers column data that matches a National Provider Identifier (NPI) number in the United States.
Discovers column names that can indicate or match terms for National Provider Identifier or NPI information.
Data rule
Metadata rule
PHI
USA_Taxpayer_Identification_Number
Discovers column data that matches the format of an Individual Taxpayer Identification Number (ITIN) in the United States.
Discovers column names that can indicate or match terms for Individual Taxpayer Identification Number or ITIN information.
Data rule
Metadata rule
NationalID, PHI
USZip_5digit
Discovers column data that matches United States ZIP Code values.
Discovers column names that can indicate or match terms for ZIP or post codes.
Data rule
Metadata rule
Address, PHI, PII
VehicleRegPlateNumber
Discovers column names that contain the "registration" string, "number*plate" string, "license*plate" string, or "vehicle*registration" string.
Metadata rule
PHI, PII
Weight
Discovers column data with values in a range from 1 through 500, where 500 represents a weight value.
Discovers column names that can indicate or match terms for weight information.
Data rule
Metadata rule
PHI
ZipCode
Discovers column data that matches United States ZIP codes.
Discovers column names that can indicate or match terms for ZIP or post codes.
Data rule
Metadata rule
PCI, PHI, PII

A Note on Data Domain Group Name Abbreviations

The data domain group name PCI is an abbreviation for Payment Card Industry Information.
The data domain group name PHI is an abbreviation for Protected Health Information.
The data domain group name PII is an abbreviation for Personally Identifiable Information.
0 COMMENTS
We’d like to hear from you!