Geolocation output columns

When the Geolocation process is enabled, DQE adds geolocation output columns to the processed file.

These columns help you understand whether geolocation was performed and read the latitude and longitude coordinates returned by DQE.

Who should read this article

Use this article if your file-based batch processing includes Geolocation and you need to understand the DQE geolocation columns added to your output file.

This article applies to file-based batch processing via SFTP. It does not apply to real-time API responses.

Geolocation columns

Geolocation error code values

The DQE_GEOLOCALISATION_ERROR_CODE column indicates whether geolocation was performed.

Geolocation error label values

The DQE_GEOLOCALISATION_ERROR column provides a readable label for the geolocation result.

Best practices

• Use DQE_GEOLOCALISATION_ERROR_CODE to identify whether geolocation was performed.
• Use DQE_LATITUDE and DQE_LONGITUDE only when the geolocation status confirms that geolocation was performed.
• Review records with missing Hexavia code when geolocation is expected but not returned.
• Keep the original address fields so that you can compare them with the geolocation result.

Related articles

• Understand DQE output columns
• Postal address output columns (RNVP)
• Understand file-based batch processing