Postal address output columns (RNVP)

Support DQE
Support DQE
  • Updated

When the RNVP postal address validation process is enabled, DQE adds postal address output columns to the processed file.

These columns help you read the standardized address returned by DQE and understand the quality status of the postal address.

Who should read this article

Use this article if your file-based batch processing includes RNVP postal address validation and you need to understand the DQE address 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.

Postal address columns

Column Description
DQE_ADR1 Line 1 according to the AFNOR standard: concatenation of name and first name, or company name.
DQE_ADR2 Line 2 according to the AFNOR standard: delivery point.
DQE_ADR3 Line 3 according to the AFNOR standard: geographical location.
DQE_ADR4 Line 4 according to the AFNOR standard: number, street type, and street name.
DQE_ADR5 Line 5 according to the AFNOR standard: dependent locality or distribution service.
DQE_CP_VILLE Line 6 according to the AFNOR standard: concatenation of postal code and city fields.
DQE_CP Postal code field.
DQE_VILLE City field.
DQE_PAYS Country field.
DQE_NUM_VOIE Street number.
DQE_BIS_TER Additional number information.
DQE_TYPE_VOIE_COURT Short street type.
DQE_TYPE_VOIE_LONG Long street type.
DQE_LIB_VOIE Street name.
DQE_NUM_DEPT Department number.
DQE_LIB_DEPT Department label.
DQE_PREFECTURE Capital or principal town.
DQE_REGION_ADMINISTRATIVE New French administrative division.
DQE_INSEE INSEE code.
DQE_HEXACLE Identifier of the street number in the La Poste repository.
DQE_HEXAPOSTE Identifier of the city in the La Poste repository.
DQE_HEXAVIA Identifier of the street in the La Poste repository.
DQE_IGN_X Longitude coordinates of the city center.
DQE_IGN_Y Latitude coordinates of the city center.
DQE_IRIS_ILOT99 IRIS code, no longer used.
DQE_IRIS_CODEIRIS IRIS code.
DQE_CQ_IRIS IRIS code enrichment quality indicator.
DQE_CQ_COMP Quality indicator for the recovery of address line 3.
DQE_CQ_ADRS Address quality code.
DQE_STATUT_RNVP RNVP postal validation status.
DQE_ERROR Simplified RNVP error code: OK or KO.

RNVP status values

The DQE_STATUT_RNVP column indicates whether the address is valid, modified, invalid, or ambiguous after RNVP processing.

Value Description
OK NON-MODIFIEE Valid and unmodified address.
OK MODIFIEE Valid address, modified by the RNVP process.
KO NON-MODIFIEE Invalid and unmodified address.
KO MODIFIEE Invalid and modified address.
KO MODIFIEE AMBIGUE Invalid address, modified by the RNVP process without certainty.
OK MODIFIEE AMBIGUE Valid address, modified by the RNVP process without certainty.

Address quality code values

The DQE_CQ_ADRS column provides a detailed address quality code.

Value Description
10 Valid address.
20 Valid address. Street not recognized, but it is a CEDEX or BP.
21 Small city. Street number out of range.
22 Small city. Street number missing, but the rest of the address is valid.
23 Large city. Street number out of range.
24 Large city. Street number is missing, but the rest of the address is valid.
25 Address is a CEDEX unknown from the Cedexa database, if Cedexa is active.
30 Small city. Unknown street name.
31 Small city. Unknown street name. District information is recognized but does not allow the street name to be deduced.
40 Small city. Missing street name. District information is recognized but does not allow the street name to be deduced.
41 Small city. Missing street name.
50 Large city. Unknown street name.
51 Large city. Unknown street name. District information is recognized but does not allow the street name to be deduced.
60 Large city. Missing street name. District information is recognized but does not allow the street name to be deduced.
61 Large city. Missing street name.
70 Zip code and city do not match. Street name exists.
71 Zip code and city are not correctable, and the street is missing.
80 The address input field is empty.
81 The recipient identity and address input fields are empty.
90 Foreign address detected.

Additional address line quality values

The DQE_CQ_COMP column describes the quality of the additional address line.

Value Description
1 Additional address line OK.
2 Additional address line OK. It corresponds to the street but not to the number.
3 Additional address line OK but does not correspond to the street.
4 Additional address line is not present in the repository.
5 Additional address line conflicts with the repository.
7 Missing additional address line. It was not inserted because of a conflict between several values.
8 Missing additional address line. It was not inserted according to the configured option.
9 Empty additional address line, or Hexaline3 rights are not activated.

IRIS quality values

The DQE_CQ_IRIS column describes the result of the IRIS information search.

Value Description
1 IRIS information found.
2 Ambiguity in the search, such as a split street with no street number or inaccuracies in the IRIS repository.
8 IRIS information missing or not found.
9 No IRIS information requested, or rights are not activated.

Best practices

  • Use DQE_STATUT_RNVP to quickly identify valid, modified, invalid, or ambiguous postal addresses.
  • Use DQE_CQ_ADRS when you need a more detailed explanation of the address quality.
  • Review ambiguous statuses before applying automatic updates to production data.
  • Keep the original input address fields so that you can compare them with the standardized DQE address fields.

Related articles

Was this article helpful?

0 out of 0 found this helpful