Informatica Data Quality
- Informatica Data Quality 10.5
- All Products
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:
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:
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:
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
|