Category:Data quality rule

From CDL
Jump to: navigation, search

Business rules which are used to ensure data quality and data management performance in the Corporate Data League (complete list: Excel).

 Has description
Business partner name missingIt is necessary that each business partner has at least one name. With respect to the CDL data model it is at least required that a name of type LOCAL or INTERNATIONAL is present.
Cadastro de Pessoa Fisica invalid (Brazil)The CPF number is an identification number of Brazilian citizens emitted by the Brazilian Ministry of Revenue, which is called "Ministério da Fazenda". CPF stands for "Cadastro de Pessoa Física" (literally, physical person registration) as opposed to the CNPJ number for companies. CPF consists of C1...C11. Where C1...C9 consists of random numbers and C10, C11 are the check numbers. The check number can be calculated by the following methods.

- From right to left all digits are multiplied by a descending sequence starting with 9. - The sum of all products is computed. - The sum of step 2 is taken modulo 11. - The result of step 3 is taken modulo 10.

- The checkdigit found is appended to the number and steps 1 to 4.
Care of information misplacedCare of (typicall indicated by "c/o") information must not be maintained in the business partner's name, locality or thoroughfare but is to be managed as care of attribute. If there is care of information found as an attribute value other than "care of" the rule is violated.
EIN format invalid (United States)This rule checks the format of Employer identification number (United States) as described in the additional information tab
Fundamental address parts missingIt is necessary that an address, PO Box- or street address, comprises at least a post code or locality.
Identifier Format invalid(Tax identification Number(Italy))Tax Identification Number(Italy) is known as Codice Fiscale and consists of 16 digits of characters, where C1 to C6 Alphabetic, C7, and C8 is Numeric, C9 is Alphabetic, C10, and C11 is Numeric, C12 is Alphabetic, C13 to C15 belongs to Numeric and C16 is the Numeric.

C1 C2 C3 - Are letters for the last name. C4 C5 C6 - Are letter for the name. C7 C8 - Are numbers for the year of birth. C9 - Is a letter for the month of birth. C10 C11 -Are numbers for the day of birth and sex. C12 C13 C14 C15 - Are one letter and three numbers for the Italian town or to the foreign state of birth.

C16 - Have a supervisory function. It is a checksum digit.
Identifier format invalid (Business number (Canada))The Canadian business number consists of exactly 9 numerical digits. The rule checks whether there are exactly 9 numerical digits available not considering possible whitespaces or other delimiters between the digits.
Identifier format invalid (CNPJ number (Brazil))The CNPJ consists of a 14-digit number formatted as 00.000.000/0001-00 — The first eight digits identify the company, the four digits after the slash identify the branch or subsidiary ("0001" defaults to the headquarters), and the last two are check digits. This rule checks the existence of exactly 14 digits without considering the concrete formatting using ".","/" or "-".
Identifier format invalid (CUIT number (Argentina))The CUIT number in Argentina consists of 11 numerical digits.
Identifier format invalid (Corporate number (Japan))The Corporate number in Japan consists of exactly 13 numerical digits. The first digit is the check digit and cannot be 0.
... further results
 Has description
Inconsistency between BIC FI and EU VAT ID FI (Finland)The Business identity code in Finland and the European VAT number in Finland share identical values. The numerical digits of the EU VAT are identical with the business identity code. There is an inconsistency when the 8 digits after the FI prefix of the EU VAT are different to the 8 digits of the business identity code (usually formatted like this "1234567-8", the dash and the EU VAT prefix "FI" are omitted by this rule)
Inconsistency of country and country codeCountry and country code information must be consistent according to the specified reference country names and codes
Inconsistency of post code and localityPost code and locality information must be consistent according to postal registries in a given country. The CDL uses the public GeoNames database to validate consistency of post code and locality information.
Natural person identifiedIn the CDL no natural persons are managed. This rule checks whether a record represents a natural person. In course of the CDL collaboration process these records are preventively deleted.
Post code format invalid (Spain)This rule checks the postcode format of Spain. Postal codes (Código Postal) in Spain consist of a block of 5 digits which should be placed before the town name on the last line of the address. The first two digits of the postal code, ranging from 01 to 52, indicate the province. The third digit indicates a place within the province. If this digit is 0, the address is in the capital of the province, if it is 1 it is in the vicinity of the capital, and so on. The higher this number, the further the address is from the region’s capital. The last two digits are split into three ranges of numbers
Post code invalidThe value of a post code must be registered as a post code in a given country. The CDL uses mainly the public GeoNames database to validate post codes.
Post code invalid (United States)This rule checks the post code format of United States. Known as the ZIP code (Zone Improvement Program code), this can contain a block of 5 digits or, for more accurate delivery, 9 digits in this format: NNNNN-NNNN. This is known as ZIP + 4. Though many companies use the ZIP code as a locational indicator (for example, when assigning local state taxes for mail-ordered items), there are a small number of communities on state borders which have the same ZIP code as a neighbouring community in another state. There is currently legislation in the American senate to give these communities their own ZIP codes. The first three digits of the postal code indicate the routing zone or processing and delivery centre. The next two indicate the post office or delivery section. The first two digits of the code after the hyphen indicate a sector, the final two a segment.
Unknown administrative area level 1This rule checks wheter a given administrative area is known by the CDL reference data. The CDL refers to the region list as maintained by ISO 3166.
VAT ID missing (Switzerland)In Switzerland each company has a National identifier (Switzerland)UID
 Has description
Company is greylistedThe rule checks whether a given business partner is known to be inactive by means of being "out of business", "in liquidation" or in a similar status. For this purpose the rule searches for information in the CDL business partner repository and in addition in several connected data sources. These are:
  • UK: Companies House
  • CH: Swiss business register
  • FR: French business register (SIREN)
  • ... further will follow
Contact information misplacedContact information is not allowed in the registered name, trade name or international name. This rule checks whether contact information is misplaced by identifying e.g. common keywords such as "attn:" or "z.Hd." and additionally parsing the company name for natural person names that are not meant to be part of the legal name (e.g. when natural person names are placed after the legal form)
Identifier format invalid (Tax identification number (South Africa))A South African Income Tax reference number is 10 numeric digits long, with a slash after the fourth and seventh digit. The tax reference number can only start with 0, 1, 2, 3 or 9. This rule accepts number also without slash or dot.
Invalid mobile phone number format (Malaysia)This rule checks whether a given mobile phone number in Malaysia is valid according to the standard schema of mobile numbers in Malaysia.
Invalid phone numberThis is an experimental rule that checks the validity of a given phone number. Phone numbers are not yet in the scope of the CDL! In the future the phone number format can be selected from one of the standards: E164, RFC3966, International, National
InvalidPhoneNumberFormatThis is an experimental rule that checks the format of a given phone number. Phone numbers are not yet in the scope of the CDL! In the future the phone number format can be selected from one of the standards: E164, RFC3966, International, National
Legal form invalidEach country has different legal forms that an organization can possess. This rule ensures that an organization can never possess a legal form that is not a valid legal form in the country of the organization's legal address.
Legal form missingIn general, each business partner must have exactly one legal form. For example, a business partner can never be an Aktiengesellschaft and a Gesellschaft mit beschraenkter Haftung at the same time. However, business partners that are marked by a no legal form required category are valid also without a legal form value.
Post code format inaccurate (Japan)Post codes in Japan should always be used in the format NNN-NNNN. This means the hyphen is mandatory for this rule!
Real validation of registered name and VAT (Switzerland)Checks whether the given name and the Swiss VAT number do fit to each other according to the data available in the CDL database and the Swiss company register database
... further results

Pages in category "Data quality rule"

The following 200 pages are in this category, out of 1,174 total.

(previous page) (next page)



(previous page) (next page)