When the Gender process is enabled, DQE adds name and gender output columns to the processed file.
These columns help you understand whether first names and last names were recognized, whether a possible first name and last name inversion was detected, and which gender information or correction suggestion was returned by DQE.
Who should read this article
Use this article if your file-based batch processing includes Gender processing and you need to understand the DQE name and gender 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.
Dynamic name field names
Gender output column names include placeholders such as {FIELD_NAME_FIRSTNAME} and {FIELD_NAME_LASTNAME}.
These placeholders are replaced by the names of the input fields processed by DQE.
For example, if your input first name column is named firstname, the output column DQE_{FIELD_NAME_FIRSTNAME}_ERROR_CODE may appear as DQE_firstname_ERROR_CODE.
Gender columns
| Column | Description |
|---|---|
DQE_{FIELD_NAME_FIRSTNAME}_ERROR_CODE |
First name error code. |
DQE_{FIELD_NAME_FIRSTNAME}_ERROR |
First name error label. |
DQE_{FIELD_NAME_FIRSTNAME} |
Input first name. |
DQE_{FIELD_NAME_LASTNAME}_ERROR_CODE |
Last name error code. |
DQE_{FIELD_NAME_LASTNAME}_ERROR |
Last name error label. |
DQE_{FIELD_NAME_LASTNAME} |
Output last name. |
DQE_{FIELD_NAME_FIRSTNAME}_GENDER |
Civility. |
DQE_SUGGESTED_{FIELD_NAME_FIRSTNAME} |
DQE suggestion for first name correction. |
DQE_SUGGESTED_{FIELD_NAME_FIRSTNAME}_GENDER |
Civility for the DQE first name suggestion. |
DQE_SUGGESTED_{FIELD_NAME_FIRSTNAME}_ABSOLUTE_DISTANCE |
Distance in number of letters. |
DQE_SUGGESTED_{FIELD_NAME_FIRSTNAME}_RELATIVE_DISTANCE |
Distance according to the length of the string. |
First name error code values
The DQE_{FIELD_NAME_FIRSTNAME}_ERROR_CODE column indicates the result of the first name check.
| Value | Description |
|---|---|
0 |
Good first name. |
1 |
Empty first name. |
2 |
Unknown first name. |
4 |
First name and last name inversion. |
Last name error code values
The DQE_{FIELD_NAME_LASTNAME}_ERROR_CODE column indicates the result of the last name check.
| Value | Description |
|---|---|
0 |
Good last name. |
1 |
Empty last name. |
2 |
Unknown last name. |
4 |
First name and last name inversion. |
Suggested first name gender values
The DQE_SUGGESTED_{FIELD_NAME_FIRSTNAME}_GENDER column indicates the gender associated with the suggested first name.
| Value | Description |
|---|---|
D |
Dual: masculine or feminine. |
M |
Masculine. |
F |
Feminine. |
Best practices
- Use first name and last name error codes to identify empty, unknown, or inverted name fields.
- Review suggested first name corrections before applying them automatically to production data.
- Use distance values to assess how close the suggested first name is to the original input value.
- Keep the original input name fields so that you can compare them with DQE results and suggestions.