Map custom country codes

Use the app's Country mappings page to manage how address source data resolves to the ISO3 country codes used by validation. Country mappings help normalize different country names, abbreviations, and local variants contained in source data. For example, you can resolve values such as United Kingdom, UK, GB, or GBR to GBR.

Resolver

Use Resolver to check how a country value will resolve before saving a new custom mapping. Enter a value in Country input, then select Resolve. The app returns the resolved ISO3 country code when a mapping exists.

SELECT EXPERIAN_DATA_VALIDATION.CONFIG.ResolveCountryIso('United Kingdom') AS country_iso;

Custom mappings

Use Custom mappings for aliases or local variants that are not covered by the default catalogue. Custom mappings override the app defaults. Removing a custom mapping makes that country input fall back to the built-in defaults.

Add or update

Use Add or update mapping to create or replace a custom mapping.

CALL EXPERIAN_DATA_VALIDATION.CONFIG.UpsertCountryIsoMapping('Republic of Ireland', 'IRL');

Remove

Use Remove mapping to delete a custom mapping.

CALL EXPERIAN_DATA_VALIDATION.CONFIG.DeleteCountryIsoMapping('Republic of Ireland');

Effective mappings

Use Effective mappings to review the combined lookup used by the validation flow, including both default and custom mappings.

SELECT country_name, country_iso, country_alpha2, source
FROM EXPERIAN_DATA_VALIDATION.CONFIG.country_iso_mapping
ORDER BY source, country_name;