When the ID Check Plus process is enabled, DQE adds extended identity check output columns to the processed file.
These columns help you understand whether an individual or household has been identified at the provided address using partner databases, and how closely additional fields such as birthdate, phone, and email match the reference data.
Who should read this article
Use this article if your file-based batch processing includes ID Check Plus and you need to understand the DQE identity check 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.
ID Check Plus columns
| Column | Description |
|---|---|
DQE_IDCHECK_PLUS_ERROR_CODE |
Overall ID Check Plus result code. |
DQE_IDCHECK_PLUS_ERROR_LABEL |
Overall ID Check Plus result label. |
DQE_IDCHECK_PLUS_FIRSTNAME_ERROR_CODE |
Comparison code for the first name. |
DQE_IDCHECK_PLUS_LASTNAME_ERROR_CODE |
Comparison code for the last name. |
DQE_IDCHECK_PLUS_ADDRESS_ERROR_CODE |
Comparison code for the address. |
DQE_IDCHECK_PLUS_POSTALCODE_ERROR_CODE |
Comparison code for the postal code. |
DQE_IDCHECK_PLUS_CITY_ERROR_CODE |
Comparison code for the city. |
DQE_IDCHECK_PLUS_BIRTHDATE_ERROR_CODE |
Comparison code for the birthdate. |
DQE_IDCHECK_PLUS_PHONE_ERROR_CODE |
Comparison code for the phone number. |
DQE_IDCHECK_PLUS_EMAIL_ERROR_CODE |
Comparison code for the email address. |
Overall ID Check Plus result codes
The DQE_IDCHECK_PLUS_ERROR_CODE column indicates whether DQE identified the individual or household at the provided address.
| Value | Description |
|---|---|
FOUND |
Individual or household identified at the address provided via partner databases. |
NOT FOUND |
Individual or household not identified at the address provided via partner databases. |
EMPTY |
Insufficient reconciliation elements for identification of the individual or household via partner databases. |
Overall ID Check Plus result labels
The DQE_IDCHECK_PLUS_ERROR_LABEL column provides a readable label for the overall ID Check Plus result.
| Value | Description |
|---|---|
ID VALID |
Individual or household identified at the address provided via partner databases. |
ID NOT VALID |
Individual or household not identified at the address provided via partner databases. |
Last Name, Code Postal, or Address Fields empty |
Insufficient reconciliation elements for identification of the individual or household via partner databases. |
Field comparison values
The following values can be returned in the field-level comparison columns for first name, last name, address, postal code, city, phone, and email.
| Value | Description |
|---|---|
E |
Exact. |
S |
Similar. |
P |
Close. |
D |
Different. |
? |
Not provided as input. |
Address-specific value
The address comparison column may also return the following value:
| Value | Description |
|---|---|
N |
Different street number, but identical street. |
Birthdate comparison values
The DQE_IDCHECK_PLUS_BIRTHDATE_ERROR_CODE column indicates which parts of the birthdate match the reference data.
| Value | Description |
|---|---|
000 |
The year, month, and day are identical. |
001 |
The year and month are the same, but the day is different. |
010 |
The year and day are the same, but the month is different. |
100 |
The month and day are the same, but the year is different. |
011 |
The year is the same, but the month and day are different. |
101 |
The month is the same, but the year and day are different. |
110 |
The day is the same, but the year and month are different. |
111 |
The year, month, and day are different. |
--- |
No date is available in the reference database. |
Best practices
- Use
DQE_IDCHECK_PLUS_ERROR_CODEto identify whether the individual or household was found at the provided address. - Use field-level comparison codes to understand which fields matched exactly and which fields differ.
- Review
EMPTYresults by checking whether the required identification fields were provided in the input file. - Use the birthdate comparison code only when birthdate is part of your subscribed processing configuration.
- Do not rely only on the overall result when your business process requires detailed field-level comparison.