Phone Plus output columns

When the Phone Plus process is enabled, DQE adds extended phone output columns to the processed file.

These columns help you understand whether the phone number is valid, whether the phone is switched on, whether it is a mobile or landline number, and whether portability information is available.

Who should read this article

Use this article if your file-based batch processing includes Phone Plus validation and you need to understand the DQE phone 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 phone field names

Phone Plus output column names include the placeholder {FIELD_NAME_PHONE}.

This placeholder is replaced by the name of the input phone field processed by DQE.

For example, if your input phone column is named mobile, the output column DQE_{FIELD_NAME_PHONE}_ERROR_CODE may appear as DQE_mobile_ERROR_CODE.

Phone Plus columns

Phone Plus error code values

The DQE_{FIELD_NAME_PHONE}_ERROR_CODE column indicates the validation result returned by Phone Plus.

Mobile detection values

The DQE_{FIELD_NAME_PHONE}_IS_MOBILE column indicates whether DQE detected a mobile or landline number.

Portability values

The DQE_{FIELD_NAME_PHONE}_PORTED column indicates whether the phone number has been ported.

Best practices

• Use DQE_{FIELD_NAME_PHONE}_ERROR_CODE to identify invalid numbers and valid numbers with or without switch-on confirmation.
• Use DQE_{FIELD_NAME_PHONE} as the standardized phone number when your business rules allow it.
• Use DQE_{FIELD_NAME_PHONE}_IS_MOBILE to adapt communication channels such as SMS or voice calls.
• Use operator and portability information only when it is relevant to your business process.
• Keep the original input phone field so that you can compare it with the DQE reformatted value.

Related articles

• Understand DQE output columns
• Phone output columns
• Understand file-based batch processing