Address checks
Public:Rule Feature/ADDRESS CHECKS
| Property | Value |
|---|---|
| A technical identifier, unique in a certain context. Technical key | ADDRESS_CHECKS
|
| 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 | Address checks |
| An informal and short human-readable definition of a concept, in terms of a 'one-liner'. Short description | CDQ address checks ensure that business partner address data is accurate, complete, and compliant with country-specific standards. |
| Informal and comprehensive human-readable definition of a concept. Description | CDQ address checks ensure that business partner address data is accurate, complete, and compliant with country-specific standards. These checks validate the presence and correctness of essential elements such as administrative areas, localities, and thoroughfares. Post codes are managed separately. They detect incomplete or outdated information, flag misplaced components like "care of" or contact details, and ensure postal codes and phone numbers follow correct formats. Additionally, the system identifies inactive addresses and ensures that all required fields, such as postal codes and administrative areas, are correctly populated. By applying these validations, the checks maintain high data quality and reduce errors. |
| Category of a concept, not managed by wiki categories but regular pages. Category | Address inactive, Address incomplete, Address consistency, Administrative area invalid, Public:Rule_Category/ADMINISTRATIVE_AREA_MISSING, Country invalid, Dummy postal code, Missing locality, Phone number format, Phone number misplaced, PO Box misplaced, Public:Rule_Category/POSTAL_CODE_FORMAT, Postal code invalid, Public:Rule_Category/POSTAL_CODE_MISSING, Postal code outdated, Postal code schema, Street address incomplete, Public:Rule_Category/THOROUGHFARE_MISSING |
CDQ manages 1,246 data quality rules in this feature, grouped by the following rule categories.
- Address consistency (1 rules): Validates that related address fields maintain the real world consistency with each other.
- Address inactive (1 rules): Flags addresses that are marked as inactive, closed, or no longer current.
- Address incomplete (0 rules): Flags addresses that are missing essential components required for completeness and usability.
- Administrative area invalid (0 rules): Flags administrative areas (states, provinces, regions) that don't exist or are invalid for the given country.
- Country invalid (6 rules): Flags addresses with country values that are misplaced, incorrectly formatted, or don't match expected country codes.
- Dummy postal code (251 rules): Detects postal codes that follow dummy or placeholder patterns indicating invalid data.
- Missing locality (200 rules): Identifies addresses that lack locality information (city, town, village) where it's required.
- PO Box misplaced (9 rules): Detects PO Box information placed in street address fields instead of designated PO Box fields.
- Phone number format (0 rules): Validates that phone numbers follow correct formatting conventions and structural patterns.
- Phone number misplaced (1 rules): Identifies phone numbers incorrectly placed in address, name, or other non-phone fields.
- Postal code invalid (0 rules): Identifies postal codes that don't exist in the postal code registry for the given country.
- Postal code outdated (8 rules): Identifies postal codes that have been retired or replaced in postal code updates.
- Postal code schema (2 rules): Validates that postal codes follow official formatting schemas with correct spacing and separators.
- Street address incomplete (0 rules): Flags street addresses that lack required components like thoroughfare, locality, or postal code.