Identifier existence (rule category)
From CDQ Wiki
Public:Rule category/Identifier existence
| Property | Value |
|---|---|
| The human-friendly name shown for this concept in the user interface, used instead of the technical name to improve readability and understanding. Display name | Identifier existence |
| Informal and comprehensive human-readable definition of a concept. Description | Uses an external managed business partner data source to check whether the identifier really exists. For example, VIES is asked whether there is a result for a given EU VAT ID. If not, then it is not «existent», respectively unknown and thus wrong. Other examples are the check of ABN numbers against the Australian Business Register or potentially a check whether a given CDQ ID is existing in the Community Pool. |
| Dimensional categorization of a concept, e.g., a data quality dimension of a data quality rule. Dimension | Accuracy |
| Hierachical parent concept of a concept. Parent | Existence (rule category) |
Data quality rules
| Rule | Country | Description | Criticality |
|---|---|---|---|
| Identifier unknown (Australian Business Number (Australia)) | AU (Australia) | For a valid Business Number (Australia) | ERROR |
| Identifier unknown (Australian Company Number (Australia)) | AU (Australia) | For a valid Australian Company Number (ACN) company information is available in the official data published by the Australian Business Register. This rule checks whether the ACN is known which means that it is assigned to a company listed in the Australian Business Register. | ERROR |
| Identifier unknown (Business Registration Number (Egypt)) | EG (Egypt) | This rule checks whether the Business Registration Number is known which means that it is assigned to a business partner listed in Egypt official registry. | ERROR |
| Identifier unknown (Business Registration Number (Estonia)) | EE (Estonia) | This business rule checks the validity of the Business Registration Number against the Estonian Commercial Register. The Business Registration Number is judged as valid by this rule, when it is available, i.e. found, in the commercial register. | ERROR |
| Identifier unknown (Business Registration Number (New Zealand)) | NZ (New Zealand) | This business rule checks the validity of the Business Registration Number (New Zealand) against the NZBN Register. The registration number will be judged valid by this rule if it is available in this data source. | ERROR |
| Identifier unknown (Business Registration Number (Turkey)) | TR (Turkey) | This rule checks whether the Business Registration Number is known which means that it is assigned to a business partner listed in Turkey official registry. | ERROR |
| Identifier unknown (Business identity code (Finland)) | FI (Finland) | The Business ID (Business Identity Code) is a code given to businesses and organizations by the PRH or the Tax Administration. This rule checks whether the identity code is findable in the Finish Business Information System. If it cannot be found, the identifier is treated as invalid and the data quality rule is violated. | ERROR |
| Identifier unknown (CNPJ number (Brazil)) | BR (Brazil) | This business rule checks the validity of the CNPJ number against Brazilian Register Receita Federal. The CNPJ number is valid, when it is available in the Register. | ERROR |
| Identifier unknown (CPF number (Brazil)) | BR (Brazil) | This business rule checks the validity of the CPF number against Brazilian Register. The CPF number is valid, when it is available in the Register. | ERROR |
| Identifier unknown (CPR number (Greenland)) | GL (Greenland) | This rule checks whether the CPR number is known which means that it is assigned to a business partner listed in the Greenland official registry. | ERROR |
| Identifier unknown (CUIT number (Argentina)) | AR (Argentina) | This business rule checks the validity of the CUIT number against the national registry of companies (Argentina). The CUIT number is valid, when it is available in the national registry of companies (Argentina). | ERROR |
| Identifier unknown (CVR number (Denmark)) | DK (Denmark) | This business rule checks the validity of the CVR number (Denmark) against the Data source/DK.CR | ERROR |
| Identifier unknown (Chamber of Commerce Number (Egypt)) | EG (Egypt) | This rule checks whether the Chamber of Commerce Number is known which means that it is assigned to a business partner listed in Egypt official registry. | ERROR |
| Identifier unknown (Chamber of Commerce Number (Morocco)) | MA (Morocco) | This rule checks whether the Chamber of Commerce Number is known which means that it is assigned to a business partner listed in Morocco official registry. | ERROR |
| Identifier unknown (Chamber of Commerce Number (Turkey)) | TR (Turkey) | This rule checks whether the Chamber of Commerce Number is known which means that it is assigned to a business partner listed in Turkey official registry. | ERROR |
| Identifier unknown (Common business identifier (Morocco)) | MA (Morocco) | This rule checks whether the Common business identifier is known which means that it is assigned to a business partner listed in Morocco official registry. | ERROR |
| Identifier unknown (Company Registration Number (Hong Kong)) | HK (Hong Kong) | This rule checks whether the Company Registration Number (Hong Kong) is a really existing by checking whether it can be found in the business register. If it is not available, the identifier will be treated as invalid and the data quality rule is violated. | ERROR |
| Identifier unknown (Company identification number (Switzerland)) | CH (Switzerland) | This business rule checks the existence of the given Company identification number (Switzerland) against the Data source/CH.UIDR | ERROR |
| Identifier unknown (Company number (Ireland)) | IE (Ireland) | This rule checks whether the Company_number_(Ireland) is a really existing by checking whether it can be found in the business register. If it is not available, the identifier will be treated as invalid and the data quality rule is violated. | ERROR |
| Identifier unknown (Company registration number (United Kingdom)) | GB (United Kingdom of Great Britain and Northern Ireland) | This business rule checks the validity of the Company registration number against Companies House. The registration valid number number is valid, when it is available in the company register . | ERROR |
| Identifier unknown (Corporate number (Japan)) | JP (Japan) | This rule checks whether the Corporate number (Japan) is really existing by checking whether it can be found in the business register. If it is not available, the identifier will be treated as invalid and the data quality rule is violated. | ERROR |
| Identifier unknown (Corporation number (Canada)) | CA (Canada) | This business rule checks the validity of the Corporation number (Canada) against the Canadian Corporation Register. The Corporation number will be judged valid by this rule if it is available in the register. | ERROR |
| Identifier unknown (EORI number (European Union)) | CDQ/Business Partner/Address/Country/country | This business rule checks the existence of the EORI number against the EU.EORI register. The EORI is judged as valid, when it is available in this register. | ERROR |
| Identifier unknown (EORI number (United Kingdom)) | GB (United Kingdom of Great Britain and Northern Ireland) | This business rule checks the existence of the EORI number against the UK.EORI register. The EORI is judged as valid, when it is available in this register. | ERROR |
| Identifier unknown (Enterprise number (Belgium)) | BE (Belgium) | This business rule checks the existence of the Enterprise number (Belgium) in the KBO Central Belgium Company Database. | ERROR |
| Identifier unknown (European value added tax identifier (Austria)) | AT (Austria) | European value added tax identifier (Austria) | ERROR |
| Identifier unknown (European value added tax identifier (Belgium)) | BE (Belgium) | European value added tax identifier (Belgium) | ERROR |
| Identifier unknown (European value added tax identifier (Bulgaria)) | BG (Bulgaria) | European value added tax identifier (Bulgaria) | ERROR |
| Identifier unknown (European value added tax identifier (Croatia)) | HR (Croatia) | European value added tax identifier (Croatia) | ERROR |
| Identifier unknown (European value added tax identifier (Cyprus)) | CY (Cyprus) | European value added tax identifier (Cyprus) | ERROR |
| Identifier unknown (European value added tax identifier (Czech Republic)) | CZ (Czechia) | European value added tax identifier (Czech Republic) | ERROR |
| Identifier unknown (European value added tax identifier (Denmark)) | DK (Denmark) | European value added tax identifier (Denmark) | ERROR |
| Identifier unknown (European value added tax identifier (Estonia)) | EE (Estonia) | European value added tax identifier (Estonia) | ERROR |
| Identifier unknown (European value added tax identifier (Finland)) | FI (Finland) | European value added tax identifier (Finland) | ERROR |
| Identifier unknown (European value added tax identifier (France)) | FR (France) | European value added tax identifier (France) | ERROR |
| Identifier unknown (European value added tax identifier (Germany)) | DE (Germany) | European value added tax identifier (Germany) | ERROR |
| Identifier unknown (European value added tax identifier (Greece)) | GR (Greece) | European value added tax identifier (Greece) | ERROR |
| Identifier unknown (European value added tax identifier (Guadeloupe)) | GP (Guadeloupe) | European VAT IDs issued in France are exchanged via a central system provisioned by the European Commission (i.e. VAT Information Exchange System (VIES)). This rule checks whether for a business partner in Guadeloupe a given French EU VAT ID is known to this central exchange system. If it is not available, the identifier is treated as invalid and the data quality rule is violated. | ERROR |
| Identifier unknown (European value added tax identifier (Hungary)) | HU (Hungary) | European value added tax identifier (Hungary) | ERROR |
| Identifier unknown (European value added tax identifier (Ireland)) | IE (Ireland) | European value added tax identifier (Ireland) | ERROR |
| Identifier unknown (European value added tax identifier (Italy)) | IT (Italy) | European value added tax identifier (Italy) | ERROR |
| Identifier unknown (European value added tax identifier (Latvia)) | LV (Latvia) | European value added tax identifier (Latvia) | ERROR |
| Identifier unknown (European value added tax identifier (Lithuania)) | LT (Lithuania) | European value added tax identifier (Lithuania) | ERROR |
| Identifier unknown (European value added tax identifier (Luxembourg)) | LU (Luxembourg) | European value added tax identifier (Luxembourg) | ERROR |
| Identifier unknown (European value added tax identifier (Malta)) | MT (Malta) | European value added tax identifier (Malta) | ERROR |
| Identifier unknown (European value added tax identifier (Martinique)) | MQ (Martinique) | European VAT IDs issued in France are exchanged via a central system provisioned by the European Commission (i.e. VAT Information Exchange System (VIES)). This rule checks whether for a business partner in Martinique a given French EU VAT ID is known to this central exchange system. If it is not available, the identifier is treated as invalid and the data quality rule is violated. | ERROR |
| Identifier unknown (European value added tax identifier (Poland)) | PL (Poland) | European value added tax identifier (Poland) | ERROR |
| Identifier unknown (European value added tax identifier (Portugal)) | PT (Portugal) | European value added tax identifier (Portugal) are exchanged via a central system provisioned by the European Commission (i.e. VAT Information Exchange System (VIES)). This rule checks whether the Portugal EU VAT ID is known to this central exchange system. If it is not available, the identifier is treated as invalid and the data quality rule is violated. | ERROR |
| Identifier unknown (European value added tax identifier (Reunion)) | RE (Réunion) | European VAT IDs issued in France are exchanged via a central system provisioned by the European Commission (i.e. VAT Information Exchange System (VIES)). This rule checks whether for a business partner in Reunion a given French EU VAT ID is known to this central exchange system. If it is not available, the identifier is treated as invalid and the data quality rule is violated. | ERROR |
| Identifier unknown (European value added tax identifier (Romania)) | RO (Romania) | European value added tax identifier (Romania) | ERROR |
| Identifier unknown (European value added tax identifier (Slovakia)) | SK (the Slovak Republic) | European value added tax identifier (Slovakia) | ERROR |
| Identifier unknown (European value added tax identifier (Slovenia)) | SI (Slovenia) | European value added tax identifier (Slovenia) | ERROR |
| Identifier unknown (European value added tax identifier (Spain)) | ES (Spain) | European value added tax identifier (Spain) | ERROR |
| Identifier unknown (European value added tax identifier (Sweden)) | SE (Sweden) | European value added tax identifier (Sweden) | ERROR |
| Identifier unknown (European value added tax identifier (The Netherlands)) | NL (Netherlands) | European value added tax identifier (The Netherlands) | ERROR |
| Identifier unknown (European value added tax identifier (United Kingdom (Northern Ireland))) | XI (United Kingdom (Northern Ireland), Northern Ireland) | European value added tax identifier (United Kingdom (Northern Ireland)) | ERROR |
| Identifier unknown (European value added tax identifier (United Kingdom)) | GB (United Kingdom of Great Britain and Northern Ireland) | United Kingdom European VAT IDs are exchanged via a central system provisioned by the European Commission (i.e. VAT Information Exchange System (VIES)). This rule checks whether the United Kingdom EU VAT ID is known to this central exchange system. If it is not available, the identifier is treated as invalid and the data quality rule is violated. | ERROR |
| Identifier unknown (Faroese Identification Number (Faroe Islands)) | FO (Faroe Islands) | This rule checks whether the Faroese Identification Number is known which means that it is assigned to a business partner listed in the Faroe Islands official registry. | WARNING |
| Identifier unknown (Faroese P Number (Faroe Islands)) | FO (Faroe Islands) | This rule checks whether the Faroese P Number is known which means that it is assigned to a business partner listed in the Faroe Islands official registry. | ERROR |
| Identifier unknown (Faroese V Number (Faroe Islands)) | FO (Faroe Islands) | This rule checks whether the Faroese V Number is known which means that it is assigned to a business partner listed in the Faroe Islands official registry. | ERROR |
| Identifier unknown (Fiscal Registration Code (Romania)) | RO (Romania) | This rule checks whether the Fiscal Registration Code (Romania) is really existing by checking whether it can be found in the business register. If it is not available, the identifier will be treated as invalid and the data quality rule is violated. | ERROR |
| Identifier unknown (GER number (Greenland)) | GL (Greenland) | This rule checks whether the GER number is known which means that it is assigned to a business partner listed in the Greenland official registry. | ERROR |
| Identifier unknown (Government Gazette Number (Turkey)) | TR (Turkey) | This rule checks whether the Government Gazette Number is known which means that it is assigned to a business partner listed in Turkey official registry. | ERROR |
| Identifier unknown (ICO number (Czech Republic)) | CZ (Czechia) | This business rule checks the availability in the ICO number (Czech Republic) in the public data provided by the Data source/CZ.REE | ERROR |
| Identifier unknown (ICO number (Slovakia)) | SK (the Slovak Republic) | This business rule checks the availability in the ICO number (Slovakia) in the public data provided by the Data source/SK.FS | ERROR |
| Identifier unknown (Icelandic Identification Number (Iceland)) | IS (Iceland) | This rule checks whether the Icelandic Identification Number is known which means that it is assigned to a business partner listed in the Iceland official registry. | ERROR |
| Identifier unknown (KRS number (Poland)) | PL (Poland) | This business rule checks the validity of the KRS number (Poland) against Official Business Register (EMS). The KRS number (Poland) is valid, when it is available in the EMS. | ERROR |
| Identifier unknown (Legal Entity Identifier) | WORLD (World) | This business rule checks the validity of the LEI number against the Global Legal Entity Identifier Foundation Database. The LEI number will be judged valid by this rule if it is available in the Global Legal Entity Identifier Foundation. | ERROR |
| Identifier unknown (NIP number (Poland)) | PL (Poland) | This business rule checks the validity of the NIP number (Poland) against Official Business Register (EMS). The NIP number (Poland) is valid, when it is available in the EMS. | ERROR |
| Identifier unknown (NIT number (Bolivia)) | BO (Bolivia) | This rule checks whether the Tax Identification Number is known which means that it is assigned to a business partner listed in the Bolivia official registry. | ERROR |
| Identifier unknown (National business register identifier (Austria)) | AT (Austria) | This rule checks whether the National business register identifier (Austria) is a really existing one by checking whether it can be found in the business register. If it is not available, the identifier will be treated as invalid and the data quality rule is violated. | ERROR |
| Identifier unknown (Organization Number (Norway)) | NO (Norway) | This business rule checks the validity of the Organization Number (Norway) against the Norwegian register of companies. The Organization Number will be judged valid by this rule if it is available in the register. | ERROR |
| Identifier unknown (REGON (Poland)) | PL (Poland) | This business rule checks the validity of the REGON (Poland) against REGON register (Poland) | ERROR |
| Identifier unknown (RIF number (Venezuela)) | VE (Venezuela) | This rule checks whether the RIF number is known which means that it is assigned to a business partner listed in Venezuela official registry. | ERROR |
| Identifier unknown (SIREN number (France)) | FR (France) | This business rule checks the validity of the SIREN number against France Register of Companies . The SIREN number number is valid, when it is available in the France Register of Companies . | ERROR |
| Identifier unknown (SIRET number (France)) | FR (France) | This business rule checks the validity of the SIRET number against France Register of Companies . The SIRET number number is valid, when it is available in the France Register of Companies . | ERROR |
| Identifier unknown (Social Security Number (Jersey)) | JE (Jersey) | This rule checks whether the Social Security Number is known which means that it is assigned to a business partner listed in the Jersey official registry. | ERROR |
| Identifier unknown (Social Security Number (San Marino)) | SM (San Marino) | This rule checks whether the Social Security Number is known which means that it is assigned to a business partner listed in the San Marino official registry. | ERROR |
| Identifier unknown (TVA number (Tunisia)) | TN (Tunisia) | This rule checks whether the Tax Identification Number is known which means that it is assigned to a business partner listed in the Tunisia official registry. | ERROR |
| Identifier unknown (Tax Reference Number (Jersey)) | JE (Jersey) | This rule checks whether the Tax Reference Number is known which means that it is assigned to a business partner listed in the Jersey official registry. | ERROR |
| Identifier unknown (Tax Registration Number (Egypt)) | EG (Egypt) | This rule checks whether the Tax Registration Number is known which means that it is assigned to a business partner listed in Egypt official registry. | ERROR |
| Identifier unknown (Tax Registration Number (Morocco)) | MA (Morocco) | This rule checks whether the Tax Registration Number is known which means that it is assigned to a business partner listed in Morocco official registry. | ERROR |
| Identifier unknown (Tax Registration Number (San Marino)) | SM (San Marino) | This rule checks whether the Tax Registration Number is known which means that it is assigned to a business partner listed in the San Marino official registry. | ERROR |
| Identifier unknown (Tax identification number (Egypt)) | EG (Egypt) | This rule checks whether the Tax identification number is known which means that it is assigned to a business partner listed in Egypt official registry. | ERROR |
| Identifier unknown (Tax number (Turkey)) | TR (Turkey) | This rule checks whether the Tax number is known which means that it is assigned to a business partner listed in Turkey official registry. | ERROR |
| Identifier unknown (Tax office name (Turkey)) | TR (Turkey) | This rule checks whether the Tax office name is known which means that it is assigned to a business partner listed in Turkey official registry. | ERROR |
| Identifier unknown (UEN number (Singapore)) | SG (Singapore) | This business rule checks the validity of the UEN number (Singapore) against the Data source/SG.BR | ERROR |
| Identifier unknown (VAT number (Norway)) | NO (Norway) | This business rule checks the validity of the VAT number (Norway) against the Brønnøysund Register Centre. The VAT number (Norway) is judged as valid by this rule, when it is available, i.e. found, in the register. | INFO |
| Identifier unknown (VAT registration number (Israel)) | IL (Israel) | This rule checks whether the VAT registration number (Israel) is really existing by checking whether it can be found in the business register. If it is not available, the identifier will be treated as invalid and the data quality rule is violated. | ERROR |
| Identifier unknown (VAT registration number (Switzerland)) | CH (Switzerland) | This business rule checks the validity of the VAT ID identifier against UID-Register from Switzerland, also in case when the business entity information incomplete/unavailable is. The VAT ID is valid, when it is available in the UID-Register, also when the company already closed/inactive is. | ERROR |
| Identifier unknown (VAT registration number (United Kingdom)) | GB (United Kingdom of Great Britain and Northern Ireland) | This business rule checks the existence of the UK VAT number against the UK VAT register. The VAT is judged as valid, when it is available in this register. | ERROR |
| Identifier unknown (Value Added Tax Number (Iceland)) | IS (Iceland) | This rule checks whether the Value Added Tax Number is known which means that it is assigned to a business partner listed in the Iceland official registry. | WARNING |