Phone Plus Output Columns
Use this article if your batch processing includes Phone Plus validation. Phone Plus extends standard Phone validation with operator, portability, and switch-on confirmation data. Applies to file-based batch processing only.
Dynamic phone field names
Phone output column names include the placeholder {FIELD_NAME_PHONE}. This is replaced by your actual input column name. Example: if your phone column is named mobile, then DQE_{FIELD_NAME_PHONE}_ERROR_CODE becomes DQE_mobile_ERROR_CODE.
Phone Plus columns
| Column | Description |
|---|---|
DQE_{FIELD_NAME_PHONE}_ERROR_CODE | Return code after Phone Plus processing |
DQE_{FIELD_NAME_PHONE} | Reformatted phone number |
DQE_{FIELD_NAME_PHONE}_IS_MOBILE | Mobile detection (True/False) |
DQE_{FIELD_NAME_PHONE}_OLD_OPERATOR | Previous operator (portability) |
DQE_{FIELD_NAME_PHONE}_OPERATOR | Current operator |
DQE_{FIELD_NAME_PHONE}_PORTED | Portability detection (Y/N) |
Phone Plus error code values
| Value | Description |
|---|---|
| 0 | Invalid or non-existing phone number |
| 1 | Valid number with confirmation that the phone is switched on |
| 2 | Valid number — no confirmation that the phone is switched on |
Mobile detection values
| Value | Description |
|---|---|
| False | Number is not a mobile |
| True | Number is a mobile |
Portability values
| Value | Description |
|---|---|
| Y | Number has been ported to a new operator |
| N | Number has not been ported |
Best practices
- Use
ERROR_CODEto distinguish invalid, valid-on, and valid-off numbers. - Use
IS_MOBILEto adapt communication channels. - Use operator and portability data only when relevant to your business process.
- Keep the original input phone field for comparison.